{{MessageBox|backgroundcolor = #faa|image =Warning.png|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 automatize automate it. This can be done using [http://members.multimania.cosourceforge.uknet/wipe_outprojects/automysqlbackup/ AutoMySQLBackup] script.
__NOTOC__
== Features ==
== How to Install ==
<br />
<b><u><big>Ubuntu</big></u></b>
* install via apt-get
sudo apt-get install automysqlbackup
* edit the config file located at <code>/etc/default/automysqlbackup</code>
sudo nano /etc/default/automysqlbackup
* 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:
sudo automysqlbackup
* Edit cron:
sudo crontab -e
* add the following for running cron everyday at midnight
* 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:
* This script is well documented. Options can be easily customized to meet your specific HDA requirements. The guidance can be found in the script file, starting at line 110.* To change day of week (1-=Monday thru 7/=Sunday; defaults to 6=Saturday)for backup, change update the number on the following line in ''automysqlbackup'' as '''root''' user: Line 85: DOWEEKLY=6
* To run anytime, as root do the following:
automysqlbackup* 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.