5,576
edits
Changes
Jump to navigation
Jump to search
Line 16:
Line 16: − + + Line 25:
Line 26: − 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.+ − it is the folder where you will save you database backup (default is /root/backup/db)+ − + − + − + + + − + Line 52:
Line 55: − + Line 63:
Line 66: − + Line 69:
Line 72: − +
no edit summary
===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
===smeserver Panel===
===smeserver Panel===
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 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
====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 :
====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
====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}}