MYSQL_TZINFO_TO_S(1)         MySQL Database System        MYSQL_TZINFO_TO_S(1)
2
3
4

NAME
6       mysql_tzinfo_to_sql - load the time zone tables
7

SYNOPSIS
9       mysql_tzinfo_to_sql arguments
10

DESCRIPTION
12       The mysql_tzinfo_to_sql program loads the time zone tables in the mysql
13       database. It is used on systems that have a zoneinfo database (the set
14       of files describing time zones). Examples of such systems are Linux,
15       FreeBSD, Sun Solaris, and Mac OS X. One likely location for these files
16       is the /usr/share/zoneinfo directory. If your system does not have a
17       zoneinfo database, you can use the downloadable package described in
18       Section 8.8, “MySQL Server Time Zone Support”.
19
20       mysql_tzinfo_to_sql can be invoked several ways:
21
22          shell> mysql_tzinfo_to_sql tz_dir
23          shell> mysql_tzinfo_to_sql tz_file tz_name
24          shell> mysql_tzinfo_to_sql --leap tz_file
25
26       For the first invocation syntax, pass the zoneinfo directory pathname
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

48       Copyright 1997-2007 MySQL AB
49
50       This documentation is NOT distributed under a GPL license. Use of this
51       documentation is subject to the following terms: You may create a
52       printed copy of this documentation solely for your own personal use.
53       Conversion to other formats is allowed as long as the actual content is
54       not altered or edited in any way. You shall not publish or distribute
55       this documentation in any form or on any media, except if you
56       distribute the documentation in a manner similar to how MySQL
57       disseminates it (that is, electronically for download on a Web site
58       with the software) or on a CD-ROM or similar medium, provided however
59       that the documentation is disseminated together with the software on
60       the same medium. Any other use, such as any dissemination of printed
61       copies or use of this documentation, in whole or in part, in another
62       publication, requires the prior written consent from an authorized
63       representative of MySQL AB. MySQL AB reserves any and all rights to
64       this documentation not expressly granted above.
65
66       Please email <docs@mysql.com> for more information.
67

SEE ALSO
69       For more information, please refer to the MySQL Reference Manual, which
70       may already be installed locally and which is also available online at
71       http://dev.mysql.com/doc/.
72

AUTHOR
74       MySQL AB (http://www.mysql.com/).  This software comes with no
75       warranty.
76
77
78

MySQL 5.0                         07/04/2007              MYSQL_TZINFO_TO_S(1)


        

    


            
        

        

            Impressum