{{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'Database'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'' 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</code> sudo nano /downloads.sourceforge.netetc/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 AutoMySQLBcckup] 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*</pre>