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.

[thenashy]

Originally Posted by Paul M

Your web server doesnt have permission to write the files.

It's my web server. And it does have permission.

[Paul M]

Originally Posted by thenashy

And it does have permission.

If you are getting a No Permission error then your server disagrees with you.

[nick-harper]

Is there a way to make it so it only keeps the last 5 backups so it doesnt fill the server?

[djbaxter]

Yes, or at least to keep only the last 7 backups. Someone else gave me this solution a while back in this thread.

AdminCP >> Settings >> Options >> vBulletin Automatic Backup

Combine Files
Set to yes to combine all tables into one backup file. = Yes

Date Format
Backup file date format (See http://uk.php.net/date). = N

Files Prefix
Backup files prefix, this is applied to all files. = FORUMNAME

GZip Files
Attempt to GZip the backup files after they have been saved. This may or may not work depending on your server environment. = Yes

What this does is create a series of backups with the format

FORUMNAME-digit-Full-Backup.sql.gz

where digit is the number of the day of the week, i.e., 1 through 7.

Once that change is made to options, as the backups are created they are saved with that format. If the filename doesn't exist, it is created. If the filename already exists, it is overwritten by the new backup. Thus, you always have the latest 7 days of backups and no more.

This works perfectly. I've been using it for several months now.

[Paul M]

I posted the some thing a long while back, but I think I suggested using "l" (lowercase L) which is the full name of the day of the week (i.e. Sunday, Monday etc).

[djbaxter]

Originally Posted by Paul M

I posted the some thing a long while back, but I think I suggested using "l" (lowercase L) which is the full name of the day of the week (i.e. Sunday, Monday etc).

That would probably be more clear... if I'd known you could do that.

[Paul M]

As an aside, I currently use the week number (W).

This means that I always have a current daily backup, and it "automatically" leaves me with a weekly backup as the number changes at the start of each week.

[djbaxter]

But that would mean you would have 52 backups at any one time, wouldn't it?

[smirkley]

I just use the date of the month, so I will always have at least 30 backups consecutive. I dont need anything older and if I feel I do, I should be backing up at least once a month all backup files. But I dont.

[Paul M]

Originally Posted by djbaxter

But that would mean you would have 52 backups at any one time, wouldn't it?

Well if you kept them all on the server, yes.

I dont, I download them once a month and then delete older ones.