Administrative and Maintenance Tools - vBulletin Cron Based Database Backup

As of 23 Nov 2017 this modification has been withdrawn.

This is a cut down version based on a backup system written by Trigunflame for vb 3.0. It is a simple vBulletin cron trigged php system that does a dump of your database - either as one complete file, or as one file per table. Especially useful now that IB removed the old ACP backup option in vBulletin 4. Files can be (G)Zipped to save space.

All the options are located in the ACP in vBulletin Options >> vBulletin Automatic Backup

To install, download and unzip the files, and follow the instructions in the text file.


History:

v4.0.1 : 28-Dec-2009 : Initial release for vb 4.0.0 Gold.
v4.0.2 : 29-Dec-2009 : Added ability to block process larger tables.
v4.0.3 : 27-Jun-2010 : Added Gzip option.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.0.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.

v4.2.0.0 : 24-May-2012 : Updated for vBulletin 4.2.0.
v4.2.0.1 : 17-Mar-2013 : Removed vboptions from backup call..
v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added mysqldump backup.

[djbaxter]

Originally Posted by Bob_R

How come/Why are the queued files are a different count every day. I understand if you had a mod the count changes. But, I haven't added anything lately and the numbers seem to be different most of the time after being a constant number for the longest time.

Thanks.

Originally Posted by charlesr

Cache files?

Originally Posted by Bob_R

Need answer. TY. :up:

I think Charles answered you. There are database changes that change:

various log files
autosave
cache, externalcache
cpsession
datastore
indexqueue if you use it
mailqueue if you use it
plugin as you add and delete add-ons
session

[sivaganeshk]

possible to take this backup once in a week to AWS Glacier?

[Paul M]

I dont know what that is.

This will only backup to a folder on your server. Technically that could be an NFS mapped drive or some other remote system, however, it must appear as a folder or simlink on the server.

[DemOnstar]

Originally Posted by friendlymela

which Vb version u r using?

4.2.1

[chikuru]

After 4.2.2 upgrade:

I ran the scheduled task manually,

Warning: Assigning the return value of new by reference is deprecated in ....\includes\cron\cronbackup.php on line 18

[ozzy47]

Open the file, includes\cron\cronbackup.php on line 18, in that file find the following:

$excludedForums = s$mysqlBackup = &new mysqlBackup($vbulletin->db, $vbulletin->options);;

Replace with:

$mysqlBackup = new mysqlBackup($vbulletin->db, $vbulletin->options);

[jluerken]

Ho ozzy47,

after updating to 4.2.2 I get this error message in addition to the one you fixed already:

Warning: Function set_magic_quotes_runtime() is deprecated in ..../includes/cron/cronbackup.php on line 13

Do you have a fix for this too?

[ozzy47]

Open includes/cron/cronbackup.php and replace.

@set_magic_quotes_runtime(0);

Wit this

ini_set("magic_quotes_runtime", 0);

This is untested, but it should work.

[Superorb]

Hmm, weird... I just upgraded to 4.2.2 from 4.2.0PL3 and the only thing I had to change on line 18 was to omit an "&" from before "new", the rest of the string was identical. And I'm not getting an error on line 13 and mine still says "@set_magic_quotes_runtime(0);".

[ozzy47]

That may be due to your php version.