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.

[patracy]

Originally Posted by Dave

To be honest if your database is reaching a point where it's getting quite big, you should not rely on such plugin anymore but create your own OS based cronjob. In Linux you can make use of crontabs and create a basic bash script that executes the mysqlbackup command.

That's true. And actually that's the direction I've been meaning to go in. But I've not been able to find a method on scheduling vB on/off. I suppose I could cron apache on and off, but that'd leave users in the dark.

[shimei]

Originally Posted by patracy

That's true. And actually that's the direction I've been meaning to go in. But I've not been able to find a method on scheduling vB on/off. I suppose I could cron apache on and off, but that'd leave users in the dark.

I began a thread here on the subject: Maintenance Page for Cron Backup

[Davidinh]

seem something were missing in the Auto-backup.txt and base on my problem I would like to share to all

Installation
------------

1. Copy all files in the 'includes' folder to the server.

2. Upload the product XML via the Product Manager.

3. Set your choice of options in the ACP (vBulletin Options).

4. Alter the timing of the cron job to suit.

5. To use the (experimental) MySQL backup option, you need to edit the mysqlbackup.php file.

Find var $DTYPE = 'php'; and change it to var $DTYPE = 'mysql'

In a case for new version of mysql you should add var $MYSQLI; (after var $MYSQL) in mysqlbackup.php then change var $DTYPE = 'mysqli' ;

6. Create the new folder as "backups" or what ever you desire for it then set permission as 777

if it is in the root website in AdminCP option should set ./backups/
if it is in the forum directory in AdminCP option should set ../backups/
and so on.

hope it helps

THANK YOU PAUL it is useful mode

[Paul M]

Originally Posted by Davidinh

In a case for new version of mysql you should add var $MYSQLI; (after var $MYSQL) in mysqlbackup.php then change var $DTYPE = 'mysqli' ;

This isnt necessary, and wont do anything.
In fact, if you set $DTYPE = 'mysqli' you will end up using the php backup process.
You seem to be confusing variable names with actual database systems, the fact you are now using MySQLi doesnt affect the variable names.

For the backup path, you should never use a website location (i.e. one thats accessible via a url) such as the two examples you gave, otherwise anyone can potentially just download your backup files.

[twlMavRic]

Installed and ran backup in just over 11 secs. Works as advertised

[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

[charlesr]

Any particular reason? Mine is 3.5GB and it works ok. It compresses to a 600MB .gz
I haven't tried restoring it for a while, but it worked a while back ok.

[Idawg]

I have used this mod for years, on many forums I set up/run for clients..

On my newest forum, I am on 4.2.3 and I uploaded to correct location, set everything under options and when I go to save, it gives me a 404 error????? What is up with that ??

[RichieBoy67]

File permissions set to 777?

[Idawg]

On what???