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.

[autoescala]

Excellent works fine in 4.2! 5 stars rating mod

[panosha]

Can you help me find the right Backups Path ?

This one do not work ---> http://www.xxxxxxx.gr/backups/

[GamerPerfection]

Originally Posted by panosha

Can you help me find the right Backups Path ?

This one do not work ---> http://www.xxxxxxx.gr/backups/

Dude you don't "find" a backup path, you "create" a backup path.

Basically you create a folder on your server and you use that as your path.

So if you go with "backups/" as your path then you must create a folder on your server in the root directory called backups.

[charlesr]

I was a little skeptical about this working without turning the forums off, but I've successfully restored the 1.5GB database (along with a copy of the filesystem) on to a local machine and it works perfectly so far.

Kudos for a great mod. This should be standard in vbulletin. I hit "nominate".

[charlesr]

Also, sent you a chunk of paypal, so you should be good for beer for a while

This is the most important mod on the site.

[Paul M]

Originally Posted by charlesr

Also, sent you a chunk of paypal, so you should be good for beer for a while

Appreciated. Thx. :up:

[Kirk Fitzgerald]

Perfect mod, works like a dream, thank you. Nominated for MOTM.

[letipro]

if can backup to a different host or server is excellent

[Paul M]

Well you could in theory, if you setup a folder thats actually mapped to a networked drive (using NFS for example) then the backups could be directed to it.

[rhody401]

I am using a freebie called FTPSYNCH to work in conjunction with this.

It FTP's from my PC into the website twice daily, just after the cron backups happen. (6am and 6pm) It synchs the local folder with that of the server's backup folder, effectively downloading just the sql backup created a few minutes earlier.

In addition to this, i have it doing a sql single file download once daily (overwriting every 7th day, for day of the week), so there's always a 7 day history in addition to what this add-on provides. I am only using this add on for a once weekly comprehensive backup, file by file. The twice daily ones are a single file done with a command line cron command.

There may be better ways, but this works for me