Dont forget to load the rails timezones!

February 14, 2011

If your migrate to a new mysql database server and your information relies on dates and timezones, specially if you use the mysql timezone functions such as CONVERT_TZ then dont forget to load time zones into your rails db

If you are using ubuntu this works just fine:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

Comments

comments powered by Disqus