X-Git-Url: https://git.stderr.nl/gitweb?a=blobdiff_plain;f=etc%2Fbackup.d%2Fexample.mysql;h=51c2247717f53a800274b8df780331fce6f00e77;hb=1645c0c8572abe98f4d92d951ad3482b15cd4db4;hp=4be2428d8df8b01572adbcd351f4e7586a73fcb2;hpb=a56165ce12dbf68ee8522aa5bf0c40aa7928e399;p=matthijs%2Fupstream%2Fbackupninja.git

diff --git a/etc/backup.d/example.mysql b/etc/backup.d/example.mysql
index 4be2428..51c2247 100644
--- a/etc/backup.d/example.mysql
+++ b/etc/backup.d/example.mysql
@@ -1,24 +1,31 @@
-## backupninja mysql config file ##
+### backupninja mysql config file ###
 
-dbhost      = localhost
 databases   = all
 backupdir   = /var/backups/mysql
-hotcopy     = yes
-sqldump     = no
+hotcopy     = no
+sqldump     = yes
 compress    = yes
 
-## authentication ##
+### authentication ###
 
-configfile = /etc/mysql/debian.cnf
-
-# or...
-# dbusername  = <dbuser>
-# dbpassword  = <dbpassword>
-
-# or...
-# user = root
+# three authentication methods:
+#
+# 1. setting the user, so that /home/user/.my.cnf is used.
+# user = some-unix-user
+#
+# 2. specifying the mysql dbuser and dbpassword,
+#    which generates a temporary .my.cnf in /root/.my.cnf
+# dbusername  = <some-mysql-user>
+# dbpassword  = <password>
+#
+# 3. specify which config file to use with configfile
+#    (this option does not work with hotcopy)
+# configfile = /etc/mysql/debian.cnf
+#
+# if user and dbusername are not specified, the default is to use
+# /etc/mysql/debian.cnf for configfile.
 
-## notes ##
+### all options ###
 
 # configfile = < path/to/file > (default = /etc/mysql/debian.cnf)
 # The config file is passed to mysql with --defaults-file.
@@ -50,7 +57,7 @@ configfile = /etc/mysql/debian.cnf
 # 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 = yes)
+# hotcopy = < yes | no > (default = no)
 # make a backup of the actual database binary files using mysqlhotcopy.
 #
 # sqldump = < yes | no > (default = no)
@@ -63,4 +70,6 @@ configfile = /etc/mysql/debian.cnf
 # 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 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.