Author: paul
Date: 2006-12-06 21:22:58 +0100 (Wed, 06 Dec 2006)
New Revision: 4141
Log:
r16783@polar: paul | 2006-12-06 14:17:34 -0600
Add section/manpage for mysql_tzinfo_to_sql program.
Modified:
trunk/refman-4.1/database-administration.xml
trunk/refman-5.0/database-administration.xml
trunk/refman-5.1/database-administration.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:16780
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:13158
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:12611
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:16783
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:13158
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:12611
Modified: trunk/refman-4.1/database-administration.xml
===================================================================
--- trunk/refman-4.1/database-administration.xml 2006-12-06 19:29:17 UTC (rev 4140)
+++ trunk/refman-4.1/database-administration.xml 2006-12-06 20:22:58 UTC (rev 4141)
Changed blocks: 3, Lines Added: 120, Lines Deleted: 3; 5334 bytes
@@ -4596,7 +4596,8 @@
4.0.18), table names are stored as given but compared in
lowercase. From MySQL 4.0.2, this option also applies to
database names. From 4.1.1, it also applies to table
- aliases. See <xref linkend="identifier-case-sensitivity"/>.
+ aliases. See
+ <xref linkend="identifier-case-sensitivity"/>.
</para>
<para>
@@ -11622,6 +11623,123 @@
</section>
+ <section id="fake-id-for-mysql-tzinfo-to-sql-manpage-section-wrapper">
+
+ <title>fake title for mysql_tzinfo_to_sql manpage section wrapper</title>
+
+ <refentry id="mysql-tzinfo-to-sql">
+
+ <indexterm>
+ <primary>mysql_tzinfo_to_sql</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>time zone tables</primary>
+ </indexterm>
+
+ <refmeta>
+ <refentrytitle>mysql_tzinfo_to_sql</refentrytitle>
+
+ <manvolnum>1</manvolnum>
+ <refmiscinfo class="manual">MySQL Database System</refmiscinfo>
+ <refmiscinfo class="source">MySQL</refmiscinfo>
+ <refmiscinfo class="version">¤t-series;</refmiscinfo>
+ <refmiscinfo class="refman">Load the Time Zone Tables</refmiscinfo>
+ </refmeta>
+
+ <refnamediv>
+ <refname>mysql_tzinfo_to_sql</refname>
+
+ <refpurpose>load the time zone tables</refpurpose>
+ </refnamediv>
+
+ <refsynopsisdiv>
+ <cmdsynopsis>
+ <command>mysql_tzinfo_to_sql <replaceable>arguments</replaceable></command>
+ </cmdsynopsis>
+ </refsynopsisdiv>
+
+ <refsection id="mysql-tzinfo-to-sql-description">
+
+ <title>Description</title>
+
+ <para>
+ The <command>mysql_tzinfo_to_sql</command> program loads the
+ time zone tables in the <literal>mysql</literal> database.
+ It is used on systems that have a
+ <firstterm>zoneinfo</firstterm> 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 <filename>/usr/share/zoneinfo</filename>
+ directory. If your system does not have a zoneinfo database,
+ you can use the downloadable package described in
+ <xref linkend="time-zone-support"/>.
+ </para>
+
+ <para>
+ <command>mysql_tzinfo_to_sql</command> can be invoked
+ several ways:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql <replaceable>tz_dir</replaceable></userinput>
+shell> <userinput>mysql_tzinfo_to_sql <replaceable>tz_file tz_name</replaceable></userinput>
+shell> <userinput>mysql_tzinfo_to_sql --leap <replaceable>tz_file</replaceable></userinput>
+</programlisting>
+
+ <para>
+ For the first invocation syntax, pass the zoneinfo directory
+ pathname to <command>mysql_tzinfo_to_sql</command> and send
+ the output into the <command>mysql</command> program. For
+ example:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql</userinput>
+</programlisting>
+
+ <para>
+ <command>mysql_tzinfo_to_sql</command> reads your system's
+ time zone files and generates SQL statements from them.
+ <command>mysql</command> processes those statements to load
+ the time zone tables.
+ </para>
+
+ <para>
+ The second syntax causes
+ <command>mysql_tzinfo_to_sql</command> to load a single time
+ zone file <replaceable>tz_file</replaceable> that
+ corresponds to a time zone name
+ <replaceable>tz_name</replaceable>:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql <replaceable>tz_file</replaceable> <replaceable>tz_name</replaceable> | mysql -u root mysql</userinput>
+</programlisting>
+
+ <para>
+ If your time zone needs to account for leap seconds, invoke
+ <command>mysql_tzinfo_to_sql</command> using the third
+ syntax, which initializes the leap second information.
+ <replaceable>tz_file</replaceable> is the name of your time
+ zone file:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql --leap <replaceable>tz_file</replaceable> | mysql -u root mysql</userinput>
+</programlisting>
+
+ <para>
+ <command>mysql_tzinfo_to_sql</command> was added in MySQL
+ 4.1.3.
+ </para>
+
+ </refsection>
+
+ </refentry>
+
+ </section>
+
</section>
<section id="security">
@@ -21993,8 +22111,7 @@
<para>
<command>mysql_tzinfo_to_sql</command> also can be used to load
- a single time zone file, and to generate leap second
- information:
+ a single time zone file or to generate leap second information:
</para>
<itemizedlist>
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2006-12-06 19:29:17 UTC (rev 4140)
+++ trunk/refman-5.0/database-administration.xml 2006-12-06 20:22:58 UTC (rev 4141)
Changed blocks: 2, Lines Added: 113, Lines Deleted: 2; 4777 bytes
@@ -15034,6 +15034,118 @@
</section>
+ <section id="fake-id-for-mysql-tzinfo-to-sql-manpage-section-wrapper">
+
+ <title>fake title for mysql_tzinfo_to_sql manpage section wrapper</title>
+
+ <refentry id="mysql-tzinfo-to-sql">
+
+ <indexterm>
+ <primary>mysql_tzinfo_to_sql</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>time zone tables</primary>
+ </indexterm>
+
+ <refmeta>
+ <refentrytitle>mysql_tzinfo_to_sql</refentrytitle>
+
+ <manvolnum>1</manvolnum>
+ <refmiscinfo class="manual">MySQL Database System</refmiscinfo>
+ <refmiscinfo class="source">MySQL</refmiscinfo>
+ <refmiscinfo class="version">¤t-series;</refmiscinfo>
+ <refmiscinfo class="refman">Load the Time Zone Tables</refmiscinfo>
+ </refmeta>
+
+ <refnamediv>
+ <refname>mysql_tzinfo_to_sql</refname>
+
+ <refpurpose>load the time zone tables</refpurpose>
+ </refnamediv>
+
+ <refsynopsisdiv>
+ <cmdsynopsis>
+ <command>mysql_tzinfo_to_sql <replaceable>arguments</replaceable></command>
+ </cmdsynopsis>
+ </refsynopsisdiv>
+
+ <refsection id="mysql-tzinfo-to-sql-description">
+
+ <title>Description</title>
+
+ <para>
+ The <command>mysql_tzinfo_to_sql</command> program loads the
+ time zone tables in the <literal>mysql</literal> database.
+ It is used on systems that have a
+ <firstterm>zoneinfo</firstterm> 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 <filename>/usr/share/zoneinfo</filename>
+ directory. If your system does not have a zoneinfo database,
+ you can use the downloadable package described in
+ <xref linkend="time-zone-support"/>.
+ </para>
+
+ <para>
+ <command>mysql_tzinfo_to_sql</command> can be invoked
+ several ways:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql <replaceable>tz_dir</replaceable></userinput>
+shell> <userinput>mysql_tzinfo_to_sql <replaceable>tz_file tz_name</replaceable></userinput>
+shell> <userinput>mysql_tzinfo_to_sql --leap <replaceable>tz_file</replaceable></userinput>
+</programlisting>
+
+ <para>
+ For the first invocation syntax, pass the zoneinfo directory
+ pathname to <command>mysql_tzinfo_to_sql</command> and send
+ the output into the <command>mysql</command> program. For
+ example:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql</userinput>
+</programlisting>
+
+ <para>
+ <command>mysql_tzinfo_to_sql</command> reads your system's
+ time zone files and generates SQL statements from them.
+ <command>mysql</command> processes those statements to load
+ the time zone tables.
+ </para>
+
+ <para>
+ The second syntax causes
+ <command>mysql_tzinfo_to_sql</command> to load a single time
+ zone file <replaceable>tz_file</replaceable> that
+ corresponds to a time zone name
+ <replaceable>tz_name</replaceable>:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql <replaceable>tz_file</replaceable> <replaceable>tz_name</replaceable> | mysql -u root mysql</userinput>
+</programlisting>
+
+ <para>
+ If your time zone needs to account for leap seconds, invoke
+ <command>mysql_tzinfo_to_sql</command> using the third
+ syntax, which initializes the leap second information.
+ <replaceable>tz_file</replaceable> is the name of your time
+ zone file:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql --leap <replaceable>tz_file</replaceable> | mysql -u root mysql</userinput>
+</programlisting>
+
+ </refsection>
+
+ </refentry>
+
+ </section>
+
</section>
<section id="security">
@@ -25443,8 +25555,7 @@
<para>
<command>mysql_tzinfo_to_sql</command> also can be used to load
- a single time zone file, and to generate leap second
- information:
+ a single time zone file or to generate leap second information:
</para>
<itemizedlist>
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2006-12-06 19:29:17 UTC (rev 4140)
+++ trunk/refman-5.1/database-administration.xml 2006-12-06 20:22:58 UTC (rev 4141)
Changed blocks: 3, Lines Added: 120, Lines Deleted: 9; 5835 bytes
@@ -955,13 +955,13 @@
</para>
<para>
- As of MySQL 5.1.12, using <option>--with-debug</option>
- to configure MySQL with debugging support enables you to
- use the <option>--debug="d,parser_debug"</option> option
- when you start the server. This causes the Bison parser
- that is used to process SQL statements to dump a parser
- trace to the server's standard error output. Typically,
- this output is written to the error log.
+ As of MySQL 5.1.12, using <option>--with-debug</option> to
+ configure MySQL with debugging support enables you to use
+ the <option>--debug="d,parser_debug"</option> option when
+ you start the server. This causes the Bison parser that is
+ used to process SQL statements to dump a parser trace to
+ the server's standard error output. Typically, this output
+ is written to the error log.
</para>
</listitem>
@@ -15454,6 +15454,118 @@
</section>
+ <section id="fake-id-for-mysql-tzinfo-to-sql-manpage-section-wrapper">
+
+ <title>fake title for mysql_tzinfo_to_sql manpage section wrapper</title>
+
+ <refentry id="mysql-tzinfo-to-sql">
+
+ <indexterm>
+ <primary>mysql_tzinfo_to_sql</primary>
+ </indexterm>
+
+ <indexterm>
+ <primary>time zone tables</primary>
+ </indexterm>
+
+ <refmeta>
+ <refentrytitle>mysql_tzinfo_to_sql</refentrytitle>
+
+ <manvolnum>1</manvolnum>
+ <refmiscinfo class="manual">MySQL Database System</refmiscinfo>
+ <refmiscinfo class="source">MySQL</refmiscinfo>
+ <refmiscinfo class="version">¤t-series;</refmiscinfo>
+ <refmiscinfo class="refman">Load the Time Zone Tables</refmiscinfo>
+ </refmeta>
+
+ <refnamediv>
+ <refname>mysql_tzinfo_to_sql</refname>
+
+ <refpurpose>load the time zone tables</refpurpose>
+ </refnamediv>
+
+ <refsynopsisdiv>
+ <cmdsynopsis>
+ <command>mysql_tzinfo_to_sql <replaceable>arguments</replaceable></command>
+ </cmdsynopsis>
+ </refsynopsisdiv>
+
+ <refsection id="mysql-tzinfo-to-sql-description">
+
+ <title>Description</title>
+
+ <para>
+ The <command>mysql_tzinfo_to_sql</command> program loads the
+ time zone tables in the <literal>mysql</literal> database.
+ It is used on systems that have a
+ <firstterm>zoneinfo</firstterm> 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 <filename>/usr/share/zoneinfo</filename>
+ directory. If your system does not have a zoneinfo database,
+ you can use the downloadable package described in
+ <xref linkend="time-zone-support"/>.
+ </para>
+
+ <para>
+ <command>mysql_tzinfo_to_sql</command> can be invoked
+ several ways:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql <replaceable>tz_dir</replaceable></userinput>
+shell> <userinput>mysql_tzinfo_to_sql <replaceable>tz_file tz_name</replaceable></userinput>
+shell> <userinput>mysql_tzinfo_to_sql --leap <replaceable>tz_file</replaceable></userinput>
+</programlisting>
+
+ <para>
+ For the first invocation syntax, pass the zoneinfo directory
+ pathname to <command>mysql_tzinfo_to_sql</command> and send
+ the output into the <command>mysql</command> program. For
+ example:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql</userinput>
+</programlisting>
+
+ <para>
+ <command>mysql_tzinfo_to_sql</command> reads your system's
+ time zone files and generates SQL statements from them.
+ <command>mysql</command> processes those statements to load
+ the time zone tables.
+ </para>
+
+ <para>
+ The second syntax causes
+ <command>mysql_tzinfo_to_sql</command> to load a single time
+ zone file <replaceable>tz_file</replaceable> that
+ corresponds to a time zone name
+ <replaceable>tz_name</replaceable>:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql <replaceable>tz_file</replaceable> <replaceable>tz_name</replaceable> | mysql -u root mysql</userinput>
+</programlisting>
+
+ <para>
+ If your time zone needs to account for leap seconds, invoke
+ <command>mysql_tzinfo_to_sql</command> using the third
+ syntax, which initializes the leap second information.
+ <replaceable>tz_file</replaceable> is the name of your time
+ zone file:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql_tzinfo_to_sql --leap <replaceable>tz_file</replaceable> | mysql -u root mysql</userinput>
+</programlisting>
+
+ </refsection>
+
+ </refentry>
+
+ </section>
+
</section>
<section id="security">
@@ -25922,8 +26034,7 @@
<para>
<command>mysql_tzinfo_to_sql</command> also can be used to load
- a single time zone file, and to generate leap second
- information:
+ a single time zone file or to generate leap second information:
</para>
<itemizedlist>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r4141 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 6 Dec |
