Administrative and Maintenance Tools - vB Database Backup

This modification is no longer available or supported.

Note: Because I did not write the original version, but rather have modified & adapted it, support of this modification may be limited

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it, first for vb 3.6 and now for vb3.7.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. In 2007 David gave me permission to release my adaptation.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (lite) version that does a php based dump of your database either as one file, or one file per table.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic backup functionality on 3.7.


History:

v3.7.001 : First version for vB 3.7.

[asj]

Composite excellent work
Thank you very much

[seangworld]

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.

[EvErDrEaMs]

Excellent

[Lynne]

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

[Jase2]

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

[lordtopcat]

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:

  // Backup Type To Use
  $backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables
  $backup['TABLES']	= array(); // Table List - e.g. array('table1', 'table2')

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

[Jase2]

Originally Posted by lordtopcat

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:

  // Backup Type To Use
  $backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables
  $backup['TABLES']	= array(); // Table List - e.g. array('table1', 'table2')

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

[Jase2]

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

[lordtopcat]

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.

[Jase2]

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