Details
-
Technical task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.7(EOL), 10.8(EOL)
-
None
Description
Implement binary changes enumerated in MDEV-26946
Proposed texts as per MDEV-26946:
$ ./bin/mysqldump --help --verbose | grep -A3 -m1 'as-of'
|
--as-of=name Dump system versioned tables as of the specified timestamp.
|
Note that table structures are always dumped, irrespective of
|
the date/time specified. Note that the timestamp is interpreted
|
according to the --tz-utc setting (ref MDEV-26943 and --tz-utc).
|
|
$ ./bin/mysqldump --help --verbose | grep -A5 -m1 'tz-utc'
|
--tz-utc This option enables TIMESTAMP columns to be dumped and
|
reloaded between servers in different time zones.
|
mysqldump sets its connection time zone to UTC before
|
commencing the dump, and adds SET TIME_ZONE=´+00:00´
|
to the top of the dump file.
|
Attachments
Issue Links
- is caused by
-
MDEV-16355 Add option for mysqldump to read data as of specific timestamp from system-versioned tables
- Closed
- split from
-
MDEV-26946 Various small mysqldump manual improvements for the --as-of and --tz-utc options
- Open