Backup MySQL Database Using Open Source AutoMySQLBackup Script
Almost all the websites hosted on a dedicated server uses some kind of databases for static or dynamic websites. There are possibilities of a website using a database, running on MySQL or any other SQL server. Backing up only the website contents and image directories is not sufficient for an admins or multiple websites or even for a single website owner it is mandatory to perform a backup or database as well.
When backing up the databases, usually it requires to dump the MySQL database tables into a file and keep them in a safest place. Mostly, these kind of database files are stored on an offsite backup server or on a different backup device. Even, it can be done using simple manual steps, check out this tutorial:
Backup Database Using PHPMyAdmin
However, backing up your database manually consumes your valuable time and need to be remembered to do it daily, weekly or monthly. You can get rid of such hassles using the AutoMySQLBackup script.
You can use the AutoMySQLBackup script to backup your mysql databases automatically. You just need to put that backup script into the cron daily or any another cron directory. By putting the script into the cron directory it will backup your mysql databases automatically, archive and compress them and copy them to your offsite backup server or any other backup device whichever you prefer. Upon the completion of the backup process, the AutoMySQLBackup script will send you the results of the task on your specified email address.
The backup script can be configured according to your requirement. The backup tasks on a dedicated server can be set as Daily, Weekly or Monthly whichever you think is better. This script is one of the best method to fast and reliable backups and can save lots of your time. The best think is that the AutoMySQLBackup script is open source and completely free, which you can download it from the following SourceForge projects website.
http://sourceforge.net/projects/automysqlbackup/
