From b99ccd6303b599ea9ac90c17f9b40e08265df04e Mon Sep 17 00:00:00 2001 From: intrigeri Date: Tue, 24 Jan 2012 01:23:33 +0100 Subject: mysql: Don't attempt to dump performance_schema database (Redmine#3741). Locking its tables require privileges the 'debian-sys-maint'@'localhost' user is generally not granted. --- ChangeLog | 2 ++ handlers/mysql.in | 2 +- 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/ChangeLog b/ChangeLog index 9a011c0..5ca279d 100644 --- a/ChangeLog +++ b/ChangeLog @@ -14,6 +14,8 @@ version 1.0 -- UNRELEASED example.dup. . Add support for RackSpace's CloudFiles. Thanks to Yuval Kogman for the patch. + mysql: + . Don't attempt to dump performance_schema database (Redmine#3741). version 0.9.10 -- September 23, 2011 backupninja changes diff --git a/handlers/mysql.in b/handlers/mysql.in index 185a98a..65deebb 100644 --- a/handlers/mysql.in +++ b/handlers/mysql.in @@ -256,7 +256,7 @@ then for db in $databases do DUMP_BASE="$MYSQLDUMP $defaultsfile $sqldumpoptions" - if [ "$db" = "information_schema" ] + if [ "$db" = "information_schema" ] || [ "$db" = "performance_schema" ] then DUMP_BASE="${DUMP_BASE} --skip-lock-tables" fi -- cgit v1.2.3