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.

[GoTTi]

geting error

Automatic Database Backup for vBulletin
An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

[GONUMBER6]

Yes, I missed installing 1 file. Works like a charm, and took 17 seconds!

Thank you SOOO much, nominated for MOTM.

[begin]

Installed . Thank you !

[cherylferraro]

This is a great time saver. Thanks for sharing it.

[onehost]

Paul,

I just want to say, this backup does not mean much sitting on the server
if the server crashes and they can not retrieve their own backup for
some reason, how about an email option to send us an email attachment
of the database when it is finished running?

very nice though...

Processed Database in 1.714 seconds
Backup Completed Successfully

Yes it would be great if you added an email option, as I have been manually saving the DB
daily to my drive, but relying on the server to hold the backup could be risky if
anything actually happens to the server...maybe multi backup...one saved
in backup, and the other emailed...that would be sweet.

I do have a question, when I did a manual backup of mysql vb it was
only 1,800kb but when the autoback run, it is 13,000+KB....
what am i missing here?

[onehost]

I do not think this is working correctly, ever since I installed it, it seems to be
making the same backup over and over with the same KB, and instead
of creating a new backup file, it just over-writes the one that was there
before. I always backup using a different name just incase there are
errors produced in the first, so I always have a new file name for a
new backup...

[Paul M]

It works correctly, but I cannot comment on how you have set it up on your server.

If your are creating the same filename each time then yes, it will overwrite any previous copy with the same name, that would need a very strange date setting.

[Krusty1231]

Works for me on 4.0.6.

Processed Database in 3.74 seconds

Backup Completed Successfully
Done

Thank you for this.

[Taurus MFF]

works beautifully, simple installation, gzip is a huge plus!

thanks for the great add on Paul, installed and motm vote!

[FASEOFMARS]

well i have installed this "automatic" backup system..

but how do i tell it when to make a backup??? im not seeing them options..