AutoMysqlBackup
From SME Server
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
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.