Use --lock-all-tables, --single-transaction only works with InnoDB

[MkMySqlDump.git] / bin / mkmysqldump

diff --git a/bin/mkmysqldump b/bin/mkmysqldump
index 8489f2eeaab359f5d864513a6d083b9137488d05..9bab3665e67e6b36c73005286c49b81294645d64 100755 (executable)
--- a/bin/mkmysqldump
+++ b/bin/mkmysqldump
@@ -92,7 +92,9 @@ echo "Getting list of databases from server ..."
 DATABASES=$(
        mysql -h "$MYHOST" -u "$MYUSER" $PWSWITCH -e 'show databases' \
         | grep "^\| " | cut -d' ' -f2 | grep -v "Database" \
-        | grep -v "information_schema" | grep -v "mysql"
+        | grep -v "information_schema" \
+        | grep -v "performance_schema" \
+        | grep -v "mysql"
 )
 if [ $? -ne 0 ]; then
        echo "Failed to get list of databases! Aborting!"
@@ -104,7 +106,7 @@ CMD="mysqldump \
        -h $MYHOST \
        -u $MYUSER \
        $PWSWITCH \
-       --single-transaction \
+       --lock-all-tables \
        --databases $DATABASES"
 
 echo "Start: $(date)"