database backup

About AutoMySQLBackup:

A script to take daily, weekly and monthly backups of your MySQL databases using mysqldump. Features - Backup mutiple databases - Single backup file or to a seperate file for each DB - Compress backup files - Backup remote servers - E-mail logs – More

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.

Bill;7249:

Here's a free script that seems to have what you are looking for:

http://sourceforge.net/projects/automysqlbackup/



If not-- if you could describe the problem you are having with phpMyBackupPro, perhaps it could be solved?

phpMyBackupPro v.2.1:

Release Name: phpMyBackupPro v.2.1

Notes:
Everyone should update to v.2.1 because it fixes some major bugs in v.2.0!

Changes:
04/01/2007
v.2.1: Email problem in v.2.0 fixed (empty/missing files), fixed call-by-
-reference problem enables bigger backups now, fixed shell/cron mode
new features: directory backups can be send by email (see
SYSTEM_VARIABLES.txt)

Bill;7260:

This may be relevant if you are using an old version.