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.

[BadgerDog]

Originally Posted by Paul M

Yep, that sounds about right.

Thank you....

Regards,
Doug

[singh9211]

Gr8 mod, working fine after installation.

Is it possible to have an remote backup option(remote file transfer through FTP or scp or rsync, etc) available with this mod.

[TeknoSounds]

Originally Posted by singh9211

Gr8 mod, working fine after installation.

Is it possible to have an remote backup option(remote file transfer through FTP or scp or rsync, etc) available with this mod.

setting up remote transfer would be outside the scope of the mod, as it would be a nice feature, the process of setting up a secure rsync connection is quite a pain as it needs generated passkeys to verify passwords and all sorts of fun stuff. If it was possible I think the amount of work involved to get it running wouldn't fun for Paul.

Heres a howto for you tho:
http://thedrupalblog.com/setting-pas...d-rsync-backup

[odie3]

Thanks for this mod. I had one like this for vB 3.6.x but one thing it would do was to create a folder for the year, then month under it, then day under it - then the backup files would go into that folder.... that's a nice option, can yours do that too?

nm, i like the lower case "L" options from http://uk.php.net/manual/en/function.date.php better I think.

[sc123]

Is this reliable?

[MarceloS]

Paul, your product is great, and I use it in all my sites.

I have two suggestions, maybe for a paid version (I would be willing to purchase):
1. Auto-delete older backup files (you could choose to keep only the last "X" files).
2. Send to Amazon S3 or other storage system.

Thanks

[MarceloS]

Originally Posted by sc123

Is this reliable?

Yes it is! I had to use hte backup files once and it worked perfectly.

[iyama]

Processed Database in 17.986 seconds

[Compressing Combined File] : Processed File Compression in 0.011 seconds

Backup Completed Successfully

3.5G

The line: <!-- $Header: F:\CVS/4.x/Auto-backup/Auto-backup.txt,v 1.3 2010/12/04 22:52:33 Pem Exp $ -->

Is that for the header?

[Paul M]

0.011 Seconds ?

That suggests it simply skipped the compression.

That line is a cvs comment.

[fxwoody]

Hi Paul, i might have a little question here, been using your plugin for over a year now and works like a charm, tho, i had to upload one of the b-up in my test site and when it finished, every words in french that had an accent ????^ got lost and replaced by "?" instead!
I looked into the setups from the language manager and they are set to ISO-8859-1, in MyPhpAdmin the charset are UTF-8 and collation Latin1_general_ci. Normally this setup shouldn't loose any of the special character but it does!

Now, i know that phpMyAdmin as updated and the options to export and import have kind of changed (they added more option to the fields) and since i'm not a top gun i wondered if you would have an idea about this!?!?

I also looked in the ACP option and the "Censorship Options" / "Blank Character Stripper" are still the same as originally " 160 173 u8205 u8204 u8237 u8238" .
So as far as it goes the only probable mistake i can find could be from the "collation_connection" and "collation_server" that are set to "latin1_swedish_ci" instead of "general_ci"!

But could this little difference make it all happen???
Thanks in advance Paul, i would appreciate some advice here :up: