Drupal lab

AutoMySQLBackup is a great script that help us backup MySQL databases automatically. It can run thru cron job in or manually. It is easy to setup and make it works. I have just get it works only 5 minutes. The script uses mysqldump to backup MySQL databases so make sure you have it at your linux server/vps.

It is an open source/freeware so you are free to place it at your server/vps to backup your MySQL databases daily, weekly, monthy or manually.

AutoMySQLBackup features

• 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 week to run weekly backups.

Setup AutoMySQLBackup is very easy

1. download it from SourceForge http://sourceforge.net/projects/automysqlbackup/
2. place it into your /etc/cron.daily directory or your home directory.
3. Edit some lines to match your MySQL databases information
- USERNAME=dbuser (The user must have at least select privileges to the databases) PASSWORD=password
- DBNAMES="DB1 DB2 DB3" (make sure to keep the quotes " " otherwise it won't work)
4. Make the file executable :- chmod u+rwx
5. Create the following directory./backups
6. That's it.. Now you can run it using the command line "./automysqlbackup.sh" or if it is in /etc/cron.daily it will run each day when cron runs.