single-transaction added
Change-Id: I05f979ad11ed91a30b2784ef61aa87bc0f5d0d15
diff --git a/backupninja/files/handler/mysql.conf b/backupninja/files/handler/mysql.conf
index 67ca78a..ae8da97 100644
--- a/backupninja/files/handler/mysql.conf
+++ b/backupninja/files/handler/mysql.conf
@@ -39,17 +39,17 @@
# make a backup using mysqldump. this creates text files with sql commands
# sufficient to recontruct the database.
#
-# sqldumpoptions = <options>
+sqldumpoptions = --single-transaction --hex-blob --quick --quote-names --add-drop-table
# (default = --lock-tables --complete-insert --add-drop-table --quick --quote-names)
# arguments to pass to mysqldump
#
# compress = < yes | no > (default = yes)
-# if yes, compress the sqldump output.
+# if yes, compress the sqldump output.
#
# vsname = <vserver> (no default)
-# what vserver to operate on (only used if vserver = yes
-# in /etc/backupninja.conf), if you do not specify a vsname the
+# what vserver to operate on (only used if vserver = yes
+# in /etc/backupninja.conf), if you do not specify a vsname the
# host will be operated on
-#
-# NB: databases = all doesn't seem to work with hotcopy = yes
+#
+# NB: databases = all doesn't seem to work with hotcopy = yes
# when vsname is specified, I would like to know how to fix this.