LAMP and My Softwares31 Jul 2006 05:12 pm
Alex’s MySQL Backup
AMB is a script I wrote to backup all the mysql databases in my server. I will make the script more complex in the future.
Howto
Download the script
Login as root and upload it to your server
Modify the variables in the script
Chmod the script to 775
Chmod your backup directory to 777
run ./amb.sh
add to your cron for nightly dump
Features v 1.0
- Backs up database nighlty (if you run it by cron)
- Keeps an archive of database for seven days
- Compressed Sql file saves you disk space