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 automatize it. Follow  This can be done using [http://members.multimania.co.uk/wipe_out/automysqlbackup/ AutoMySQLBackup]. <u>Features:</u>* Backup mutiple MySQL databases with one script. (Now able to backup ALL databases on a server easily. no longer need to specify each database seperately)* Backup all databases to a single backup file or to a seperate 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 backup log to any 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 maximun size backup to email.* Can be set to run PRE and POST backup commands.* Choose which day of the steps below week to help keep run weekly backups. <u>What it does:</u>Every day AutoMySQLBackup will run (if setup on /etc/cron.daily) and using mysqldump and gzip will dump your data safespecified databases to the /backups/daily directory, it will rotate daily backups weekly so you should never have more than 7 backups in there.. Every Saturday AutoMySQLBackup will again backup the databases you have chosen but they will be placed into /backups/weekly, these will be rotated every 5 weeks so there should never be more than 5 backups in there.. Every 1st of the month AutoMySQLBackup will create a backup of all databases and place them into /backups/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..