Most websites these days rely on content management systems, blogging software, and other types of web applications and scripts to update, manage, and configure them. Rather than static HTML pages stored in the user’s home directory, most content is now stored in databases.
As a dedicated server administrator, it is imperative that you have backups of all user files, especially if you are offer hosting services. To truly backup all content, you must have a method of backing up databases. MySQL has simple command line options that allow you to dump databases into single sql files or archives, but it does not have an automated backup feature.
It is undoubtedly this MySQL limitation that the creators of AutoMySQLBackup had in mind when they wrote their script that can backup databases on a daily, weekly, or monthly schedule. When I had my own dedicated server, I used the script to backup several databases regularly.
The auto backup script is a single file with the configuration settings in the top half. Just open up the script in a text editor and follow the directions. If you do not have a lot of configuration requirements, you can get by with just editing the first few settings. The easiest way to use it is to copy the script into the /etc/cron.daily folder so that it will execute each night, although it will still run backups according to your configurations.
By default, the script will email you backup results so that you can be sure they were completed correctly. The backups will be saved to a directory on the server of your choosing. Make sure the path is included in your normal incremental backup of system files. When that backup occurs, your MySQL databases will be safely backed up right along with all of your other files.
AutoMySQLBackup is free and open source software, available for download from Sourceforge.net.