WipeOut’s – Automatic MySQL Backup
July 14, 2006 in Linux
Autobackup is a script that makes backup of MySQL databases. It takes care of stopping the databaseserver and then makes dump of the specified databases in a compressed format.
AutoMySQLBackup Script Features..
- Backup mutiple MySQL databases with one script. (Now able to backup ALL databases on a server easily. No longer need to specify each database seperately)
- Backup all databases to a single backup file or to a seperate directory and file for each database.
- Automatically compress the backup files to save disk space using either gzip or bzip2 compression.
- Can backup remote MySQL servers to a central server.
- Runs automatically using cron or can be run manually.
- Can e-mail the backup log to any specified e-mail address instead of “root”. (Great for hosted websites and databases).
- Can email the compressed database backup files to the specified email address.
- Can specify maximun size backup to email.
- Can be set to run PRE and POST backup commands.
- Choose which day of the week to run weekly backups.
The script can be downloaded from the projects Sourceforge page. Read more about the script on the homepage of Autobackup.
I use the script on my server powered bye SME Linux. I have made an I-bay where I dump the backups of my databases. This ibay is then backed up to a NAS-disc. Easy, secure and well worth the time invested in the installastion.
Popularity: 2% [?]
