Difference between revisions of "AutoMysqlBackup"

From SME Server
Jump to navigationJump to search
Line 29: Line 29:
 
you have to manualy make your new backup directory
 
you have to manualy make your new backup directory
  
====Mailcontent====
+
=====Mailcontent=====
 
you can choose your type of mail send to the admin (by default)
 
you can choose your type of mail send to the admin (by default)
 
  config setprop automysqlbackup Mailcontent "option"
 
  config setprop automysqlbackup Mailcontent "option"
Line 38: Line 38:
 
*quiet : Only send logs if an error occurs to the MAILADDR.
 
*quiet : Only send logs if an error occurs to the MAILADDR.
  
===Mailto===
+
====Mailto====
 
you can choose the mail  account where you sent your mails.(default is admin)
 
you can choose the mail  account where you sent your mails.(default is admin)
  
 
  config setprop automysqlbackup Mailto "foo@foo.com"
 
  config setprop automysqlbackup Mailto "foo@foo.com"
  
===Sizemail===
+
====Sizemail====
  
 
you can determine the size of mails sent.(default is 8000 bytes)
 
you can determine the size of mails sent.(default is 8000 bytes)
 
  config setprop automysqlbackup Sizemail 8000
 
  config setprop automysqlbackup Sizemail 8000

Revision as of 22:59, 25 April 2013

Automysqlbackup

AutoMySQLBackup with a DB configuration will create Daily, Weekly and Monthly backups of one or more of your MySQL databases from one or more of your MySQL servers. At least there is no panel in the server-manager but the configuration is quite simple with few commands listed above, handle by "config setprop automysqlbackup".


Other Features include: - Email notification of backups - Backup Compression and Encryption - Configurable backup rotation - Incremental database backups

Maintainer

Stephane de Labrusse

mailto:stephdl@de-labrusse.fr

Installation

for the instant you have to download the rpm here and install it by the yum localinstall command

wget http
yum localinstall 

DB command option

backup directory

default "/root/backup/db"

config setprop automysqlbackup Backupdir path/to/other/folder

you have to manualy make your new backup directory

Mailcontent

you can choose your type of mail send to the admin (by default)

config setprop automysqlbackup Mailcontent "option"
  • log : send only log file (default)
  • files : send log file and sql files as attachments
  • stdout : will simply output the log to the screen if run manually.
  • quiet : Only send logs if an error occurs to the MAILADDR.

Mailto

you can choose the mail account where you sent your mails.(default is admin)

config setprop automysqlbackup Mailto "foo@foo.com"

Sizemail

you can determine the size of mails sent.(default is 8000 bytes)

config setprop automysqlbackup Sizemail 8000