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.

[Paul M]

You cannot delete it, otherwise all your crons will crash.

Truncating it would reduce the records of course, but then you will probably find you timeout on some other table.

[snowlion]

Originally Posted by Paul M

You cannot delete it, otherwise all your crons will crash.

Truncating it would reduce the records of course, but then you will probably find you timeout on some other table.

OK, so what can I do now?
The backup process stopped at cronlog and can not complete

[gsmlover4u]

installed on 2 forums
working fine on 1 my forum
and not completing backup on second forum always stoped

[Leica.Robbiani]

Hi there,

I dont wanna talk the work of Paul bad, but as a friend of mine told me about mysqldumper I checked out this tool. Since once installed this tool and checked it out I love it. I think there is no better way to make database backups and restore them if needed.

Sorry Paul, my post is not against you personally and your work, but I think everybody has to find out his best way to make and restore backups and tell it to the other users.

Best regards

L.R.

[DAMINK]

Originally Posted by Leica.Robbiani

Hi there,

I dont wanna talk the work of Paul bad, but as a friend of mine told me about mysqldumper I checked out this tool. Since once installed this tool and checked it out I love it. I think there is no better way to make database backups and restore them if needed.


Best regards

L.R.

Agree 100000%
i have been using it for some time.
Backing up and sending the backup to my local NAS.
Could not ask for a better result.
Restored the backup many times and never had an issue.

[smirkley]

I have used mysqldumper too,... and yes it is quite nice.

But this mod conveniently performs the backup service automatically , replaces older files by your discretion settings, and stores them in a non-public fashion ready for you to ftp off site at your convenience. All within the vb cron mechanism.

I prefer to use mysql to perform my restores directly.

It is a nice bundling of backup service when using vb. Perfect for my forum.

[djbaxter]

Originally Posted by smirkley

But this mod conveniently performs the backup service automatically , replaces older files by your discretion settings, and stores them in a non-public fashion ready for you to ftp off site at your convenience. All within the vb cron mechanism.

How does it do that? I go in manually once a week or so to delete old backups - how do you do that automatically?

[CharlieDelta]

Originally Posted by djbaxter

How does it do that? I go in manually once a week or so to delete old backups - how do you do that automatically?

I do it as well.
Date Format in the settings. I have mine set at Y-m.

[smirkley]

I have the date format set for simply 'd' for date of the month.

This way my server holds 31 backup files, and overwrites each day the same file.

I can backup anytime within a month from any date, or from older offsite saved files if needed.

[djbaxter]

Originally Posted by smirkley

I have the date format set for simply 'd' for date of the month.

This way my server holds 31 backup files, and overwrites each day the same file.

That's actually pretty clever if you have plenty of diskspace.

What would be better is a cron job to delete backups older than X days.