859
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + Line 10:
Line 10: + + + + Line 16:
Line 20: − This contrib is in the '''smecontribs''', you have to enable it before to install the contrib+ − − yum install --enablerepo=smecontribs smeserver-automysqlbackup − signal-event post-upgrade; signal-event reboot − − ====For SME9==== − − Line 39:
Line 36: − signal-event post-upgrade; signal-event reboot + + + + + + + + + + Line 52:
Line 58: + + + + + + + + + + + + + + + + Line 60:
Line 82: − + Line 67:
Line 89: + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Line 98:
Line 150: − you can choose the mail account where you sent your mails '''(default is the mailbox admin of your server)'''.+ + + + Line 107:
Line 162: + + + + + + + + Line 137:
Line 200: − * Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. − see http://www.linuxbrigade.com/warning-skipping-data-table-mysql-event/#more-135 − some solutions : + + + + + + + + + + + + + + + + + − + − for the moment there is no section for smeserver-automysqlbackup in bugzilla, so send me a mail to mailto:stephdl@de-labrusse.fr.+ + + + + + + + + + + + + + +
→Mailto
{{Languages|AutoMysqlBackup}}
==Automysqlbackup==
==Automysqlbackup==
[http://sourceforge.net/projects/automysqlbackup/ AutoMySQLBackup] associates with DB configuration will create Daily, Weekly and Monthly backups of your MySQL databases. 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". I'm fairly sure that you do not have to modify huge options except the mail where logs and files are sent.
[http://sourceforge.net/projects/automysqlbackup/ AutoMySQLBackup] associates with DB configuration will create Daily, Weekly and Monthly backups of your MySQL databases. 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". I'm fairly sure that you do not have to modify huge options except the mail where logs and files are sent.
*Configurable backup rotation (no db command yet, you have to do it manualy)
*Configurable backup rotation (no db command yet, you have to do it manualy)
*Incremental database backups (no db command yet, you have to do it manualy)
*Incremental database backups (no db command yet, you have to do it manualy)
=== Version ===
{{ #smeversion: smeserver-automysqlbackup}}
{{ #smeversion: automysqlbackup}}
==Maintainer==
==Maintainer==
==Installation==
==Installation==
====For SME8====
====For SME8====
This contrib is in the [[Stephdl|'''stephdl''']] repository, you have to enable it before to install the contrib
This contrib is in the [[Stephdl|'''stephdl''']], you have to enable it before to install the contrib
</noinclude>
</noinclude>
yum install --enablerepo=stephdl smeserver-automysqlbackup
yum install --enablerepo=stephdl smeserver-automysqlbackup
config set UnsavedChanges no
====For SME9 and SME10====
yum install --enablerepo=smecontribs smeserver-automysqlbackup
config set UnsavedChanges no
You can also install pigz for multi CPU support which can speed up your backups and remove the warning from the status email:
yum --enablerepo=epel install pigz
==smeserver Panel==
==smeserver Panel==
If you want to see the db configuration of automysqlbackup.
If you want to see the db configuration of automysqlbackup.
config show automysqlbackup
config show automysqlbackup
===Time===
You can adjust the time when start the cronJob
* Each 30 Minutes
config setprop automysqlbackup Hour '*' Minute '*/30'
signal-event automysqlbackup-update
* Each Hour
config setprop automysqlbackup Hour '*/1' Minute 1
signal-event automysqlbackup-update
* At 3 Hour Am
config setprop automysqlbackup Hour 3 Minute 1
signal-event automysqlbackup-update
===Backup directory===
===Backup directory===
It is the folder where you save you database backup '''(default is /root/backup/db)'''. This is the architecture of your backup folder.
It is the folder where you save you database backup '''(default is /root/backup/db)'''. This is the architecture of your backup folder.
If you want to save in another place, you have to do the command below.
If you want to save in another place, you have to do the command below.
config setprop automysqlbackup Backupdir path/to/other/folder
config setprop automysqlbackup Backupdir /path/to/other/folder
you have to create manually 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
the possibility is given to you to save a local directory by automysqlbackup. I suppose that you can not use it for large folder but for a web site with its database it could be useful. not activated by default
the possibility is given to you to save a local directory by automysqlbackup. I suppose that you can not use it for large folder but for a web site with its database it could be useful. not activated by default
config setprop automysqlbackup Backup_local_files /path/to/folder
config setprop automysqlbackup Backup_local_files /path/to/folder
===Mysql53, Mysql55, Mysql57, MariaDB===
With SCL on SME you may be running other database versions.
You must make sure you have a backup user for the newer databases
Creating backup user for default mysql53 database
done
*** If you add mysql55/mysql57 you must add a backup user ***
You can use the password from config show automysqlbackup
e.g.:
mysql55 -e " GRANT EVENT,SELECT,LOCK TABLES ON *.* TO backupuser@'localhost' "
mysql55 -u root -e "SET PASSWORD FOR backupuser@localhost = PASSWORD( ' -from config show automysqlbackup DbPassword- ' ) "
We can now choose other databases to backup:
mysql53, mysql55, mysql57, mariadb
You can enable or disable as follows:
config setprop automysqlbackup Mysql55 enabled
signal-event automysqlbackup-update
====For Koozali SME v10====
The default Maria 5.5 is included. To add Maria 10.5 added via the contrib:
config setprop automysqlbackup Mymaria105 enabled
signal-event smeserver-automysqlbackup-update
===Encryption===
===Encryption===
===Mailto===
===Mailto===
You can choose the mail account where you sent your mails '''(default is the mailbox admin of your server)'''.
Note that this may not work to places like Gmail or Microsoft as it bypasses DKIM etc and their checking is extremely strict.
config setprop automysqlbackup Mailto foo@foo.com
config setprop automysqlbackup Mailto foo@foo.com
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}}
===Debug===
This should enable some logging to be emailed when it runs:
config setprop automysqlbackup debug enabled
signal-event smeserver-automysqlbackup-update
==Manual Settings==
==Manual Settings==
==Known Issues==
==Known Issues==
===Skip mysql.event===
* Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. SOLVED in [[bugzilla:8146]]
See http://www.linuxbrigade.com/warning-skipping-data-table-mysql-event/#more-135
See this discussion http://bugs.mysql.com/bug.php?id=68376
=== Empty backupdir key===
* Don't leave this key blank or you may get errors:
config show automysqlbackup Backupdir
The system will try and default to /root/backup/db but you may get issues if it is empty
See bugs [[bugzilla:10655]] and [[bugzilla:10654]]
===Backup databases===
* Some solutions :
if we want to backup databases
if we want to backup databases
mysqldump -uroot --events mysql > /tmp/mysql.sql
mysqldump -uroot --events mysql > /tmp/mysql.sql
or if we don't want to backup them
or if we don't want to backup them
mysqldump -uroot --events --ignore-table=mysql.event mysql > /tmp/mysql.sql
mysqldump -uroot --events --ignore-table=mysql.event mysql > /tmp/mysql.sql
==Bugs==
==Bugs==
Please raise bugs under the SME-Contribs section in {{BugzillaFileBug|product=|component=|title=bugzilla}}and select the smeserver-automysqlbackup component or use
{{BugzillaFileBug|product=SME%20Contribs|component=smeserver-automysqlbackup |title=this link}}.
{{#bugzilla:columns=id,product,version,status,summary |sort=id |order=desc |disablecache=1 |component=smeserver-automysqlbackup |noresultsmessage="No open bugs found."}}
==Changelog==
Only released version in smecontrib are listed here.
{{ #smechangelog: smeserver-automysqlbackup }}
[[Category: Contrib]]
[[Category: Contrib]]