[SamirDarji]

Originally Posted by Matrixgl

I am not trying to discourage people from using this hack, but this is just a suggestion for people who wants more features.

The script that I use can be used to make backups of any database, and it has all the features that you probably need.

• 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 saved on the server.
• Choose to create SQL files for each table or one for each database.
• No system calls, everything in 100% pure PHP. PHP Safe-mode compatible.

http://restkultur.ch/personal/wolf/scripts/db_backup/

I've been messing with this for a little while in a scheduled task in the vb cron. On my local test server, it works fine. But on the production server, I get a "Internal Server Error" when I try to manually run the job. Any clues?