diff options
| author | intrigeri <intrigeri@boum.org> | 2012-05-20 13:11:12 +0200 |
|---|---|---|
| committer | intrigeri <intrigeri@boum.org> | 2012-05-20 13:11:12 +0200 |
| commit | b05065625c76c271448f493f515558cbe00b34ac (patch) | |
| tree | c793987674f304ea53abee8dfbcfd18621e0fa0c | |
| parent | d5a65fc0d683fcfd9ac87fd93c0c73edcdc09b40 (diff) | |
| download | backupninja-b05065625c76c271448f493f515558cbe00b34ac.tar.gz backupninja-b05065625c76c271448f493f515558cbe00b34ac.tar.bz2 | |
mysql: use --skip-events when backing up the performance_schema database (Closes: #673572)
| -rw-r--r-- | AUTHORS | 1 | ||||
| -rw-r--r-- | ChangeLog | 6 | ||||
| -rw-r--r-- | handlers/mysql.in | 13 |
3 files changed, 16 insertions, 4 deletions
@@ -43,3 +43,4 @@ aihtdikh -- Allow 'when = XXX' with spaces in .sh files. Chris Lamb <lamby@debian.org> -- rdiff.helper bugfix Yuval Kogman <nothingmuch@woobling.org> -- RackSpace's CloudFiles support for duplicity exobuzz - mysql bugfixes +Glennie Vignarajah <glennie@glennie.fr> -- mysql bugfix @@ -1,3 +1,9 @@ +version 1.0 -- UNRELEASED + handler changes + mysql: + . Use --skip-events when backing up the performance_schema database. + (Closes: #673572) + version 1.0-rc1 -- May 15, 2012 handler changes dup: diff --git a/handlers/mysql.in b/handlers/mysql.in index 65deebb..6ade49e 100644 --- a/handlers/mysql.in +++ b/handlers/mysql.in @@ -256,10 +256,15 @@ then for db in $databases do DUMP_BASE="$MYSQLDUMP $defaultsfile $sqldumpoptions" - if [ "$db" = "information_schema" ] || [ "$db" = "performance_schema" ] - then - DUMP_BASE="${DUMP_BASE} --skip-lock-tables" - fi + + case "$db" in + information_schema) + DUMP_BASE="${DUMP_BASE} --skip-lock-tables" + ;; + performance_schema) + DUMP_BASE="${DUMP_BASE} --skip-lock-tables --skip-events" + ;; + esac # Dumping structure and data DUMP="$DUMP_BASE $ignore $db" |