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.

[RichieBoy67]

Three directory where the back up is to be placed need to he write permissions.

[Idawg]

Fixed the issue... I had one too many ../ on the path... Fixed that and it works a-okay now

[Paul M]

Originally Posted by Manoel J?nior

Advise not to use this product if you have a forum that goes from 1GB database, I recommend you look for something like mysqldump

Only just noticed this, which is complete rubbish.
My forum has been over 1GB for years, and happily using this for years.

(In fact, if you had bothered to check, it actually has an option to use mysqldump, rather than the php based dump routine, built in).

[elsa23]

Hi,
What is the difference between php and mysql? which one is recommended to use, to can restore in the future with "bigdump"
Because, with "var $DTYPE = 'php';"all its OK.
But when I confgure it to "mysql" , I got this error and the backup folder is empty:

Automatic Database Backup for vBulletin


PHP Warning: Invalid argument supplied for foreach() in ..../includes/mysqlbackup.php on line 626

Backup Completed Successfully
Fait

Thanks
4.2.3 PL2

[elsa23]

Also, I had set Scheduled Task to "3h" of the nignt, but It do it at "5h", 2 hours later

[Paul M]

Originally Posted by elsa23

What is the difference between php and mysql? which one is recommended to use, to can restore in the future with "bigdump"
Because, with "var $DTYPE = 'php';"all its OK.
But when I confgure it to "mysql" , I got this error and the backup folder is empty:

'mysql' will attempt to use mysqldump, which in your case looks like it wont work, so just stick to using 'php'.

[elsa23]

Originally Posted by elsa23

Also, I had set Scheduled Task to "3h" of the nignt, but It do it at "5h", 2 hours later

I'm off topic, but I found also that notifications, via emails, for new replays, arrives 2 hours later, It's a server bug ?

[elsa23]

I do not understand the time offset

[orangedays]

will this work with version 5?

[Paul M]

If you manually installed the files, and manually added the cron job, I think it probably would.

However, the product would not install using the normal ACP method.