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.

[HMBeaty]

Originally Posted by 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.

Hostgator is about 99% of your problem lol

Anyway, in regards to your database error, again, that's an issue with HostGator. See here for more information...

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

[DAMINK]

I can confirm its hostgators error.
I recently moved host just to get away from hostgator.
I was getting about 10 - 20 of those a day!

[ALBCODERS]

why i am not suprised :/

let say that i have to tell them te fix it , what do i actualy have to say cuz i have no idea

by theway thx for respondin back , HMbeaty and DAMIK i appreciate that.

[DAMINK]

I asked them to fix it myself ALBCODERS.
There answer was as below.

Originally Posted by hostgator

Hello

Thank you for contacting HostGator.

We can't set individual settings regarding MySQL in shared environments. I can say that the wait_timeout is currently set to 3600 on the particular server hosting your account. Another factor may be coding and application configuration. Is your application attempting to use persistent database connections in any way?

These are not permitted on shared servers because they tie up database connections. If an application attempts to use them it may generate the Mysql Server has gone away messages. This would actually be an internal coding or configuration issue with either the whole application or a module within the application.

I would simply move to a better host mate.
I have a reseller account with them and dont use it for myself at all lol.
I had to move. I could not keep getting these errors.
Good luck with hostgator mate. I hope they do come to your assistance.

[UnknownKillerMC]

I myself would suggest not adding this the reason being, if your site is ever compromised well just admincp it would easily give the attackers a way to get to your database my opinion but good work over all thanks for making this.

[ALBCODERS]

yeah i been planin for such a long time to move from hostgator but never found a good hosting company. Even worse with hostgator u can`t email your members for any updates or stuff, cuz they suspend your account for spamin.

[DAMINK]

Originally Posted by UnknownKillerMC

I myself would suggest not adding this the reason being, if your site is ever compromised well just admincp it would easily give the attackers a way to get to your database my opinion but good work over all thanks for making this.

I actually removed this mod for the same reason.
I now use a 3rd party software to do my backups. (bigdump)
I felt it would be easy for someone to point to the backup file directly just based on the fact most people dont edit anything and use the default install instructions.
It may well be safe PaulM is a great coder so i expect its safe but got me concerned regardless.

Originally Posted by ALBCODERS

yeah i been planin for such a long time to move from hostgator but never found a good hosting company. Even worse with hostgator u can`t email your members for any updates or stuff, cuz they suspend your account for spamin.

They used to ban my ip address all the time because i kept a computer on the who is online page 24/7.
I thing i asked to have my ip whitelisted about 6 times before they actually did it.
Literally had to keep telling them i have been ip banned. They would say every time thats not the case but when investigated further it was that every time.
Find a good host mate and move. You will be happy you done it.

[RustyF]

I hate to show my ignorance this way....

Do I copy the files in the includes folder to the vBulletin includes folder? Seems obvious but I'm brand new and afraid to put anything in the vbulleting file system unless I'm sure.

Thanks

[Paul M]

Originally Posted by RustyF

Do I copy the files in the includes folder to the vBulletin includes folder?

Yes.

[DAMINK]

Originally Posted by RustyF

I hate to show my ignorance this way....

Do I copy the files in the includes folder to the vBulletin includes folder? Seems obvious but I'm brand new and afraid to put anything in the vbulleting file system unless I'm sure.

Thanks

Thats not Ignorance. Thats good practice mate.
I imagine a lot of vb owners who first start out just dump craploads of mods on there forum and end up having all sorts of problems. (guilty as charged)