diff options
author | Elijah Saxon <elijah@riseup.net> | 2005-06-01 22:44:04 +0000 |
---|---|---|
committer | Elijah Saxon <elijah@riseup.net> | 2005-06-01 22:44:04 +0000 |
commit | 1b3449f24cd2ce5ec99602ef6d4286d8159e427f (patch) | |
tree | cfdb7faa0092c06621dfa03e5096b3ad1d01de32 /etc | |
parent | e2089c77cb24838660e8072d08478fab0835a2ed (diff) | |
download | backupninja-1b3449f24cd2ce5ec99602ef6d4286d8159e427f.tar.gz backupninja-1b3449f24cd2ce5ec99602ef6d4286d8159e427f.tar.bz2 |
mysql --defaults-file stuff.
Diffstat (limited to 'etc')
-rw-r--r-- | etc/backup.d/example.mysql | 37 |
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) |