MySQL Backup with AutoMySQLBackup

With the emergence of dynamic websites, most sites on your dedicated server probably use some form of database.  Chances are, if a site uses a database, it is running on MySQL or other SQL server.  It is no longer sufficient for system administrators or even individual website owners to only backup the contents of a documents directory.

In order to backup your database, you need to dump the MySQL database tables into a file and store them in a safe location, preferably on a backup server or separate backup device.  You could do this manually: login to MySQL, dump the database, archive and compress it, and then copy it to the backup device.  But that would take a great deal of time, and you would have to remember to do it daily, weekly, or monthly.

With AutoMySQLBackup, you only need to set it up once, drop the script into cron.daily or another cron directory, and it will take over the responsibility of backing up your databases, archiving and compressing them, and copying them to your backup device or server.  When the task is complete, the script will even email you the results so that you know your backup went through successfully.

You can configure the script to backup daily, weekly, and/or monthly, providing separate archive folders for each.  This method is fast and reliable, and I have personally used this script for many of my websites and websites of some of my clients.  Best of all, AutoMySQLBackup is free and open source, and you can download it for no cost from the project website.