aboutsummaryrefslogtreecommitdiff
path: root/handlers/mysql.in
diff options
context:
space:
mode:
authorintrigeri <intrigeri@boum.org>2012-05-20 13:11:12 +0200
committerintrigeri <intrigeri@boum.org>2012-05-20 13:11:12 +0200
commitb05065625c76c271448f493f515558cbe00b34ac (patch)
treec793987674f304ea53abee8dfbcfd18621e0fa0c /handlers/mysql.in
parentd5a65fc0d683fcfd9ac87fd93c0c73edcdc09b40 (diff)
downloadbackupninja-b05065625c76c271448f493f515558cbe00b34ac.tar.gz
backupninja-b05065625c76c271448f493f515558cbe00b34ac.tar.bz2
mysql: use --skip-events when backing up the performance_schema database (Closes: #673572)
Diffstat (limited to 'handlers/mysql.in')
-rw-r--r--handlers/mysql.in13
1 files changed, 9 insertions, 4 deletions
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"