mysql: new sqldumpoptions config variable (Closes: #502966)

[matthijs/upstream/backupninja.git] / examples / example.mysql

diff --git a/examples/example.mysql b/examples/example.mysql
index d22cbcbd392f7ed9843bda3dcd037efe4ff3e23d..de9651fb5e1b6e6cda11855e98bbbbe214ce296a 100644 (file)
--- a/examples/example.mysql
+++ b/examples/example.mysql
@@ -53,12 +53,14 @@ compress    = yes
 # which databases to backup. should either be the word 'all' or a 
 # space separated list of database names.
 #
-# nodata = < table1 table2 table3 > (no default)
+# nodata = < db.table1 db.table2 db.table3 > (no default)
 # only dump the structure for the database tables listed here, this means
 # no data contained in these tables will be dumped. This is very useful
 # to backup databases that have tables with large amounts of cache data that
 # isn't necessary to backup, but you still need the structure to exist
-# on a restore
+# on a restore. You *must* specify the table as part of a database, such
+# as "drupal.cache", where the database name is "drupal" and the table that
+# you do not want to dump the data for is called "cache". 
 #
 # backupdir = < path/to/destination > (default = /var/backups/mysql)
 # where to dump the backups. hotcopy backups will be in a subdirectory 
@@ -71,6 +73,10 @@ compress    = yes
 # make a backup using mysqldump. this creates text files with sql commands
 # sufficient to recontruct the database.
 #
+# sqldumpoptions = <options>
+# (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. 
 #