aboutsummaryrefslogtreecommitdiff
path: root/etc/backup.d/example.mysql
diff options
context:
space:
mode:
authorElijah Saxon <elijah@riseup.net>2005-06-01 22:44:04 +0000
committerElijah Saxon <elijah@riseup.net>2005-06-01 22:44:04 +0000
commit1b3449f24cd2ce5ec99602ef6d4286d8159e427f (patch)
treecfdb7faa0092c06621dfa03e5096b3ad1d01de32 /etc/backup.d/example.mysql
parente2089c77cb24838660e8072d08478fab0835a2ed (diff)
downloadbackupninja-1b3449f24cd2ce5ec99602ef6d4286d8159e427f.tar.gz
backupninja-1b3449f24cd2ce5ec99602ef6d4286d8159e427f.tar.bz2
mysql --defaults-file stuff.
Diffstat (limited to 'etc/backup.d/example.mysql')
-rw-r--r--etc/backup.d/example.mysql37
1 files changed, 22 insertions, 15 deletions
diff --git a/etc/backup.d/example.mysql b/etc/backup.d/example.mysql
index 4be2428..e0559fe 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)