diff options
| author | intrigeri <intrigeri@boum.org> | 2008-12-09 11:40:03 +0000 |
|---|---|---|
| committer | intrigeri <intrigeri@boum.org> | 2008-12-09 11:40:03 +0000 |
| commit | 2cfcdd636d21e353f061fdc563c4b6dee3a4d979 (patch) | |
| tree | e0f593b0c2613fd0f1fb5f2cc90d993614f9e6d2 | |
| parent | 4506202ea78d5c5829113d6f2a183c540585cd5d (diff) | |
| download | backupninja-2cfcdd636d21e353f061fdc563c4b6dee3a4d979.tar.gz backupninja-2cfcdd636d21e353f061fdc563c4b6dee3a4d979.tar.bz2 | |
mysql: new sqldumpoptions config variable (Closes: #502966)
| -rw-r--r-- | ChangeLog | 4 | ||||
| -rw-r--r-- | examples/example.mysql | 4 | ||||
| -rw-r--r-- | handlers/mysql.helper.in | 5 | ||||
| -rw-r--r-- | handlers/mysql.in | 3 |
4 files changed, 15 insertions, 1 deletions
@@ -6,6 +6,10 @@ version 0.9.7 -- UNRELEASED maildir: . fix location of deleted_on file . add missing destid_file options to ssh connections + mysql: + . Options passed to mysqldump are now customizable with the new + sqldumpoptions configuration variable. Thanks to Chris Lamb for his + preliminary patch (Closes: #502966) version 0.9.6 -- July 21, 2008 backupninja changes diff --git a/examples/example.mysql b/examples/example.mysql index bd996e7..de9651f 100644 --- a/examples/example.mysql +++ b/examples/example.mysql @@ -73,6 +73,10 @@ compress = yes # make a backup using mysqldump. this creates text files with sql commands # sufficient to recontruct the database. # +# sqldumpoptions = <options> +# (default = --lock-tables --complete-insert --add-drop-table --quick --quote-names) +# arguments to pass to mysqldump +# # compress = < yes | no > (default = yes) # if yes, compress the sqldump output. # diff --git a/handlers/mysql.helper.in b/handlers/mysql.helper.in index 9622d41..00eeca0 100644 --- a/handlers/mysql.helper.in +++ b/handlers/mysql.helper.in @@ -94,6 +94,11 @@ $hotcopy # $sqldump +# sqldumpoptions = <options> +# (default = --lock-tables --complete-insert --add-drop-table --quick --quote-names) +# arguments to pass to mysqldump +# sqldumpoptions = --add-drop-table --quick --quote-names + # compress = < yes | no > (default = yes) # if yes, compress the sqldump output. $compress diff --git a/handlers/mysql.in b/handlers/mysql.in index fe1e783..c80a36a 100644 --- a/handlers/mysql.in +++ b/handlers/mysql.in @@ -10,6 +10,7 @@ getconf nodata getconf dbhost localhost getconf hotcopy no getconf sqldump no +getconf sqldumpoptions "--lock-tables --complete-insert --add-drop-table --quick --quote-names" getconf compress yes getconf vsname @@ -245,7 +246,7 @@ then for db in $databases do - DUMP_BASE="$MYSQLDUMP $defaultsfile --lock-tables --complete-insert --add-drop-table --quick --quote-names" + DUMP_BASE="$MYSQLDUMP $defaultsfile $sqldumpoptions" # Dumping structure and data DUMP="$DUMP_BASE $ignore $db" |