X-Git-Url: https://git.stderr.nl/gitweb?p=matthijs%2Fupstream%2Fbackupninja.git;a=blobdiff_plain;f=examples%2Fexample.mysql;h=bd996e7ccaafe96197c065c64b96dd6b06d7c2ad;hp=51c2247717f53a800274b8df780331fce6f00e77;hb=cb833ea82cbc59e14fc1f0b71e2cebdf88ff30d0;hpb=c4785ba5edb9738f7e9da8c4086a4b6984515dd2 diff --git a/examples/example.mysql b/examples/example.mysql index 51c2247..bd996e7 100644 --- a/examples/example.mysql +++ b/examples/example.mysql @@ -53,9 +53,18 @@ compress = yes # which databases to backup. should either be the word 'all' or a # space separated list of database names. # +# 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. 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 'hotcopy' and -# sqldump backups will be in a subdirectory 'sqldump' +# where to dump the backups. hotcopy backups will be in a subdirectory +# 'hotcopy' and sqldump backups will be in a subdirectory 'sqldump' # # hotcopy = < yes | no > (default = no) # make a backup of the actual database binary files using mysqlhotcopy. @@ -68,8 +77,9 @@ compress = yes # if yes, compress the sqldump output. # # vsname = (no default) -# 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 +# 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 when vsname is specified -# I would like to know how to fix this. +# NB: databases = all doesn't seem to work with hotcopy = yes +# when vsname is specified, I would like to know how to fix this.