 Automatic MySQL Backup
Monday, 27 March 2006
If you need to archive your MySQL databases in a Linux environment, there’s no better tool than Harley’s AutoMySQLBackup.
The main script features include:
- Backup multiple MySQL databases with one script.
- Backup all databases to a single backup file or to a separate 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 email the backup log to any specified email address.
- Can email the compressed database backup files to the specified email address.
- Can specify maximum size backup to email.
- Can be set to run PRE and POST backup commands.
- Choose which day of the week to run weekly backups.
Easy to setup, configure and, combined with cron, really useful too.
|
