Composite excellent work
Thank you very much

so is this in lieu of using the backup in the acp?

if i use this, will be easier to use the file from this script to upload to lets say a new db and new installation of my site? cuz i know the one in the acp that comes with the forum sucks and i could never get it to actually work, always having to start from scratch.

Excellent

Has anybody modified this to compress the file after making the backup?

Hi Paul,

I've set everything correctly, for the cron job -- I do that in my hosting cPanel right?

Does this backup every table?

Regards Jason :)

No, just install the product via your ACP panel. Fill out the required information in the mysqlbackupconfig.php file and you're done. To edit the cron job once you have done this it is under 'Scheduled Tasks' in vBulletin. It has nothing to do with cPanel.

This option can specify if you want all tables or just tables your want:

Paul, I am quite new to cron jobs. What does the '*' mean in the options like 'Day of the Week' etc? Because basically what I want to do is back it up every day at midnight.

Cheers
LTC

Thanks for that.

Now for me to answer your question:

This is the day of the week the task should run on. Set this to * to have it not apply, or for it to run every day (if Day of the Month is set to * below). Otherwise select a specific day. Note that this will override the day of the month option, unless this is set to *.

Regards Jason :)

One more question, I click "Run Now" and it returned the following error:

Automatic Database Backup for vB 3.7
An error occured during the Backup : Could not open Destination SQL file for writing.

Anything need changing?

Regards Jason :)

This means that the path to your backups folder is not correct. Download this file and upload it to your backups directory. This will give you the entire path, for you to insert into the config file. Remember to have a trailing slash /.

Forum Path

Also make sure your backups folder is set to 777.

I don't understand you.

I have it right in the config.php file. I have my backups folder at: /public_html/backups/ ... and that's what I've set in the config.php file.

Regards Jason :)