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.

[da420]

Thanks Paul,
Works perfectly.

One question. What's the benefit/advantages of saving the MySQL backup in seperate files for each table? And, that of saving them all as one file?

Thanks again...

[Paul M]

It makes it easier to restore just one table if you need to. If you need to restore all tables then one simple copy command will join all the files into one.

[Barakat]

$backup['DUMP_PATH'] = '/home/barakat/public_html/gti/****/'; // Path ( With trailing '/' )

works finally in that way

[da420]

Paul,

It shows that this hack has been updated since I installed when I look at the thread from the forum. I have 2.12. Is there an update that you added that you forgot to tell us about in this thread or am I just dilusional?

[Paul M]

Nothing to worry about - I simply updated some comments in the config file to (hopefully) eliminate some of the repeating questions.

[jgommel]

I just installed this in my site -- I made a few config changes and ran my first backup. All went well...or so I thought. When the script is done running, it doesn't re-activate the forums? My forums are still closed.

If I go into vBulletin's Admin-CP to turn the forums back on, they are listed as already being on. To "Truly" reactivate the forums, I just click on "yes" again and save.

Refresh the forums, and all is well.

Is there a fix/way to get the forums to turn back on after the backup?

Thanks!

[Paul M]

If your backup completes okay then the forums will turn themselves back on, so I would guess your backup didn't complete ok.

[jgommel]

Originally Posted by Paul M

If your backup completes okay then the forums will turn themselves back on, so I would guess your backup didn't complete ok.

Well, I didn't get any errors, I have a very large .sql file in my backup directory (changed my config to create one large file vs. multiple tables). Short of wiping out my database and uploading the backup from your application -- I'd say it worked just fine.

The same thing happened with prior releases as well -- I just never said anything. I figure it would get fixed in later releases.

[Paul M]

I can't fix something that afaik works. If the backup completes okay then the last step turns the forum on, does your cron job actually log a completed ok message ?

I assume you know you can disable the option to close the forum if you want, it's not necessary for it to be closed.

[Deimos]

Is it possible someone could modify this script to compress the forum backups?

It's an awesome script, but after a week of 100mb backups, it takes up ALOT of space

It's either 100mb per backup without compression, or 21mb with

Would it be ok for someone to do that Paul M?