X-Git-Url: https://git.stderr.nl/gitweb?p=matthijs%2Fupstream%2Fbackupninja.git;a=blobdiff_plain;f=examples%2Fexample.mysql;h=de9651fb5e1b6e6cda11855e98bbbbe214ce296a;hp=d7ab8b6ff0c144cb51590ba464de2c611ebb29f7;hb=2cfcdd636d21e353f061fdc563c4b6dee3a4d979;hpb=3cf6de437495495ea400ade55f7b13d4077b8cb3 diff --git a/examples/example.mysql b/examples/example.mysql index d7ab8b6..de9651f 100644 --- 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 cache stored in tables that +# 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 = +# (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. #