projects
/
matthijs
/
upstream
/
backupninja-vserver.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
ldap: Use quotes in more places.
[matthijs/upstream/backupninja-vserver.git]
/
examples
/
example.mysql
diff --git
a/examples/example.mysql
b/examples/example.mysql
index d7ab8b6ff0c144cb51590ba464de2c611ebb29f7..5fbf009b0515e63ce043f03bcb45a1cc914b5423 100644
(file)
--- a/
examples/example.mysql
+++ b/
examples/example.mysql
@@
-53,16
+53,20
@@
compress = yes
# which databases to backup. should either be the word 'all' or a
# space separated list of database names.
#
# 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
# 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
# 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
# 'hotcopy' and sqldump backups will be in a subdirectory 'sqldump'
#
# 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'
+# This variable is interpolated, see backup.d (5) for which variables are
+# available.
#
# hotcopy = < yes | no > (default = no)
# make a backup of the actual database binary files using mysqlhotcopy.
#
# hotcopy = < yes | no > (default = no)
# make a backup of the actual database binary files using mysqlhotcopy.
@@
-71,6
+75,10
@@
compress = yes
# make a backup using mysqldump. this creates text files with sql commands
# sufficient to recontruct the database.
#
# 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.
#
# compress = < yes | no > (default = yes)
# if yes, compress the sqldump output.
#