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
-
Activity
IMHO, the original proposed text above has two advantages not present in the proposed patch;
1) MDEV-26943 is a helpful reference
2) "This option enables TIMESTAMP columns to be dumped and reloaded between servers in different time zones." is (and was) helpful
There is also a typo: "versioned table" should read "versioned table(s)" as it can be more than one.
Roel We do not specify MDEV references in the UI, do we?
As for 2) this is obvious for SA having servers in different time zones. Like I said, --help is not man page.
Updated description to match, thank you!