1MARIADB-TZINFO-TO-S(1)      MariaDB Database System     MARIADB-TZINFO-TO-S(1)
2
3
4

NAME

6       mariadb-tzinfo-to-sql - load the time zone tables (mysql_tzinfo_to_sql
7       is now a symlink to mariadb-tzinfo-to-sql)
8

SYNOPSIS

10       mysql_tzinfo_to_sql arguments
11

DESCRIPTION

13       The mysql_tzinfo_to_sql program loads the time zone tables in the mysql
14       database. It is used on systems that have a zoneinfo database (the set
15       of files describing time zones). Examples of such systems are Linux,
16       FreeBSD, Solaris, and Mac OS X. One likely location for these files is
17       the /usr/share/zoneinfo directory (/usr/share/lib/zoneinfo on Solaris).
18
19       mysql_tzinfo_to_sql can be invoked several ways:
20
21           shell> mysql_tzinfo_to_sql tz_dir
22           shell> mysql_tzinfo_to_sql tz_file tz_name
23           shell> mysql_tzinfo_to_sql --leap tz_file
24           shell> mysql_tzinfo_to_sql --skip-write-binlog tz_dir
25
26       For the first invocation syntax, pass the zoneinfo directory path name
27       to mysql_tzinfo_to_sql and send the output into the mysql program. For
28       example:
29
30           shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
31
32       mysql_tzinfo_to_sql reads your system´s time zone files and generates
33       SQL statements from them.  mysql processes those statements to load the
34       time zone tables.
35
36       The second syntax causes mysql_tzinfo_to_sql to load a single time zone
37       file tz_file that corresponds to a time zone name tz_name:
38
39           shell> mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql
40
41       If your time zone needs to account for leap seconds, invoke
42       mysql_tzinfo_to_sql using the third syntax, which initializes the leap
43       second information.  tz_file is the name of your time zone file:
44
45           shell> mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql
46
47       Using the --skip-write-binlog option prevents writing of changes to the
48       binary log or to other Galera cluster members. This can be used with
49       any form of running mysql_tzinfo_to_sql.
50
51       After running mysql_tzinfo_to_sql, it is best to restart the server so
52       that it does not continue to use any previously cached time zone data.
53

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

SEE ALSO

74       For more information, please refer to the MariaDB Knowledge Base,
75       available online at https://mariadb.com/kb/
76

AUTHOR

78       MariaDB Foundation (http://www.mariadb.org/).
79
80
81
82MariaDB 10.5                     27 June 2019           MARIADB-TZINFO-TO-S(1)
Impressum