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.

[Fynnon]

it works for me very well...i had little issues with it but nothing that could not be solved with patience
10x

[sakiri]

Originally Posted by Paul M

That is correct.

Thanks.

[crazlunatic]

got a few questions:
where can I edit the settings?
where does the backup go to?

[Paul M]

1. In the settings file

2. Wherever to set it, see Q1.

[blackwolf062]

thanks installed and works

[alfaowner]

I had the sql issue, but my path was wrong in the config file, once I put the path in, it worked like a dream on 3.8.2, thanks.

[CableSux]

Originally Posted by Paul M

There is no limit built into this, so as long as your php does not timeout there is no reason you can t use it with a 2GB database.

I'm having the timeout issue. Backup stops around table "template" or "thread". Any suggestions? I'm on godaddy. I had the write error issue, too. I simply changed
$backup['DUMP_PATH'] = '../../backups/'; to
$backup['DUMP_PATH'] = './backups/';
and it worked just fine. Also change the date to small L and that works just fine, too. Thanks!

P.S. I'd love for this to work... I'm getting real tired of running mysqladmin backups!

[Paul M]

Decades ?

I'll be happy if I'm still alive in decades to come

[tedology]

Thanks for doing this, Paul.

The instructions were simple enough even for a ROOKIE like me.

Question:

I followed instructions and uploaded the XML file.

Now what?

Is there something I need to run?

I see "Alter the cron job to suit"

not sure how I do that.

Is there some sort of .exe file I run to make sure I start backing up my DB?

And I'm guessing this is only for vbulletin, yes? Won't work with photopost pro...?

Thanks again!

[tedology]

Paul, when I run it... I get the following error:

An error occured during the Backup : Could not open Destination SQL file for writing.

I've checked permissions and have tried various paths.