mysql_tzinfo_to_sql man page on AIX

Man page or keyword search:  
man Server   4752 pages
apropos Keyword Search (all sections)
Output format
AIX logo
[printable version]

MYSQL_TZINFO_TO_S(1)	     MySQL Database System	  MYSQL_TZINFO_TO_S(1)

NAME
       mysql_tzinfo_to_sql - load the time zone tables

SYNOPSIS
       mysql_tzinfo_to_sql arguments

DESCRIPTION
       The mysql_tzinfo_to_sql program loads the time zone tables in the mysql
       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 /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, “MySQL Server Time
       Zone Support”.

       mysql_tzinfo_to_sql can be invoked several ways:

	  shell> mysql_tzinfo_to_sql tz_dir
	  shell> mysql_tzinfo_to_sql tz_file tz_name
	  shell> mysql_tzinfo_to_sql --leap tz_file

       For the first invocation syntax, pass the zoneinfo directory path name
       to mysql_tzinfo_to_sql and send the output into the mysql program. For
       example:

	  shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

       mysql_tzinfo_to_sql reads your system's time zone files and generates
       SQL statements from them.  mysql processes those statements to load the
       time zone tables.

       The second syntax causes mysql_tzinfo_to_sql to load a single time zone
       file tz_file that corresponds to a time zone name tz_name:

	  shell> mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql

       If your time zone needs to account for leap seconds, invoke
       mysql_tzinfo_to_sql using the third syntax, which initializes the leap
       second information.  tz_file is the name of your time zone file:

	  shell> mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql

       After running mysql_tzinfo_to_sql, it is best to restart the server so
       that it does not continue to use any previously cached time zone data.

COPYRIGHT
       Copyright 2007-2008 MySQL AB, 2009 Sun Microsystems, Inc.

       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.

       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.

       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/.

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/.

AUTHOR
       MySQL AB (http://www.mysql.com/).

MySQL 6.0			  04/30/2009		  MYSQL_TZINFO_TO_S(1)
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server AIX

List of man pages available for AIX

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net