If your system does not have a zoneinfo database, you can use the downloadable package described in Section 10.6, "MySQL Server Time Zone Support". mysql_tzinfo_to_sql can be invoked several ways: shell> mysql_tzinfo_to_sql tz_dir shell> mysql_tzinfo_to_sql tz_file tz_name shell> ...
Description:Dear all, Hi. This is imacat from Taiwan. I'm using Debian GNU/Linux Sarge 3.1r2 Linux 2.6.16.14 x86_64, MySQL 5.0.22. I found that mysql_tzinfo_to_sql does not work with STRICT_ALL_TABLES. root@rinse:~# mysql_tzinfo_to_sql /usr/share/zoneinfo/ | mysql mysql Enter ...
If your system does not have a zoneinfo database, you can use the downloadable package described in Section 10.6, "MySQL Server Time Zone Support". mysql_tzinfo_to_sql can be invoked several ways: shell> mysql_tzinfo_to_sql tz_dir shell> mysql_tzinfo_to_sql tz_file tz_name shell> ...