In case anyone of you has to deal with taking backups from multiple MySQL databases while keeping it easy, this little script should come in handy.
= = =
Raga's MySQL Dumper - your all-in-one database dumper and dump manager!
http://www.ragadesign.com/scripts/ragasmysqldump.zip
1. Download.
2. Open in your favorite editor and set up your whatever secret word in the beginning of the file.
3. Create a directory and CHMOD 0777.
4. Stick in the script. Head there.
5. Enter your secret word to gain access to use the dumper.
6. Enter the details for the database to be dumped.
7. If you get the OK message, download. The database has been named as timestamp-databasename.gz. If you get an error message, check the details you just input and try again.
8. Below the form where you enter the database details, you'll see the existing dumps you have taken. Delete them as necessary.
You can use this one script for all your databases if you wish, as long as you're staying on the same server. The script is perfectly safe to leave in the directory, since it is password protected. There is no need to .htaccess the directory, since the database dump names start with a Unix timestamp which is virtually impossible for anyone to guess unless they knew the second you hit the dump button.
Please report any bugs to me by e-mail: bugs{at}ragadesign.com.
