From b99ccd6303b599ea9ac90c17f9b40e08265df04e Mon Sep 17 00:00:00 2001
From: intrigeri <intrigeri@boum.org>
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 <nothingmuch@woobling.org> 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