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.

[anandbagmane]

do we get email notification for failed & successful backup?

[Paul M]

No.

[Valcav]

what should be the permission for the backup folder?
And can it be outside of the "public_html" folder?

EDIT:
(going to kind of answer myself a little bit...)
1) The backup folder can be placed outside the "public_html" folder
2) I currently have set the permission to 755 for the backup folder...
Just wondering if it can/should be lowered to be a little bit more secure...

[dune3000]

My direct path to folder is: /home/xxxxxxx/backups.
Backups folder permission set to 777
I run backup all successful :
Processed Database in 11.074 secondsBackup Completed Successfully Done

I find DB file : backupsForum-2012-01-22-Full-Backup.sql but not in backups folder

I look into backups folder and there is no files. What I am doing wrong?

[BrightStar]

could someone help me on how to run as cron job? I have installed the plugin but what should i do next?

Thanks

[dune3000]

How I can change : how often auto backup can be created

[Paul M]

Change the cron job settings - however, they are somewhat limited unless you want to run every hour or more.

[wheretobet]

Can you tell me the effect, if any of trying to install this on a hacked 4.1.6?

Please advise.

TY

[Paul M]

Install it and see. I cannot advise on specific set-ups.

[ALBCODERS]

i have wierd problem , after

Processing podcastitem (No Row Data)
Processing poll (25) : Processed 25 Rows in 0.007 Seconds
Processing pollvote (2230) : Processed 2230 Rows in 0.213 Seconds
Processing post (104156) : Processed 45339 Rows in 21.424 Seconds

i get this

Database error in vBulletin 4.1.9:

Invalid SQL:
SHOW CREATE TABLE `postedithistory`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, February 8th 2012 @ 10:32:35 PM
Error Date : Wednesday, February 8th 2012 @ 10:33:01 PM
Script : http://www.myweb.com/admincp/cronadm...cron&cronid=41
Referrer : http://www.myweb.com/admincp/cronadmin.php?do=modify
IP Address : *
Username : my
Classname : vB_Database
MySQL Version :


Any suggestion , never happen before . I use to run version autobackup 4.0.1 for sometime, and no problems. i got 2 weeks now with this problem and i have no idea where did com from .


i installet new version 4.1.7 i have same problem :/

can u please tell me what to do guys because hostgator is so crap when u try to back up files manualy , it never gives u full kb or mb in sql files. Autobackup make such a good job, and it gives u every bit of your website.


Regards.