2 .\" Title: \fBmysql_tzinfo_to_sql\fR
3 .\" Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4 .\" Generator: DocBook XSL Stylesheets v1.77.1 <http://docbook.sf.net/>
6 .\" Manual: MySQL Database System
10 .TH "\FBMYSQL_TZINFO_TO_S" "1" "11/04/2013" "MySQL 5\&.1" "MySQL Database System"
11 .\" -----------------------------------------------------------------
12 .\" * Define some portability stuff
13 .\" -----------------------------------------------------------------
14 .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
15 .\" http://bugs.debian.org/507673
16 .\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
17 .\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
20 .\" -----------------------------------------------------------------
21 .\" * set default formatting
22 .\" -----------------------------------------------------------------
23 .\" disable hyphenation
25 .\" disable justification (adjust text to left margin only)
27 .\" -----------------------------------------------------------------
28 .\" * MAIN CONTENT STARTS HERE *
29 .\" -----------------------------------------------------------------
30 .\" mysql_tzinfo_to_sql
33 mysql_tzinfo_to_sql \- load the time zone tables
35 .HP \w'\fBmysql_tzinfo_to_sql\ \fR\fB\fIarguments\fR\fR\ 'u
36 \fBmysql_tzinfo_to_sql \fR\fB\fIarguments\fR\fR
40 \fBmysql_tzinfo_to_sql\fR
41 program loads the time zone tables in the
43 database\&. It is used on systems that have a
45 database (the set of files describing time zones)\&. Examples of such systems are Linux, FreeBSD, Solaris, and Mac OS X\&. One likely location for these files is the
47 directory (/usr/share/lib/zoneinfo
48 on Solaris)\&. If your system does not have a zoneinfo database, you can use the downloadable package described in
49 Section\ \&10.6, \(lqMySQL Server Time Zone Support\(rq\&.
51 \fBmysql_tzinfo_to_sql\fR
52 can be invoked several ways:
58 shell> \fBmysql_tzinfo_to_sql \fR\fB\fItz_dir\fR\fR
59 shell> \fBmysql_tzinfo_to_sql \fR\fB\fItz_file tz_name\fR\fR
60 shell> \fBmysql_tzinfo_to_sql \-\-leap \fR\fB\fItz_file\fR\fR
66 For the first invocation syntax, pass the zoneinfo directory path name to
67 \fBmysql_tzinfo_to_sql\fR
68 and send the output into the
70 program\&. For example:
76 shell> \fBmysql_tzinfo_to_sql /usr/share/zoneinfo | mysql \-u root mysql\fR
82 \fBmysql_tzinfo_to_sql\fR
83 reads your system\*(Aqs time zone files and generates SQL statements from them\&.
85 processes those statements to load the time zone tables\&.
87 The second syntax causes
88 \fBmysql_tzinfo_to_sql\fR
89 to load a single time zone file
91 that corresponds to a time zone name
98 shell> \fBmysql_tzinfo_to_sql \fR\fB\fItz_file\fR\fR\fB \fR\fB\fItz_name\fR\fR\fB | mysql \-u root mysql\fR
104 If your time zone needs to account for leap seconds, invoke
105 \fBmysql_tzinfo_to_sql\fR
106 using the third syntax, which initializes the leap second information\&.
108 is the name of your time zone file:
114 shell> \fBmysql_tzinfo_to_sql \-\-leap \fR\fB\fItz_file\fR\fR\fB | mysql \-u root mysql\fR
121 \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\&.
125 Copyright \(co 1997, 2013, Oracle and/or its affiliates. All rights reserved.
127 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.
129 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.
131 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/.
134 For more information, please refer to the MySQL Reference Manual,
135 which may already be installed locally and which is also available
136 online at http://dev.mysql.com/doc/.
138 Oracle Corporation (http://dev.mysql.com/).