Trusted, Bureaucrats, Administrators
12,424
edits
Changes
From Amahi Wiki
→How to Install
heading =WARNING|
message = This is recommended only for advanced users, proceed with caution.}}
It's good practice to periodically backup up your database. This functionality is coming to Amahi soon, but until then there is a simple way to automate it. This can be done using [http://memberssourceforge.multimania.co.uknet/wipe_outprojects/automysqlbackup/ AutoMySQLBackup] script.
__NOTOC__
== Features ==
== How to Install ==
* install via apt-get
* At the bare minimun, in the config file, edit the BACKUPDIR variable
* run automysqlbackup to see if it works (you should get backups added to your backupdir directory:
* Edit cron:
* add the following for running cron everyday at midnight
* Create a share called '''dbbackup'''.
* Download the script to ''/tmp'' directory.
* Some changes will need to be made for this to work on your HDA. As '''root''' user, update lines indicated in ''automysqlbackup-2.5.1-01.sh'' to read as follows:
Line 42: PASSWORD=hda
Line 51: BACKUPDIR="/var/hda/files/dbbackup"
Line 76: DBEXCLUDE="information_schema performance_schema mysql"
Line 79: CREATE_DATABASE=yes
Line 94: LATEST=yes}}</pre><br />
* Rename and copy the ''automysqlbackup-2.5.1-01.sh'' from ''/tmp'' to ''/usr/bin'' and set the permissions:
cp /tmp/automysqlbackup-2.5.1-01.sh automysqlbackup
chmod 755 automysqlbackup}}</pre>
* Set ''automysqlbackup'' as a daily cron job (Optional):
== Tips ==
* To change day of week (1=Monday thru 7=Sunday; defaults to 6=Saturday) for backup, update the number on the following line in ''automysqlbackup'' as '''root''' user:
* To run anytime, as root do the following:
* This script is well documented. Options can be easily customized to meet your specific HDA requirements. The guidance can be found in the ''automysqlbackup'', starting at line 110.
'''NOTE:''' When it's run the first time, it will create the directory structure automatically if it does not already exist.
