Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6

This modification is no longer available or supported.

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 for vb 3.6.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. A while ago David gave me permission to release my adaption, but until now I haven't got round to it. Trigunflame did mention a few months ago he was working on a new version, but nothing ever appeared.

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. It's been in use on our forum since the day 3.6 was installed.

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 3.0 backup functionality on 3.6.


History:

v2.10 : First internal version.
v2.11 : Bug fixes, some code changes.
v2.12 : Initial Public Release.

[Eagle Creek]

Looks nice! Very nice!

Does it also work with the really big ones?

[Paul M]

Define "really big".

[Eagle Creek]

2GB + Databases.
200.000 + Posts.

[Paul M]

Well our forum has about 850,000 posts and backs up fine, but the database isn't 2GB. The largest I've personally used it on was 1.4GB, I see no reason why size would matter though.

[Eagle Creek]

Just wondering :-).

Because vBulletin advices to avoid the build-in backup option if you have a large database.

Thanks again Paul!

[smoknz28]

Paul, is there a way to purge the backed up databases automatically after a certain day? Like, purge backed up databases after 5 days?

Thanks Paul for a great hack for us Admins. :up:

[Paul M]

Sorry no, there is no such option, you have to do it manually.

[Tigratrus]

Hey Paul/all. Thanks for this update... I'm a recovering Win2k person and I'm trying to get a handle on MySQL via command line, I've used Navicat for most of my MySQL work so far... The backup seems to work flawlessly, can anyone point me to a good way to restore it on another server? I've got a test server and I've copied the folder with all the .sql files in it. I downloaded a copy of the MySQL Administrator but it only seems to work with a single file at a time? I assume there's an easier way via the command line? ::sigh:: Thanks in advance for any assistance anyone can provide... Or for pointing me in the right direction ;-).

[Paul M]

Connect to mysql from a command line using the "mysql" command, then connect to the database using the "use" command, then import the file using the "source" command.

[Tigratrus]

I think I've puzzled out most of the details, thanks for pointing me towards the relevant commands. The one thing I haven’t been able to get working yet is the use of a wildcard for the source command? In a windows environment (my testbed) I dropped a copy of the backup folder created by this mod at the root of c:\ I connected and logged into the mysql utility with my target database active.

Then I tried:
source c:\2006-12-19\%.sql
but that threw an error.

I tried:
source c:\2006-12-19\*.sql
just for the heck of it but that threw an error as expected too.

IS there a way to feed in multiple files? Doing it individually works but that’s a LOT of files to run though. O.o

I’m quite sure I’m missing something very basic here, but it’s the dead bone simple things that are the hardest to figure out as none of the references mention them ;-). I really appreciate the help… I’m TRYING to get a handle on the command line vs GUI as I need to move in that direction to effectively work in Linux (my production server) but I’m not quite there yet.