MySQL Savior is a time-saving script that automates MySQL database backups through cron. It enables you to keep numerous local copies of your backups, providing added peace of mind.
There are countless scripts available for MySQL backups, but the developer of MySQL Savior decided to write their own, and it shows in the extensive list of features. The script compresses and backs up all databases, storing each copy in its own directory named after the DB name and date. For example, today's Joomla database backup would be in a folder named "Joomla" and the file would be called "Joomla-2008-03-31.gz." The script will store x copies and delete the oldest backup, ensuring the most recent copies are always available.
Additional features are also available if configured, such as the option to email compressed backups of the complete database to an external email account daily. If desired, the script can also SCP backups to a remote SSH server.
The developer has included a disclaimer that the script comes with absolutely no warranty and is to be used at the user's own risk. However, they welcome any bug fixes or improvements if users have any suggestions. The script requires a couple of programs to be installed, including Mutt, tree, and SSH (optional).
The latest release also added compression of the resulting backup file and fixed two error messages only seen when run from the command line. The README.TXT file provides detailed instructions on set up, including how to set up SSH keys.
Overall, MySQL Savior is a reliable and efficient script for anyone looking to back up MySQL databases easily and effectively.
Version 1.0.4: N/A