{{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 automatate automate it. Follow This can be done using [http://sourceforge.net/projects/automysqlbackup/ AutoMySQLBackup] script.__NOTOC__== Features ==* Backup multiple MySQL databases with one script. (Now able to backup ALL databases on a server easily. no longer need to specify each database separately)* Backup all databases to a single backup file or to a separate directory and file for each database.* Automatically compress the backup files to save disk space using either gzip or bzip2 compression.* Can backup remote MySQL servers to a central server.* Runs automatically using cron or can be run manually.* Can e-mail the steps below backup log to help keep your data safeany specified e-mail address instead of "root". (Great for hosted websites and databases).* Can email the compressed database backup files to the specified email address.* Can specify maximum size backup to email.* Can be set to run PRE and POST backup commands.* Choose which day of the week to run weekly backups.

== Installation What it does ==* Create a share called Every day it will run mysqldump and gzip will dump your specified databases to the ''/var/hda/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 'Database'/var/hda/files/dbbackup/weekly'' with , these will be rotated every 5 weeks so there should never be more than 5 backups in there.* Every 1st of the path month it will create a backup of all databases and place them into ''/var/hda/files/dbdbbackup/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. == How to Install ==<br /><b><u><big>Ubuntu</big></u></b>* Download install via apt-get sudo apt-get install automysqlbackup* edit the script [http:config file located at <code>/etc/default/automysqlbackup</downloads.sourceforge.netcode> sudo nano /etc/projectdefault/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 0 0 * * * /AutoMySQLBackupusr/AutoMySQLBackup%20VER%202.5sbin/automysqlbackup-2<br /><b><u><big>Fedora</big></u></b>* Create a share called '''dbbackup'''.5.1-01.sh AutoMySQLBackup] file * Download the script to ''/tmp'' directory. <pre style="white-space: pre-wrap; word-break: keep-all;">cd /tmp wget http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup-2.5.1-01.sh</pre>* Some changes will need to be made for this to work on your HDA. Use your favorite text editor and As '''root''' user, update as follows:lines indicated in ''USERNAME=debianautomysqlbackup-2.5.1-01.sh'' on line 39 toread as follows:<pre>Line 39: USERNAME=root''PASSWORD='' on line Line 42 to: PASSWORD=hda''BACKUPDIR="/srv/backup/db" on line Line 51 to: BACKUPDIR="/var/hda/files/dbdbbackup"''MAILADDR="maintenance@example.com"'' on line Line 65 to: MAILADDR="root"''DBEXCLUDE=""'' on line Line 76 to: DBEXCLUDE="information_schemaperformance_schema mysql"''CREATE_DATABASE=no'' on line Line 79 to: CREATE_DATABASE=yes''LATEST=no'' on line Line 94 to: LATEST=yes</pre><br /> * Copy Rename and copy the file ''automysqlbackup-2.5.1-01.sh'' from ''/tmp'' to ''/usr/local/bin'' and set the permissions: <pre>cd /usr/local/bin cp /tmp/automysqlbackup-2.5.1-01.sh .automysqlbackup chmod 755 automysqlbackup-2.5.1-01.sh</pre>* Set ''automysqlbackup'' as a daily cron job(Optional): <pre>cd /etc/cron.daily ln -s /usr/local/bin/automysqlbackup-2.5.1-01.sh* When it's run the first time, it will create the directory structure automatically. It will look like this: daily latest monthly weekly* Each time it is executed, the script will backup all your databases and tables. Each database will be exported in to ''.sql'' files, zipped, and placed in its own folder for the respective period, i.e. latest, daily, etc. The sql will include the database</table create syntax as well. * It will also rotate those each time so you will have backups preserved for quite some time.pre>