Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vBulletin Cron Based Database Backup Details »
vBulletin Cron Based Database Backup
Mod Version: 4.2.0.2, by Paul M (Member) Paul M is offline
Developer Last Online: Jan 2018 I like it Show Printable Version Email this Page

This thread is in the Modification Graveyard.
vB Version: 4.2.x Rating: (160 votes - 4.89 average) Installs: 1436
Released: 28 Dec 2009 Last Update: 26 Nov 2013 Downloads: 7175
Not Supported Uses Plugins Additional Files Translations  

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.

Download Now

Only licensed members can download files, Click Here for more information.

Addons

Show Your Support

  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Vbulletin Database Backup Pro (Cron Support) Trigunflame vBulletin 3.0 Full Releases 443 05 Sep 2008 16:12

  #586  
Old 31 Jan 2012, 06:25
dune3000 dune3000 is offline
 
Join Date: Apr 2007
How I can change : how often auto backup can be created
Reply With Quote
  #587  
Old 31 Jan 2012, 19:42
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Change the cron job settings - however, they are somewhat limited unless you want to run every hour or more.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #588  
Old 05 Feb 2012, 20:06
wheretobet wheretobet is offline
 
Join Date: Dec 2008
Can you tell me the effect, if any of trying to install this on a hacked 4.1.6?

Please advise.

TY
Reply With Quote
  #589  
Old 05 Feb 2012, 22:30
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Install it and see. I cannot advise on specific set-ups.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #590  
Old 09 Feb 2012, 04:40
ALBCODERS ALBCODERS is offline
 
Join Date: Apr 2009
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.
Reply With Quote
  #591  
Old 09 Feb 2012, 05:21
HMBeaty's Avatar
HMBeaty HMBeaty is offline
 
Join Date: Sep 2005
Real name: Brooks
Originally Posted by ALBCODERS View Post
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
__________________
"Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time!"
"It's important to only think about what you desire, not what you fear to achieve your ultimate goal!!
Reply With Quote
  #592  
Old 09 Feb 2012, 05:34
DAMINK DAMINK is offline
 
Join Date: Jun 2010
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!
__________________
FTW Forum <- Home of the damned!
Reply With Quote
  #593  
Old 09 Feb 2012, 05:45
ALBCODERS ALBCODERS is offline
 
Join Date: Apr 2009
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.
Reply With Quote
  #594  
Old 09 Feb 2012, 05:57
DAMINK DAMINK is offline
 
Join Date: Jun 2010
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.
__________________
FTW Forum <- Home of the damned!
Reply With Quote
  #595  
Old 09 Feb 2012, 06:00
UnknownKillerMC UnknownKillerMC is offline
 
Join Date: Jan 2012
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.
Reply With Quote
  #596  
Old 09 Feb 2012, 06:07
ALBCODERS ALBCODERS is offline
 
Join Date: Apr 2009
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.
Reply With Quote
  #597  
Old 09 Feb 2012, 06:19
DAMINK DAMINK is offline
 
Join Date: Jun 2010
Originally Posted by UnknownKillerMC View Post
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 View Post
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.
__________________
FTW Forum <- Home of the damned!
Reply With Quote
  #598  
Old 09 Feb 2012, 10:08
RustyF RustyF is offline
 
Join Date: Feb 2012
Real name: Rusty Ferguson
Question

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
Reply With Quote
  #599  
Old 09 Feb 2012, 14:07
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by RustyF View Post
Do I copy the files in the includes folder to the vBulletin includes folder?
Yes.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #600  
Old 10 Feb 2012, 22:50
DAMINK DAMINK is offline
 
Join Date: Jun 2010
Originally Posted by RustyF View Post
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)
__________________
FTW Forum <- Home of the damned!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 02:30.

Layout Options | Width: Wide Color: