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

[MkMySqlDump.git] / bin / mkmysqldump

diff --git a/bin/mkmysqldump b/bin/mkmysqldump
index dea8a8a0cd7d2cf33e1f765416d78f85f8b0637d..9bab3665e67e6b36c73005286c49b81294645d64 100755 (executable)
--- a/bin/mkmysqldump
+++ b/bin/mkmysqldump
@@ -106,7 +106,7 @@ CMD="mysqldump \
        -h $MYHOST \
        -u $MYUSER \
        $PWSWITCH \
-       --single-transaction \
+       --lock-all-tables \
        --databases $DATABASES"
 
 echo "Start: $(date)"