2
.\" Title: \fBmysql_tzinfo_to_sql\fR
3
.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4
.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/>
6
.\" Manual: MySQL Database System
10
.TH "\FBMYSQL_TZINFO_TO_S" "1" "03/01/2010" "MySQL 5\&.1" "MySQL Database System"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
14
.\" disable hyphenation
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
21
.\" mysql_tzinfo_to_sql
24
mysql_tzinfo_to_sql \- load the time zone tables
26
.HP \w'\fBmysql_tzinfo_to_sql\ \fR\fB\fIarguments\fR\fR\ 'u
27
\fBmysql_tzinfo_to_sql \fR\fB\fIarguments\fR\fR
31
\fBmysql_tzinfo_to_sql\fR
32
program loads the time zone tables in the
34
database\&. It is used on systems that have a
36
database (the set of files describing time zones)\&. Examples of such systems are Linux, FreeBSD, Sun Solaris, and Mac OS X\&. One likely location for these files is the
38
directory (/usr/share/lib/zoneinfo
39
on Solaris)\&. If your system does not have a zoneinfo database, you can use the downloadable package described in
40
Section\ \&9.6, \(lqMySQL Server Time Zone Support\(rq\&.
42
\fBmysql_tzinfo_to_sql\fR
43
can be invoked several ways:
49
shell> \fBmysql_tzinfo_to_sql \fR\fB\fItz_dir\fR\fR
50
shell> \fBmysql_tzinfo_to_sql \fR\fB\fItz_file tz_name\fR\fR
51
shell> \fBmysql_tzinfo_to_sql \-\-leap \fR\fB\fItz_file\fR\fR
57
For the first invocation syntax, pass the zoneinfo directory path name to
58
\fBmysql_tzinfo_to_sql\fR
59
and send the output into the
61
program\&. For example:
67
shell> \fBmysql_tzinfo_to_sql /usr/share/zoneinfo | mysql \-u root mysql\fR
73
\fBmysql_tzinfo_to_sql\fR
74
reads your system\'s time zone files and generates SQL statements from them\&.
76
processes those statements to load the time zone tables\&.
78
The second syntax causes
79
\fBmysql_tzinfo_to_sql\fR
80
to load a single time zone file
82
that corresponds to a time zone name
89
shell> \fBmysql_tzinfo_to_sql \fR\fB\fItz_file\fR\fR\fB \fR\fB\fItz_name\fR\fR\fB | mysql \-u root mysql\fR
95
If your time zone needs to account for leap seconds, invoke
96
\fBmysql_tzinfo_to_sql\fR
97
using the third syntax, which initializes the leap second information\&.
99
is the name of your time zone file:
105
shell> \fBmysql_tzinfo_to_sql \-\-leap \fR\fB\fItz_file\fR\fR\fB | mysql \-u root mysql\fR
112
\fBmysql_tzinfo_to_sql\fR, it is best to restart the server so that it does not continue to use any previously cached time zone data\&.
116
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
118
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
120
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
122
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
125
For more information, please refer to the MySQL Reference Manual,
126
which may already be installed locally and which is also available
127
online at http://dev.mysql.com/doc/.
129
Sun Microsystems, Inc. (http://www.mysql.com/).