Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
MARIADB-TZINFO-TO-SQL(1)    MariaDB Database System   MARIADB-TZINFO-TO-SQL(1)

NAME
       mariadb-tzinfo-to-sql - load the	time zone tables (mariadb-tzinfo-to-
       sql is now a symlink to mariadb-tzinfo-to-sql)

SYNOPSIS

       mariadb-tzinfo-to-sql arguments

DESCRIPTION
       The mariadb-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, Solaris,	and Mac	OS X. One likely location for these
       files is	the /usr/share/zoneinfo	directory (/usr/share/lib/zoneinfo on
       Solaris).

       mariadb-tzinfo-to-sql can be invoked several ways:

	   shell> mariadb-tzinfo-to-sql	tz_dir
	   shell> mariadb-tzinfo-to-sql	tz_file	tz_name
	   shell> mariadb-tzinfo-to-sql	--leap tz_file
	   shell> mariadb-tzinfo-to-sql	--skip-write-binlog tz_dir

       For the first invocation	syntax,	pass the zoneinfo directory path name
       to mariadb-tzinfo-to-sql	and send the output into the mariadb program.
       For example:

	   shell> mariadb-tzinfo-to-sql	/usr/share/zoneinfo | mariadb -u root mysql

       mariadb-tzinfo-to-sql reads your	system's time zone files and generates
       SQL statements from them.  mariadb processes those statements to	load
       the time	zone tables.

       The second syntax causes	mariadb-tzinfo-to-sql to load a	single time
       zone file tz_file that corresponds to a time zone name tz_name:

	   shell> mariadb-tzinfo-to-sql	tz_file	tz_name	| mariadb -u root mysql

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

	   shell> mariadb-tzinfo-to-sql	--leap tz_file | mariadb -u root mysql

       Using the --skip-write-binlog option prevents writing of	changes	to the
       binary log or to	other Galera cluster members. This can be used with
       any form	of running mariadb-tzinfo-to-sql.

       After running mariadb-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, 2008-2010 Sun Microsystems, Inc.,
       2010-2024 MariaDB Foundation

       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-1335 USA or see
       http://www.gnu.org/licenses/.

SEE ALSO
       For more	information, please refer to the MariaDB Knowledge Base,
       available online	at https://mariadb.com/kb/

AUTHOR
       MariaDB Foundation (http://www.mariadb.org/).

MariaDB	11.4		       3 September 2024	      MARIADB-TZINFO-TO-SQL(1)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=mariadb-tzinfo-to-sql&sektion=1&manpath=FreeBSD+Ports+14.3.quarterly>

home | help