Line 16: |
Line 16: |
| | | |
| ===Installation=== | | ===Installation=== |
− | This contrib is not yet in the smecontribs, you have to download the rpm here and install it by the yum localinstall command. | + | For SME7 and Above. |
| + | This contrib is not yet in the smecontribs repository, you have to download the rpm here and install it by the yum localinstall command. |
| | | |
| wget http://mirror.de-labrusse.fr/Sme-Server/Automysqlbackup/smeserver-automysqlbackup-3.0.RC6-2.el5.sme.noarch.rpm | | wget http://mirror.de-labrusse.fr/Sme-Server/Automysqlbackup/smeserver-automysqlbackup-3.0.RC6-2.el5.sme.noarch.rpm |
Line 25: |
Line 26: |
| ===smeserver Panel=== | | ===smeserver Panel=== |
| | | |
− | For the moment there is no panel for manage this contrib, you have to play with db configuration command but normally the options by default could be sufficient.
| + | There is no panel for manage this contrib, you have to play with db configuration command but normally the options by default could be sufficient. |
| | | |
| ===DB command option=== | | ===DB command option=== |
| | | |
| ====Backup directory==== | | ====Backup directory==== |
− | it is the folder where you will save you database backup (default is /root/backup/db)
| + | It is the folder where you save you database backup '''(default is /root/backup/db)''' |
| config setprop automysqlbackup Backupdir path/to/other/folder | | config setprop automysqlbackup Backupdir path/to/other/folder |
− | you have to create your new backup directory | + | you have to create manually your new backup directory |
| mkdir -p /path/to/other/folder | | mkdir -p /path/to/other/folder |
| | | |
| ====Encryption==== | | ====Encryption==== |
− | If you wish to encrypt your backups using openssl (no is default) | + | If you wish to encrypt your backups using openssl '''(no is default)''' |
| config setprop automysqlbackup Encrypt yes | | config setprop automysqlbackup Encrypt yes |
− | you need to set a password (default is 01234567899876543210) | + | you need to set a password '''(default is 01234567899876543210)''' |
| config setprop automysqlbackup Dbencrypt_password your-password | | config setprop automysqlbackup Dbencrypt_password your-password |
| + | |
| + | {{Note box| This option may be useful when you want to save your databases outside of your server by sending them by mails. keep in mind to change the default password}} |
| | | |
| =====Decryption===== | | =====Decryption===== |
− | To decrypt run (replace gz with bz2 if using bzip2): | + | To decrypt run : |
| | | |
| openssl enc -aes-256-cbc -d -in encrypted_file_name(ex: *.enc.gz) -out outputfilename.gz -pass pass:your-password | | openssl enc -aes-256-cbc -d -in encrypted_file_name(ex: *.enc.gz) -out outputfilename.gz -pass pass:your-password |
Line 52: |
Line 55: |
| | | |
| ====Mailcontent==== | | ====Mailcontent==== |
− | you can choose your type of mail send to the admin (log by default) | + | you can choose your type of mail send to the admin '''(log by default)''' |
| config setprop automysqlbackup Mailcontent option | | config setprop automysqlbackup Mailcontent option |
| option : | | option : |
Line 63: |
Line 66: |
| | | |
| ====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 the mailbox admin of your server)'''. |
| | | |
| config setprop automysqlbackup Mailto foo@foo.com | | config setprop automysqlbackup Mailto foo@foo.com |
Line 69: |
Line 72: |
| ====Sizemail==== | | ====Sizemail==== |
| | | |
− | you can determine the size of mails sent (default is 8000 KB). | + | you can determine the size of mails sent '''(default is 8000 KB)'''. |
| config setprop automysqlbackup Sizemail 8000 | | config setprop automysqlbackup Sizemail 8000 |
| {{note box|keep in mind that a lot of smtp server reject mail bigger than 10 000 KB or 10MB}} | | {{note box|keep in mind that a lot of smtp server reject mail bigger than 10 000 KB or 10MB}} |