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.

[Mariner1]

Thanks charlesr,server reboot worked.

[ozzy47]

Originally Posted by Mariner1

Hi. This has been working fine until a few days ago.When trying to do backups now i get this error in admincp

Database error in vBulletin 4.2.2:

Invalid SQL:
OPTIMIZE TABLE `filedata`;

MySQL Error : MySQL server has gone away

Any idea what this is and how to fix it pls

I see you got it going by doing a server reboot, that's great. But you may run into the issue again.

MySQL Server has gone away" is a server issue. See this: https://www.vbulletin.com/docs/html/...mysql_goneaway and this: https://www.vbulletin.com/forum/show...265#post310265 You will need to talk to your host about this in order to get it resolved.

[Paul M]

Originally Posted by Mariner1

Hi. This has been working fine until a few days ago.When trying to do backups now i get this error in admincp

Database error in vBulletin 4.2.2:

Invalid SQL:
OPTIMIZE TABLE `filedata`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, January 2nd 2015 @ 05:54:35 AM
Error Date : Friday, January 2nd 2015 @ 05:55:08 AM
Script : http://www.xxxxxxxxxxx.com/admincp/c...cron&cronid=95
Referrer : http://www.xxxxxxxxxxxx.com/admincp/....php?do=modify
IP Address : xx.x.xxx.xx
Username : xxxxxxx
Classname : vB_Database
MySQL Version :

Any idea what this is and how to fix it pls

It looks like optimizing that table took longer than your mysql timeout.

It should have run fine again next time.

You dont really need to have that [optimize] option enabled, I would turn it off.

[Daniel]

Hi Will this work for big boards (1mil+ posts & attachments allowed)?

[Paul M]

I have over two million posts.

Attachments will only be backed up if you store them in the database.
Thats generally not a good idea if you have a lot, as your database will be large.

[thunderclap82]

Is there a way to configure this so that the database is sent off server to something like Dropbox or Google Drive?

[Paul M]

Not unless there is a way to specify it as a server path.

[ebp123]

can someone explain to me how to actually run this backup program? I just installed it and set the backup folder location and am a bit confused.

[Paul M]

Well the title and description should give you a clue

vBulletin Cron Based Database Backup

It is a simple vBulletin cron trigged php system that does a dump of your database

It runs automatically, thats the purpose of cron based systems.

[ebp123]

So once i set up the backup folder, it automatically puts back ups of my database in it? Forgive my ignorance, im just a lumberjack trying my hand at the internet.