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]

Originally Posted by ebp123

So once i set up the backup folder, it automatically puts back ups of my database in it?

Thats the idea, yes.

[hanm15]

Working with 4.2.2?

[Fields]

Originally Posted by hanm15

Working with 4.2.2?

Yes

[Marv]

Originally Posted by Paul M

Thats the idea, yes.

Paul,

I guess you know MySQLDumper. Any chance you could implement something similiar to MSQLD?s FTP-transfer into this mod? I?ld always like to have my backups on a secure location, like a dedicated ftp-server or repository, since our harddrive crashed last year and with it - of course - all of our backups were gone, too. What do you think? Makes sense?

[spd2612]

I installed this quite a while back on 4.2.0 and works very well, so well I keep forgetting about it and I keep filling up my HDD is there a way to limit the number of backups or is it just up to me to remember to clean up my backup folder?

[Marv]

Store your sitemaps in a separate partition of your hdd. So, if you forget to delete them, your site will still work. Elseif the hdd where your forum is on is full, your server will have major headaches - and so will you

[MistViper]

Downloaded and marked as installed! I have a couple basic questions though. How do I find the back up after it is done? Also should I select yes for combining all tables into one backup file?

[CvP]

Originally Posted by Marv

Paul,

I guess you know MySQLDumper. Any chance you could implement something similiar to MSQLD?s FTP-transfer into this mod? I?ld always like to have my backups on a secure location, like a dedicated ftp-server or repository, since our harddrive crashed last year and with it - of course - all of our backups were gone, too. What do you think? Makes sense?

I actually have added this functionality to this add-on years ago. I will see if I can release it here. In the mean time, you can check the add-on I published just now which works in conjunction with Paul's add-on.

[patracy]

Originally Posted by bzcomputers

[SIZE=2]

1) Do I have to turn off my site to run this backup? No.

2) While running backup, does it affect the site performance (slow)? Depending on how large your database is will depend on how much time/server resources your backup will take. It's a cron job so just schedule it to run at the slowest time of the day for your site. A backup is a lot more important than worrying about slowing your site for few seconds or minutes at an off-peak time.

How would one setup the site to turn off during this backup process? Have a rather large db here (1gb zipped). Would rather have the site off, let the backup run, then turn the site back on.

[Dave]

Originally Posted by patracy

How would one setup the site to turn off during this backup process? Have a rather large db here (1gb zipped). Would rather have the site off, let the backup run, then turn the site back on.

To be honest if your database is reaching a point where it's getting quite big, you should not rely on such plugin anymore but create your own OS based cronjob. In Linux you can make use of crontabs and create a basic bash script that executes the mysqlbackup command.