1MYSQL_TZINFO_TO_SQL(1)       MySQL Database System      MYSQL_TZINFO_TO_SQL(1)
2
3
4

NAME

6       mysql_tzinfo_to_sql - load the time zone tables
7

SYNOPSIS

9       mysql_tzinfo_to_sql arguments
10

DESCRIPTION

12       The mysql_tzinfo_to_sql program loads the time zone tables in the mysql
13       database. It is used on systems that have a zoneinfo database (the set
14       of files describing time zones). Examples of such systems are Linux,
15       FreeBSD, Solaris, and macOS. One likely location for these files is the
16       /usr/share/zoneinfo directory (/usr/share/lib/zoneinfo on Solaris). If
17       your system does not have a zoneinfo database, you can use the
18       downloadable package described in Section 5.1.15, “MySQL Server Time
19       Zone Support”.
20
21       mysql_tzinfo_to_sql can be invoked several ways:
22
23           shell> mysql_tzinfo_to_sql tz_dir
24           shell> mysql_tzinfo_to_sql tz_file tz_name
25           shell> mysql_tzinfo_to_sql --leap tz_file
26
27       For the first invocation syntax, pass the zoneinfo directory path name
28       to mysql_tzinfo_to_sql and send the output into the mysql program. For
29       example:
30
31           shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
32
33       mysql_tzinfo_to_sql reads your system's time zone files and generates
34       SQL statements from them.  mysql processes those statements to load the
35       time zone tables.
36
37       The second syntax causes mysql_tzinfo_to_sql to load a single time zone
38       file tz_file that corresponds to a time zone name tz_name:
39
40           shell> mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql
41
42       If your time zone needs to account for leap seconds, invoke
43       mysql_tzinfo_to_sql using the third syntax, which initializes the leap
44       second information.  tz_file is the name of your time zone file:
45
46           shell> mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql
47
48       After running mysql_tzinfo_to_sql, it is best to restart the server so
49       that it does not continue to use any previously cached time zone data.
50

52       Copyright © 1997, 2020, Oracle and/or its affiliates.
53
54       This documentation is free software; you can redistribute it and/or
55       modify it only under the terms of the GNU General Public License as
56       published by the Free Software Foundation; version 2 of the License.
57
58       This documentation is distributed in the hope that it will be useful,
59       but WITHOUT ANY WARRANTY; without even the implied warranty of
60       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
61       General Public License for more details.
62
63       You should have received a copy of the GNU General Public License along
64       with the program; if not, write to the Free Software Foundation, Inc.,
65       51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see
66       http://www.gnu.org/licenses/.
67
68

SEE ALSO

70       For more information, please refer to the MySQL Reference Manual, which
71       may already be installed locally and which is also available online at
72       http://dev.mysql.com/doc/.
73

AUTHOR

75       Oracle Corporation (http://dev.mysql.com/).
76
77
78
79MySQL 8.0                         11/26/2020            MYSQL_TZINFO_TO_SQL(1)
Impressum