**UPDATED VERSION 1.0.4 RELEASED** 20080626
MySQL Savior will backup ALL of your databases, if its setup with the root mysql username and password it will catch any new databases you add without you having to change anything at all. This is a Linux Bash Script to automate your database backups.

Fixed two purely cosmetic bugs, set it up so the resulting backup file is now compressed and added a bit more documentation. We also now have a HOW-TO written explaining how to set it up for those who need it

To install this upload the file to your server and unzip it. The directions are in the README.TXT file.

Now the README.TXT file also explains how to setup ssh keys for those who need it. Mostly a cleanup release although the compression might solve some issues for some people who would time out or the file was to large to email.

We also added one new dependancy in resolving the one cosmetic bug, you need tree, tar, mutt and now sed installed for this to function. This release is a totally bug free release, even when run from the command line. Before some of the messages echoed back showed error for db named . did not exist and one other cosmetic error message. There now are no more errors. Although the two that did report before did not restrict functionality in any way. They just drove me nutz.

It can be downloaded here

***CHANGELOG***

**UPDATED VERSION 1.0.3 RELEASED** 20080420
Fixed one bug and one typo, read CHANGELOG.txt for more info.

While there is probably hundreds of various scripts out there that do mysql backups i decided to write my own long time ago, Along the way we have modified it as customers are requestiong new features and while i am not a programmer and pretty much suck at scripting too this actually works really well.

So here is the basic featureset

Backup all databases and compress them. They are stored so that each copy is in its a directory for that DB each named DBname-date.gz so todays db joomla database would be in a folder named joomla and the file would be called joomla-2008-03-31.gz

Stores X copies and deletes the oldest one .

-Extended Features if configured-

Emails compressed backups of the complete DB to an external email account daily

Scps the backups to a remote SSH server.

This script is released under the GPL, this software comes with absolutely no warranty. Use only at your own risk, If this script should damage your data, cause global warming, cause your girlriend to leave you your parents to divorce and your father to hookup with a shemale, do not say you were not warned. However if you do find ways to improve this script, fix any bugs or cleaner ways of implimenting any of the functionality or put in error handling i would love to hear from you and welcome your changes.

Other than that there is no promise this script will do anything than what it was intended to do, you must have a couple of programs installed for it to work and you must configure it. I have separated the database zipping into its own small program called zipdb so you can test just that functionality to enable make it easier to troubleshoot.

I can not however help you getting it working if you can not understand what its doing. I am already working over 60 hours a week and am not looking for non-paying work. I promise nothing but the program should work for you without much effort. It is already in use on several production systems.