Loading MySQL timezone info on Linux and Macs
MySQL has some really useful functions that make timezone support a bit easier as described in a previous blog post..
However, you need to do a tiny bit of setup work before you can use the functions. You need to load the timezone info from your system into the mysql db.
Thankfully, the MySQL Developers have included a very handy script that will do just that from a zoneinfo files which are used on Linux and on Mac's.
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
Obviously change the mysql params or add a -p if you have a password or are connecting to a remote server.
Check out the MySQL developer site for full details on MySQL timezone support
Cheers, Mark
There are no comments for this entry.
[Add Comment]