From 9179c59b50ddf1a8e11817924df7f589a76500b4 Mon Sep 17 00:00:00 2001
From: intrigeri <intrigeri@boum.org>
Date: Thu, 24 Jun 2010 16:18:44 +0200
Subject: mysql: don't lock tables in the information_schema database (Closes:
 #587011)

---
 ChangeLog         | 3 +++
 handlers/mysql.in | 4 ++++
 2 files changed, 7 insertions(+)

diff --git a/ChangeLog b/ChangeLog
index 5de8552..8dec95c 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -22,6 +22,9 @@ version 0.9.8 -- UNRELEASED
 	 . Better example.dup documentation. Thanks, Alster!
 	 . Added ftp_password option to securely transmit the FTP password
 	   from backupninja to duplicity.
+	mysql:
+	 . Don't lock tables in the information_schema database
+	   (Closes: #587011)
     doc changes
 	manpage:
 	 . Fix typo in manpage (Closes: #583778)
diff --git a/handlers/mysql.in b/handlers/mysql.in
index 4dece24..68d5197 100644
--- a/handlers/mysql.in
+++ b/handlers/mysql.in
@@ -255,6 +255,10 @@ then
    for db in $databases
    do
       DUMP_BASE="$MYSQLDUMP $defaultsfile $sqldumpoptions"
+      if [ "$db" = "information_schema" ]
+      then
+         DUMP_BASE="${DUMP_BASE} --skip-lock-tables"
+      fi
 
       # Dumping structure and data
       DUMP="$DUMP_BASE $ignore $db"
-- 
cgit v1.2.3