From b05065625c76c271448f493f515558cbe00b34ac Mon Sep 17 00:00:00 2001 From: intrigeri Date: Sun, 20 May 2012 13:11:12 +0200 Subject: mysql: use --skip-events when backing up the performance_schema database (Closes: #673572) --- handlers/mysql.in | 13 +++++++++---- 1 file changed, 9 insertions(+), 4 deletions(-) (limited to 'handlers') 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" -- cgit v1.2.3