Administrative and Maintenance Tools - vB Database Backup (Lite)

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

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, 3.7 and now for vb3.8.

The original version was by Trigunflame and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later 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.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

[Paul M]

If you copied the files and created a new cron task there isnt any reason you could not do that.

[valdet]

Originally Posted by Paul M

If you copied the files and created a new cron task there isnt any reason you could not do that.

I thought of that, but the problem is the settings on vB Admin Panel. My current setting is

Date Format:  d

How to make them differentiate for two backup options that we need: Daily and Monthly.

How to add another option so besides taking daily backups, it also takes backups on 1-st of every month. Or maybe I'm missing something too obvious.

Please advise.

Thanks

[Paul M]

You would need to override the options in the copies you make (hard code them).

[valdet]

Originally Posted by Paul M

You would need to override the options in the copies you make (hard code them).

Ok thanks,

From your mysqlbackup.php file, I see these rows referencing the settings

		$this->DATE = date($this->OPTIONS['cbu_date']);
		$this->PREFIX = &$this->OPTIONS['cbu_prefix'];
		$this->DUMP_PATH = &$this->OPTIONS['cbu_path'];

Should they be hardcoded on to a new mysqlbackup2.php like

		$this->DATE = date($M);
		$this->PREFIX = &monthly-backup;
		$this->DUMP_PATH = &/home/user/my-custom-path/;

Please advise what would be the correct hardcoded part

Thanks

[valdet]

Ok this is how you do it.

1. Make copies of the two product files: mysqlbackup2.php and cron/cronbackup2.php
2. Add three extra settings to product:
cbu_date2: M
cbu_prefix2: monthly-backup and
cbu_path2: /home/user/my-custom-path/
3. Make this change at mysqlbackup2.php
From

		// File Information 
		$this->DATE = date($this->OPTIONS['cbu_date']);
		$this->PREFIX = &$this->OPTIONS['cbu_prefix'];
		$this->DUMP_PATH = &$this->OPTIONS['cbu_path'];

to

		// File Information 
		$this->DATE = date($this->OPTIONS['cbu_date2']);
		$this->PREFIX = &$this->OPTIONS['cbu_prefix2'];
		$this->DUMP_PATH = &$this->OPTIONS['cbu_path2'];

4. Make this change inside cronbackup2.php
From

   require_once(DIR.'/includes/mysqlbackup.php');

to

require_once(DIR.'/includes/mysqlbackup2.php');

5. Add new Scheduled Task to start at first day of each month and to run it from cronbackup2.php
6. Done

It was too easy once you figure out, but thanks to Paul for giving the hints. Step 2 was key.

I hope someone finds this useful.