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.

[Superorb]

Originally Posted by Delfi_r

Wich file I should modify?

The mysqlbackup.php file, but this code did not work for me when I added it to the test or live sites.

[charlesr]

Originally Posted by betterthanyours

Is there anything similar that will backup and then also upload to remote site at all?

If you have server access to two servers you could set up an rsync with ssh on a cronjob to sync the backups created by this mod to a remote server. Probably.

[betterthanyours]

I do have shell access to both servers. Is there a tutorial on this anywhere?

[charlesr]

I haven't tried it myself. I googled and found this which should probably work: http://troy.jdmz.net/rsync/index.html and could include your forum filesystem as well as the db backup. Please report back on your progress

[Delfi_r]

Originally Posted by Superorb

The mysqlbackup.php file, but this code did not work for me when I added it to the test or live sites.

thanks, I'll try and report

[Cicada]

doesn't seem to be backing up _all_ of the tables...

[Superorb]

Originally Posted by Cicada

doesn't seem to be backing up _all_ of the tables...

Which tables is it missing? My backups seem to be smaller than the DB size, but when restored to a test installation all the stats and data usage reported in the Vb admin pages is identical.

[steeler7]

Paul,

Mod was working like a charm and then we changed accounts (stayed with the same host, just moved to a different server) and ever since, I'm not getting any Backups made. It's not version or vbulletin version based either since I recent;y upgraded to 4.2.0 and the newest version of this Mod and nothing.

Could there be something on the host side (using VPS) preventing this from working?

[Superorb]

Originally Posted by steeler7

Paul,

Mod was working like a charm and then we changed accounts (stayed with the same host, just moved to a different server) and ever since, I'm not getting any Backups made. It's not version or vbulletin version based either since I recent;y upgraded to 4.2.0 and the newest version of this Mod and nothing.

Could there be something on the host side (using VPS) preventing this from working?

Did the directories or permissions change? When you manually run the script does it complete successfully?

[rgf207]

i created the backups folder in the root of my vbulletin install and changed permissions to 777 but I still get this error

Backup Error : Could not write to destination file ( ../../backups/2012-09-27/Forum-2012-09-27-Vb_access.sql )