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.

[KissOfDeath]

Thank you very much, i'm not sure why they took this feature away, it's a must have

[Ragman68]

thank you Paul, this is a brilliant mod, just whay I have been looking for to backup my 896mb database, this is a must have for large databases

[Desibabu19]

Hi Paul,

Excellent piece. Installed. Thank you very much. I am using VB version 4.0.1.

Created 704 MB backup file.

Processed Database in 182.957 seconds

Backup Completed Successfully
Done

I created one backup file.

I am newbie. I have two questions.

1) If anything goes wrong and if I have to restore the datebase, how do I use this backup file to restore all tables ?

2) As you see it has taken around 3 mins to create backup for website. At any point of time there are about 150-200 users in my site. Is it recommendable to close the forums when the backup runs ? Or is it ok to leave the forums open during the backup ?

[mmacrypt]

Thank you very much. It's nice to have this running when I'm going to be away for a few day.

Processed Database in 109.96 seconds

Backup Completed Successfully

Done

Takes some pressure off. I look forward to checking it tomorrow morning and having a backup in place before I even start my day.

[Bob_R]

Originally Posted by Paul M

You can simply change the date format of the files (in the settings), and make use of the fact that this will replace (delete) any existing file(s) with the same name. On my live site I use the l (lowercase L), which means my files use the day of the week (Monday, Tuesday etc) - so I only ever have 7 backups.

Thanks bro.

Now, for the $64,000 question:

What if something goes wrong? How do you restore the backups?

Thanks!!

[SoulStealer]

Processed Database in 34.312 seconds

Backup Completed Successfully

Done

~thanks

[wampforum]

works great even for a complete noob like me - thanks

[hydn]

Will setting path to:

E:\backup\

work?

I'm on windows server.

thx

[hydn]

Originally Posted by Bob_R

Thanks bro.

Now, for the $64,000 question:

What if something goes wrong? How do you restore the backups?

Thanks!!

x2.

sorry. im really noob when it comes to backups. I usually use the mysql GUI in windows for restore. Does the combined backup file end with *.sql?

[aaronrand]

Processed Database in 7.167 seconds
Backup Completed Successfully
Done

Thanks