1
vote
2answers
31 views

MySQL Timezone Resets after exiting server

I am running this code to set my database's timezone: set time_zone = "US/Eastern" This successfully changes the time to the correct time. However, as soon as I "exit" the database and re-enter, it ...
0
votes
2answers
883 views

MySQL timestamp timezone handling

Does the timestamp data type represent an instant-in-time or a year-month-date-hour-minute-second value? An instant in time is a moment, like the moment you started reading this, and it can be ...
0
votes
0answers
72 views

Is US/Pacific timezone in MySQL automatically adjusting to DST?

I'd like to define a view in MySQL which will convert some system data always written in UTC to our headquarter time, which is San Francisco. If I use CONVERT_TZ(..., 'UTC', 'US/Pacific'), will it ...
0
votes
1answer
697 views

Seting timezone per database in MySQL

I wanted to know if MySQL let the admin set a timezone per database ? I have three different databases for three different customers. Each of them being in their own timezone. I would like to load ...
1
vote
2answers
1k views

My MySQL server time is not the same as my Server

So a month ago I had purchased a server from a hosting company. The info are; Linux Centos (latest version). I installed ZPanel which installs phpMyAdmin, MySQL and all the other good stuff. ...
0
votes
1answer
213 views

MYSQL Timezone support

We are having a shared hosting plan and they are saying that do provide MYSQL Timezone support in a shared hosting plan. I can create timezone related tables in our database and populate them with ...
0
votes
1answer
868 views

MySQL PDO Cannot assign requested address

Can someone help me with this error? [08-Apr-2013 17:44:08 Europe/Berlin] PHP Warning: PDO::__construct(): [2002] Cannot assign requested address (trying to connect via tcp://****:3306) in ...
1
vote
1answer
922 views

How to get SQL of single time zone

Trying to get the SQL for a single time zone results in an error message: $ mysql_tzinfo_to_sql /usr/share/zoneinfo America/Sao_Paulo mysql_tzinfo_to_sql: Error reading file '/usr/share/zoneinfo' ...