Administrative and Maintenance Tools - vBulletin Cron Based Database Backup

As of 23 Nov 2017 this modification has been withdrawn.

This is a cut down version based on a backup system written by Trigunflame for vb 3.0. It is a simple vBulletin cron trigged php system that does a dump of your database - either as one complete file, or as one file per table. Especially useful now that IB removed the old ACP backup option in vBulletin 4. Files can be (G)Zipped to save space.

All the options are located in the ACP in vBulletin Options >> vBulletin Automatic Backup

To install, download and unzip the files, and follow the instructions in the text file.


History:

v4.0.1 : 28-Dec-2009 : Initial release for vb 4.0.0 Gold.
v4.0.2 : 29-Dec-2009 : Added ability to block process larger tables.
v4.0.3 : 27-Jun-2010 : Added Gzip option.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.0.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.

v4.2.0.0 : 24-May-2012 : Updated for vBulletin 4.2.0.
v4.2.0.1 : 17-Mar-2013 : Removed vboptions from backup call..
v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added mysqldump backup.

[X-or]

after restoring a backup created with this product, my database was completely screwed up

this product has a charset bug somewhere, don't use it

I have created a simple cron job instead and it makes proper backups

[Paul M]

Utter nonsense.

I have restored backups from this for many years, without a single issue, as have many many other people.

[X-or]

Are you saying I'm lying?

Maybe it works on 100% english sites but on forums with any kind of foreign or special characters, this product will cause massive issues.

[Paul M]

Call it what you want.

This has been around for at least 12 years, if not longer.
(in Fact longer as it was originally written by Trigunflame for 3.0)
I think if it had "massive issues" it would be known about long ago.

Just because YOU had an issue it does not mean everyone else does.

[X-or]

Your product doesn't escape special characters properly
any query with a special character will be interrupted at the special character location
it's very easy to miss

just because I'm the only one who reported this doesn't mean I'm the only one who had issues, it means I'm the only one who noticed the issue AND reported it

Feel free to ignore my report good Sir, I'm just warning other users.

[Stratis]

Originally Posted by X-or

Your product doesn't escape special characters properly
any query with a special character will be interrupted at the special character location
it's very easy to miss

just because I'm the only one who reported this doesn't mean I'm the only one who had issues, it means I'm the only one who noticed the issue AND reported it

Feel free to ignore my report good Sir, I'm just warning other users.

Some thing like your problem...
My issue was when i tried to restore, all forum was scrued up. No tables, errors and so on. Maybe because i do not use english language. as you say. I informed developer too.


Any way thanks.

[adkaush]

Originally Posted by Manoel J?nior

Advise not to use this product if you have a forum that goes from 1GB database, I recommend you look for something like mysqldump

How do you get that to work? Where to install it? Total newb here, please advice. Thanks!

[Paul M]

If you bothered to look, you would know this has the option of using mysqldump as well.

[X-or]

Are you talking about this?

v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added experimental mysqldump backup.

Dear Mr Paul M, we just can rely on experimental products for something as important as database backup.

With all due respect for the quality products you made available for everyone free of charge, this one particular product is a failure. It's your right to not fix it, I respect that, but please move it to the graveyard instead of risking compromising users databases.

[Paul M]

No.

If you dont want to use it, move on.
Its not a failure nor does it compromise anything.
So far I have tolerated your silly remarks, that stops now.