mysql: don't lock tables in the information_schema database (Closes: #587011)

2 files changed, 7 insertions, 0 deletions

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"