Movatterモバイル変換

Themysql_tzinfo_to_sql program loads the time zone tables in themysql database. It is used on systems that have azoneinfo database (the set of files describing time zones). Examples of such systems are Linux, FreeBSD, Solaris, and macOS. One likely location for these files is the/usr/share/zoneinfo directory (/usr/share/lib/zoneinfo on Solaris). If your system does not have a zoneinfo database, you can use the downloadable package described inSection 7.1.15, “MySQL Server Time Zone Support”.

mysql_tzinfo_to_sql can be invoked several ways:

mysql_tzinfo_to_sqltz_dirmysql_tzinfo_to_sqltz_file tz_namemysql_tzinfo_to_sql --leaptz_file

For the first invocation syntax, pass the zoneinfo directory path name tomysql_tzinfo_to_sql and send the output into themysql program. For example:

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

mysql_tzinfo_to_sql reads your system's time zone files and generates SQL statements from them.mysql processes those statements to load the time zone tables.

The second syntax causesmysql_tzinfo_to_sql to load a single time zone filetz_file that corresponds to a time zone nametz_name:

mysql_tzinfo_to_sqltz_filetz_name | mysql -u root mysql

If your time zone needs to account for leap seconds, invokemysql_tzinfo_to_sql using the third syntax, which initializes the leap second information.tz_file is the name of your time zone file:

mysql_tzinfo_to_sql --leaptz_file | mysql -u root mysql

After runningmysql_tzinfo_to_sql, it is best to restart the server so that it does not continue to use any previously cached time zone data.