diff options
| author | unknown <guilhem@gbichot4.local> | 2007-11-20 10:25:07 +0100 |
|---|---|---|
| committer | unknown <guilhem@gbichot4.local> | 2007-11-20 10:25:07 +0100 |
| commit | 10c930c6fd93c7cc06282659eeaecc2559ad760f (patch) | |
| tree | 634623c927632b7397cdb0706c2fb3a3bb1bc74b /client | |
| parent | 5a8cff4e1f93cf83b4661c2e2e83f591c49cc49d (diff) | |
| download | mariadb-git-10c930c6fd93c7cc06282659eeaecc2559ad760f.tar.gz | |
BUG#27850 "mysqldump --single-transaction does not work if TRUNCATE/DROP/RENAME/ALTER":
this has already been closed by a note in the manual, now we
complete this by a note in "mysqldump --help"
client/mysqldump.c:
mention, in "mysqldump --help", of limitations reported as BUG#27850
"mysqldump --single-transaction does not work if TRUNCATE/DROP/RENAME/ALTER"
The new text is inspired from what the "mysqldump" section of the
manual now says about --single-transaction:
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
Diffstat (limited to 'client')
| -rw-r--r-- | client/mysqldump.c | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/client/mysqldump.c b/client/mysqldump.c index 4916492201b..0b4951e1cf3 100644 --- a/client/mysqldump.c +++ b/client/mysqldump.c @@ -404,8 +404,12 @@ static struct my_option my_long_options[] = "Creates a consistent snapshot by dumping all tables in a single " "transaction. Works ONLY for tables stored in storage engines which " "support multiversioning (currently only InnoDB does); the dump is NOT " - "guaranteed to be consistent for other storage engines. Option " - "automatically turns off --lock-tables.", + "guaranteed to be consistent for other storage engines. " + "While a --single-transaction dump is in process, to ensure a valid " + "dump file (correct table contents and binary log position), no other " + "connection should use the following statements: ALTER TABLE, DROP " + "TABLE, RENAME TABLE, TRUNCATE TABLE, as consistent snapshot is not " + "isolated from them. Option automatically turns off --lock-tables.", (gptr*) &opt_single_transaction, (gptr*) &opt_single_transaction, 0, GET_BOOL, NO_ARG, 0, 0, 0, 0, 0, 0}, {"skip-opt", OPT_SKIP_OPTIMIZATION, |