diff options
Diffstat (limited to 'man/mysql_tzinfo_to_sql.1')
-rw-r--r-- | man/mysql_tzinfo_to_sql.1 | 74 |
1 files changed, 51 insertions, 23 deletions
diff --git a/man/mysql_tzinfo_to_sql.1 b/man/mysql_tzinfo_to_sql.1 index 7652f837ae2..3bf86f4a75b 100644 --- a/man/mysql_tzinfo_to_sql.1 +++ b/man/mysql_tzinfo_to_sql.1 @@ -1,19 +1,29 @@ +'\" t .\" Title: \fBmysql_tzinfo_to_sql\fR -.\" Author: -.\" Generator: DocBook XSL Stylesheets v1.70.1 <http://docbook.sf.net/> -.\" Date: 03/31/2009 +.\" Author: [FIXME: author] [see http://docbook.sf.net/el/author] +.\" Generator: DocBook XSL Stylesheets v1.75.2 <http://docbook.sf.net/> +.\" Date: 08/12/2009 .\" Manual: MySQL Database System .\" Source: MySQL 5.1 +.\" Language: English .\" -.TH "\fBMYSQL_TZINFO_TO_S" "1" "03/31/2009" "MySQL 5.1" "MySQL Database System" +.TH "\FBMYSQL_TZINFO_TO_S" "1" "08/12/2009" "MySQL 5\&.1" "MySQL Database System" +.\" ----------------------------------------------------------------- +.\" * set default formatting +.\" ----------------------------------------------------------------- .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l +.\" ----------------------------------------------------------------- +.\" * MAIN CONTENT STARTS HERE * +.\" ----------------------------------------------------------------- +.\" mysql_tzinfo_to_sql +.\" time zone tables .SH "NAME" mysql_tzinfo_to_sql \- load the time zone tables .SH "SYNOPSIS" -.HP 30 +.HP \w'\fBmysql_tzinfo_to_sql\ \fR\fB\fIarguments\fR\fR\ 'u \fBmysql_tzinfo_to_sql \fR\fB\fIarguments\fR\fR .SH "DESCRIPTION" .PP @@ -21,41 +31,49 @@ The \fBmysql_tzinfo_to_sql\fR program loads the time zone tables in the mysql -database. It is used on systems that have a +database\&. It is used on systems that have a zoneinfo -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 -\fI/usr/share/zoneinfo\fR -directory (\fI/usr/share/lib/zoneinfo\fR -on Solaris). If your system does not have a zoneinfo database, you can use the downloadable package described in -Section\ 9.7, \(lqMySQL Server Time Zone Support\(rq. +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 +/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 in +Section\ \&9.7, \(lqMySQL Server Time Zone Support\(rq\&. .PP \fBmysql_tzinfo_to_sql\fR can be invoked several ways: .sp -.RS 3n +.if n \{\ +.RS 4 +.\} .nf shell> \fBmysql_tzinfo_to_sql \fR\fB\fItz_dir\fR\fR shell> \fBmysql_tzinfo_to_sql \fR\fB\fItz_file tz_name\fR\fR shell> \fBmysql_tzinfo_to_sql \-\-leap \fR\fB\fItz_file\fR\fR .fi +.if n \{\ .RE +.\} .PP For the first invocation syntax, pass the zoneinfo directory path name to \fBmysql_tzinfo_to_sql\fR and send the output into the \fBmysql\fR -program. For example: +program\&. For example: .sp -.RS 3n +.if n \{\ +.RS 4 +.\} .nf shell> \fBmysql_tzinfo_to_sql /usr/share/zoneinfo | mysql \-u root mysql\fR .fi +.if n \{\ .RE +.\} .PP \fBmysql_tzinfo_to_sql\fR -reads your system's time zone files and generates SQL statements from them. +reads your system\'s time zone files and generates SQL statements from them\&. \fBmysql\fR -processes those statements to load the time zone tables. +processes those statements to load the time zone tables\&. .PP The second syntax causes \fBmysql_tzinfo_to_sql\fR @@ -64,38 +82,48 @@ to load a single time zone file that corresponds to a time zone name \fItz_name\fR: .sp -.RS 3n +.if n \{\ +.RS 4 +.\} .nf shell> \fBmysql_tzinfo_to_sql \fR\fB\fItz_file\fR\fR\fB \fR\fB\fItz_name\fR\fR\fB | mysql \-u root mysql\fR .fi +.if n \{\ .RE +.\} .PP If your time zone needs to account for leap seconds, invoke \fBmysql_tzinfo_to_sql\fR -using the third syntax, which initializes the leap second information. +using the third syntax, which initializes the leap second information\&. \fItz_file\fR is the name of your time zone file: .sp -.RS 3n +.if n \{\ +.RS 4 +.\} .nf shell> \fBmysql_tzinfo_to_sql \-\-leap \fR\fB\fItz_file\fR\fR\fB | mysql \-u root mysql\fR .fi +.if n \{\ .RE +.\} .PP After running -\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. +\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\&. .SH "COPYRIGHT" +.br .PP -Copyright 2007\-2008 MySQL AB, 2009 Sun Microsystems, Inc. +Copyright 2007-2008 MySQL AB, 2009 Sun Microsystems, Inc. .PP 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. .PP 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. .PP -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/. +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/. +.sp .SH "SEE ALSO" For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. .SH AUTHOR -MySQL AB (http://www.mysql.com/). +Sun Microsystems, Inc. (http://www.mysql.com/). |