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.

[XxSparks]

I have this installed, but it seems like Cron Job isn't being run daily, could this have something to do with the forum being offline perhaps? Or should it run daily regardless?

[Paul M]

The vbulletin cron system relies on people visiting the forum.

[XxSparks]

ah, okay, thanks so much Paul!

[mrdexx]

Sorry if this is a newb question, but this program generates a .sql file, and then I take this file and import it within cpanel to restore the database through importing in phpwizard? (in the event of things going sideways etc.)

Basically just wondering if important/restoring the database using this mod is different than the backups done through exporting from phpmyadmin?

Thanks!

[Paul M]

I have no idea what phpwizard is.

[mrdexx]

Sorry I was exhausted when I wrote that, I meant to say does it generate the same files as if I had exported my database through phpmyadmin?

[Paul M]

All text based mysql exports are similar, whatever software creates them.

[Ark del KAOS]

Hi Paul!
I had a problem yesterday when I put back a sq backup made with this mod, and maybe you cant give me some advice about it.

I use a utf8 Spanish forum, because there's some symbols like the ? or accents who cant be showed properly without utf8.
The forum work perfect with the language option of charset tuned to utf8, etc
But yesterday I migrate the forum from a cluster server to a dedicated one, and when I put the system back the database shows all the special characters wrong.

I put it back uploading the backup with ftp, and the running this:

mysql -uUSER -p DATABASE < /../../../../../backup/db-100220-Full-Backup.sql

Well, It's the standard one Nothing out of ordinary.

When I open the mysql with phpmyadmin, and examine the data itself, (ej: post) in the pagetext column I can read the info contained, but It's wrong with the same mistaken charset symbols.

The MySQL charset its UTF-8 Unicode (utf8)
And the collation its utf8_general_ci
But then there some of the tables collated in latin1_swedish_ci

I don't know anything more to play with, trying to recover it.
Could you give me some advice?

[Ark del KAOS]

.....You know when you get out of ideas, and make a post....and then, coming from anywhere, the one only thing you don't think off shows up, and save the day?
Its always the same XD

--default_character_set utf8

That did the trick, and save me from this mess XD
(I swear I try it, but It seems I misspelled the option some where in the process...? ?)

Well, anyway, thanks for all your hard work with so many good mods! ^ ^

[s0lidgr0und]

Trying now.

*crosses fingers*

Edit: Failure. Looks like HostGator is the issue.