MySQL Forums
Forum List  »  Newbie

MySQL 5.5 - Which Timezone Tables to use in Mixed Windows Linux Environment?
Posted by: IGG t
Date: October 05, 2016 02:59AM

I'm looking to install the MySQL TimeZone Tables to my databases, but I have a mixture of Windows and Linux Databases. I'm using MySQL 5.5.

Looking at the documentation it says:

Warning

Do not use a downloadable package if your system has a zoneinfo database. Use the mysql_tzinfo_to_sql utility instead. Otherwise, you may cause a difference in datetime handling between MySQL and other applications on your system.
http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html

However, my Master databases are all Windows, with most (but not all) the slaves being on Linux (Debian). So should I run the mysql_tzinfo_to_sql on one of the Linux databases, and then copy the data onto the master to replicate through the system, or am I ok to use the one that I have downloaded as a Zip file for use on Windows?

Options: ReplyQuote


Subject
Written By
Posted
MySQL 5.5 - Which Timezone Tables to use in Mixed Windows Linux Environment?
October 05, 2016 02:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.