Geek Answers Handbook

Load MySQL timezone tables

tries to load MySQL timezone tables, read many related records here and MySQL documents and cannot find a solution to my problem. I connect SSH via PUTTY as root and issue this command:

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

I get the following errors:

 Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.

Any idea how to resolve?

+5
source share
1 answer

This is not a mistake. These are warnings, and you can ignore them. Anyway, your timezone tables should be populated.

+5
source

More articles:


All Articles