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.

[Paul M]

Tom ?

[shuuk]

hmm what code is the back up format? its not utf8 :/
how can i find out?

[MaXimus]

Originally Posted by Boofo

Not a good place to have it as that makes your backups available to almost anyone. The best place for the backups folder is in the same folder as public_html. Then use the following for the path:



If you can't do that, then at least password-protect the folder via htaccess.

Thanks a lot for the tip bro

but when I did that and ran the backup, I got the following error message:

Automatic Database Backup for vBulletin

Warning: include_once([path]/./includes/cron/cronbackup.php) [function.include-once]: failed to open stream: No such file or directory in [path]/admincp/cronadmin.php on line 113

Warning: include_once() [function.include]: Failed opening '[path]/./includes/cron/cronbackup.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 113

Done

I created a folder named backups in the root of public_html

what do you think I should do?

[Boofo]

Are your forum files under the forums directory or in the domain root itself?

[MaXimus]

Originally Posted by Boofo

Are your forum files under the forums directory or in the domain root itself?

no the forum files are in

public_html/forums

my Wordpress site is in the public_html

[Boofo]

I have it set up like this:

vb4_db_backups
public_html

Then you can use what I posted earlier but make sure the folder is chmodded to 777.

[MaXimus]

Originally Posted by Boofo

I have it set up like this:

vb4_db_backups
public_html

Then you can use what I posted earlier but make sure the folder is chmodded to 777.

got it done at last!

thanks a lot bro!

[Bergler]

Is there a way to set this up so everytime it backs up, it overwrites the existing file instead of creating a new file everytime?

[Paul M]

Change the filename date setting to something that doesnt change often, like Year, or Year+Month.

[MaXimus]

I have created a database backup

let's say I wipe my forums entirely and want to reinstall it from scratch, how do I restore this database backup to have all my members, posts, threads restored?