Cron Database Backup

[ben_brown30]

Does anyone know of any scripts which will make a backup of a mySQL database and then email the backup to a specified email address?

I've found a few solutions on the web, most of which use Mutt - which appears not to be installed on Bluehost.

Any suggestions?

Thanks

Ben

[shirleymixon]

MySQL database backup
=====================
http://restkultur.ch/personal/wolf/scripts/db_backup


Introduction:
-------------
MySQL database backup is a database backup script written in PHP4.

Most people will used it to have a daily snapshot of the dynamic data
on their website. (e.g. content management systems, forums,
guestbooks etc.)

The script reads all tables in the MySQL databases you coose and
exports (dumps) them in SQL files.

The generated SQL files can be used to rebuild the tables on any
other MySQL database or server or on the same server in case of data-
loss.

Has been tested sucessfully on large databases with 1.5 mio records.

Some of the features include:
- Backup multiple databases and servers with different users and
passwords.
- Backups can be scheduled using cron (on UNIX systems) or AT (on
Windows systems).
- Create daily, weekly and monthly snpashots of your database.
- Keep the daily, weekly and monthly backups for a user-specified
time.
- Archive and compress the SQL files (*.tar.gz).
- Creates a detailed report of everything that has been done.
- Reports can be mailed to you or any other user- specified email-
address, saved to disk or displayed in browser.
- Generated SQL files can be mailed to you or any other user-
specified email-address.
- Generated SQL files can be uploaded by FTP to any user-specified
FTP server.
- Choose to create SQL files for each table or one for each database
- No system calls, everything in 100% pure PHP.

[ben_brown30]

Many Thanks

Will give that one a try!

Ben

[dkinzer]

I downloaded the backup script recommended above and installed it on my site. It seems to work well. I did modify my installation to use authenticated SMTP and to fix a couple of minor PHP warnings. I emailed the patch file to the author. If anyone wants the changes, I'll make them available. The changes are fairly simple - perhaps a dozen lines added or modified.