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.

[Hawkgirl]

Hey there! I've been using this forever - thank you so much for this mod.

A few weeks back I upgraded site to 4.2.2 (from 4.1.6). I just realized that I forgot to update this mod (no site backup for two weeks - ACK). I did so today and I'm getting the following error message(s). Can you help? Many thanks!

Automatic Database Backup for vBulletin

Warning: Missing argument 2 for mysqlBackup::mysqlBackup(), called in ..../includes/cron/cronbackup.php on line 22 and defined in ..../includes/mysqlbackup.php on line 574

Warning: Missing argument 3 for mysqlBackup::mysqlBackup(), called in ..../includes/cron/cronbackup.php on line 22 and defined in ..../includes/mysqlbackup.php on line 574
Backup Aborted : vBulletin Options Error

[EpicArchibald]

I am also receiving the same output as Hawkgirl.

I typically just ssh in from phone or computer and run a mysql dump to my web server. An auto option would be nice if the errors can be sorted.

Version 4.2.2 here.

[Paul M]

I'm afaid I didnt see the question from Hawkgirl at the time.
Those errors mean you/they have a mismatch in the modification files.

The mod comes with two files, and the product XML, you need to make sure you update all of these to the latest version.

[Powerlynx]

but does this backup everything, including images, videos, thread content, absolutely everything? ...not just the database which doesn't have images and videos in them?

I need something to run daily backups to an external hard drive so I can keep a physical copy of each daily backup into separate folders. So then if the site goes down, I can just reload a whole backup file and the site will be exactly how it was originally with everything.

[RichieBoy67]

Originally Posted by Powerlynx

but does this backup everything, including images, videos, thread content, absolutely everything? ...not just the database which doesn't have images and videos in them?

I need something to run daily backups to an external hard drive so I can keep a physical copy of each daily backup into separate folders. So then if the site goes down, I can just reload a whole backup file and the site will be exactly how it was originally with everything.

This is just for database.

You need something on your server to do as you want.

[Powerlynx]

ok...how much time would be involved to do something like that you think? and I would like to be able to link my computer up with the server so it automatically backs up to an external hard drive which I physically have.

[RichieBoy67]

I think you can do this yourself through your host/server cpanel. They must have a back up option with a scheduled task

who is your host and what kind of server do you have?

[Powerlynx]

its GoDaddy...(don't laugh :/ lol) not sure which server, but the last one that will work with the vB Pro Garage mod as that has a server upgrade limit.

I'm looking for a "set it and forget it" backup program, something always taking care of itself...all on it's own with no multiple steps for me to do.

I have seen other backups but I can't find anything out there fully automated, they are all like piece-by-piece backups with steps inbetween that have to be performed manually by the admin and I don't want to have to do any interaction with it.

[RichieBoy67]

No laughing here, lots of people use Godaddy. I do not particularly like them for hosting but I have about most of my domains registered with them.

At any rate I believe you can set up a cron task()scheduled task) using their back up system and set it to keep only 1 or 2 back ups. I cannot recall though if this is built in or part of the managed back up service they offer. You could always opt for that. http://support.godaddy.com/help/arti...anaged-backups

I do not even know though if you have a VPS, shared or dedicated plan.

[doctorsexy]

Originally Posted by RichieBoy67

This is just for database.

You need something on your server to do as you want.

BigDump: Staggered MySQL Dump Importer

http://www.ozerov.de/bigdump/