Administrative and Maintenance Tools - vB Database Backup

This modification is no longer available or supported.

Note: Because I did not write the original version, but rather have modified & adapted it, support of this modification may be limited

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it, first for vb 3.6 and now for vb3.7.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. In 2007 David gave me permission to release my adaptation.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (lite) version that does a php based dump of your database either as one file, or one file per table.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic backup functionality on 3.7.


History:

v3.7.001 : First version for vB 3.7.

[Paul M]

Sorry but if it failed then the problem is local to you. My database is 10 times that size, and Ive tested on even bigger.

[abroad]

Does this work now or not? I was never able to make an update and upload the data to a new Database since I have this vbulletin. I always get SQL errors when I try to upload the database to a new one. I have also tried it according to the vbulletin manual. Anbody has some ideas?

[Paul M]

Originally Posted by abroad

Does this work now or not?

Not really sure what you mean by that. This has worked since the day it was released - and runs my backups every night (and has done for a few years now).

[abroad]

cool...does the normal backup which comes with vbulletin work for big tables? It never worked for me even if I do it according to the manual...

[Paul M]

I cannot comment on the vb system, never used it.

[snakeair]

Very nice simple mod that work's great. "Clicks Installed"

[connkid25]

Just a quick question. I have this set to save as one file but when I save directly through the vbulletin backup that file is larger than the one this generates. I have run them both at the same time.

For instance.. On my test installation I get the following:

Directly through vbulletin: 6.20M

Through this script: 6.13M

What exactly is this leaving out? Just curious and wanted to make sure this is a true backup. This is pretty cool and very useful for those of us who always forget to backup!

[TomJames]

Originally Posted by connkid25

Just a quick question. I have this set to save as one file but when I save directly through the vbulletin backup that file is larger than the one this generates. I have run them both at the same time.

For instance.. On my test installation I get the following:

Directly through vbulletin: 6.20M

Through this script: 6.13M

What exactly is this leaving out? Just curious and wanted to make sure this is a true backup. This is pretty cool and very useful for those of us who always forget to backup!

I don't know for sure but my guess is that this might only be backing up vBulletin tables whilst the method built in will (by default) backup everything that has a table (plug-ins etc)

[connkid25]

Originally Posted by TomJames

I don't know for sure but my guess is that this might only be backing up vBulletin tables whilst the method built in will (by default) backup everything that has a table (plug-ins etc)

I just installed a few mods from .org onto the test board and those tables were saved. The sql file sizes are still different though. I imported the sql from this mod into a new database and ran from that. Everything seems to be working so im not complaining!

[Paul M]

Different methods will produce files of different sizes, it depends on what comments are added and what method exactly is used.