{{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.

<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>

  <pre>Line 39: '''USERNAME=root''' Line 4942: '''PASSWORD=hda''' Line 51: '''BACKUPDIR="/var/hda/files/dbbackup'''" Line 65: '''MAILADDR="root"''' Line 76: '''DBEXCLUDE="information_schemaperformance_schema mysql"''' Line 79: '''CREATE_DATABASE=yes''' Line 94: '''LATEST=yes'''</pre><br />

<pre>cd /usr/bin cp /tmp/automysqlbackup-2.5.1-01.sh automysqlbackup chmod 755 automysqlbackup</pre>

<pre>cd /etc/cron.daily ln -s /usr/bin/automysqlbackup</pre>

* This script is well documented. Options can be easily customized To change day of week (1=Monday thru 7=Sunday; defaults to meet your specific HDA requirements. The guidance can be found in 6=Saturday) for backup, update the number on the script file, starting at following line 110.in ''automysqlbackup'' as '''root''' user: Line 85: DOWEEKLY=6

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.