Skip to main content

--tz-utc

This page is part of MariaDB's MariaDB Documentation.

The parent of this page is: mariadb-dump & mysqldump

Topics on this page:

Overview
CHANGE HISTORY

Overview

This is a command-line option for the mariadb-dump & mysqldump commands.

In 10.6 ES, 10.5 ES, 10.4 ES, 10.3 ES:: Set connection time zone to UTC before commencing the dump and add SET TIME_ZONE=´+00:00´ to the top of the dump file. (Defaults to on; use --skip-tz-utc to disable.)

In 10.6 ES, 10.5 ES, 10.4 ES:: Set connection time zone to UTC before commencing the dump and add SET TIME_ZONE=´+00:00´ to the top of the dump file. (Defaults to on; use --skip-tz-utc to disable.)

In 10.6 CS, 10.5 CS, 10.4 CS, 10.3 CS, 10.2 ES, 10.2 CS:: SET TIME_ZONE='+00:00' at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones. (Defaults to on; use --skip-tz-utc to disable.)

See also: Options for mariadb-dump & mysqldump in MariaDB Enterprise Server 10.6, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS

See also: Options for mariadb-dump & mysqldump in MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1.
10.6 Community	Present starting in MariaDB Community Server 10.6.0.
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1.
10.5 Community	Present starting in MariaDB Community Server 10.5.0.
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1.
10.4 Community	Present starting in MariaDB Community Server 10.4.0.
10.3 Enterprise	Present starting in MariaDB Enterprise Server 10.3.16-1.
10.3 Community	Present starting in MariaDB Community Server 10.3.0.
10.2 Enterprise	Present starting in MariaDB Enterprise Server 10.2.25-1.
10.2 Community	Present starting in MariaDB Community Server 10.2.0.

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1.
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1.
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1.