{{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.multimaniasourceforge.co.uknet/wipe_outprojects/automysqlbackup/ AutoMySQLBackup]script.__NOTOC__

* Backup mutiple multiple MySQL databases with one script. (Now able to backup ALL databases on a server easily. no longer need to specify each database seperatelyseparately)* Backup all databases to a single backup file or to a seperate separate directory and file for each database.

* Can specify maximun maximum size backup to email.

* Every day AutoMySQLBackup it will run (if setup on /etc/cron.daily) and using mysqldump and gzip will dump your specified databases to the ''/var/backupshda/files/dbbackup/daily '' directory, it will rotate daily backups weekly so you should never have more than 7 backups in there.* Every Saturday it will again backup the databases you have chosen but they will be placed into ''/var/hda/files/dbbackup/weekly'', these will be rotated every 5 weeks so there should never be more than 5 backups in there.* Every 1st of the month it will create a backup of all databases and place them into ''/var/hda/files/dbbackup/monthly''. These will never be rotated so it will be up to you to do your own house keeping. I would suggest taking a copy of this offline every month or two so that if you have a hard drive failure you will be able to restore your database.

Every Saturday AutoMySQLBackup will again backup == 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 databases BACKUPDIR variable* run automysqlbackup to see if it works (you have chosen but they will be placed into should get backups added to your backupdir directory: sudo automysqlbackup* Edit cron: sudo crontab -e* add the following for running cron everyday at midnight 0 0 * * * /usr/sbin/automysqlbackup<br /><b><u><big>Fedora</big></u></b>* Create a share called '''dbbackup'''.* Download the script to ''/tmp'' directory.<pre style="white-space: pre-wrap; word-break: keep-all;">cd /tmpwget http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/backupsautomysqlbackup-2.5.1-01.sh</weekly, these pre>* Some changes will need to be rotated every 5 weeks so there should never be more than made for this to work on your HDA. As '''root''' user, update lines indicated in ''automysqlbackup-2.5 backups in there.1-01.sh'' to read as follows:<pre>Line 39: USERNAME=rootLine 42: PASSWORD=hdaLine 51: BACKUPDIR="/var/hda/files/dbbackup"Line 65: MAILADDR="root"Line 76: DBEXCLUDE="information_schema performance_schema mysql"Line 79: CREATE_DATABASE=yesLine 94: LATEST=yes</pre><br />

Every 1st of * Rename and copy the month AutoMySQLBackup will create a backup of all databases ''automysqlbackup-2.5.1-01.sh'' from ''/tmp'' to ''/usr/bin'' and place them into set the permissions:<pre>cd /usr/bincp /backupstmp/monthlyautomysqlbackup-2.5. These will never be rotated so it will be up to you to do your own house keeping1-01. I would suggest taking sh automysqlbackupchmod 755 automysqlbackup</pre>* Set ''automysqlbackup'' as a copy of this offline every month or two so that if you have a hard drive failure you will be able to restore your databasedaily cron job (Optional):<pre>cd /etc/cron.dailyln -s /usr/bin/automysqlbackup</pre>