Administrative and Maintenance Tools - vB Database Backup (Lite)

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

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, 3.7 and now for vb3.8.

The original version was by Trigunflame and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later 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.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

[Paul M]

Originally Posted by princeedward

InnoDB Tables
Set to yes if you have any innodb tables
...care to explain this pls.

http://en.wikipedia.org/wiki/InnoDB

[mackers8923]

This is a fantastic hack, I have it installed and being automatically downloaded every night in the early hours using a download manager, 100% working been waiting for something like this to tweak for a long time...

BZ

[Ice-Maiden]

Hi can someone please answer a quick question for me!

A couple of weeks ago my host gave me a fresh install due to a confliction with my database i couldnt access the ACP panel, anyway when they re-installed the boards they added a back up file public_html_backup on my server, now my question is do i need to install this mod to gain a back up or does my site automatically back up anyway thru this new folder as i just looked in there and there is everything i have on site in the public_html_backup folder

Sorry for the question if it sounds dumb but im new to vb so still learing how to deal with mods etc

Thanks in advance!

[MrDeath]

Originally Posted by Paul M

That depends on how your server is configured.

thx paul for your reply... i have another question...
i always backup my db as a single file. But this mod creates a separate folder for each backup which is not needed... is there any setting so that every backup goes into the same folder?

[Paul M]

Yes, (in the settings ...... )

[matt4]

Paul, What's the cron to use? I can't find it anywhere.

Thanks

[MrDeath]

Originally Posted by Paul M

Yes, (in the settings ...... )

thx paul..
but i cannot find the settings .... in vb options there is setting for automatic backup but i could not find what i want... can you please pin point the setting.... thx a lot for your time

[Paul M]

vBulletin Options > vBulletin Automatic Backup > Combine Files

[princeedward]

Originally Posted by Paul M

http://en.wikipedia.org/wiki/InnoDB

thanks paul...but to complicated for like me to understand it...LOL

[MrDeath]

Originally Posted by Paul M

vBulletin Options > vBulletin Automatic Backup > Combine Files

that i already did... let me explain it more clearly...

my backup folder is /home/xxxx/forum_backup/

now inside that forum_backup folder i have several folders
forum_backup/2009-08-31/Form-2009-08-31-full-backup.sql
forum_backup/2009-09-01/Form-2009-09-01-full-backup.sql
forum_backup/2009-09-02/Form-2009-09-02-full-backup.sql

so you can see that every day a new folder is created of that particular date... Creating new folder for each backup make sense when you are NOT using combined files...

so what i want is the all the backup files should go into the forum_backup folder and do not create separate folder for each date..

thanks!!