Help! I need script for Auto Backup for SQL

[jeepj27]

Does anyone know of or can point me to a script that I can use as a Cron Job in CPANEL that will allow me to have a nightly backup of the entire SQL database emailed to me?


Thanks to anyone!!

-John

[ujr]

check this out:

"This script will allow you to maintain a database backup at any time interval you set. When you upload it to your server, you may set it up on a crontab and let it run daily, weekly or monthly. This script connects to your database, builds a backup "dump" file, gzip's it and either sends it to your email address or uploads it to an ftp server that you configured and cleans up the temporary files."

http://www.phpfreaks.com/script/view/11.php