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: 1437
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 15:12

  #16  
Old 29 Dec 2009, 10:59
kisanjong kisanjong is offline
 
Join Date: Feb 2009
Excellent - Thanks installed

Processed Database in 18.805 seconds

Backup Completed Successfully

Done

Last edited by kisanjong; 29 Dec 2009 at 16:21.
Reply With Quote
  #17  
Old 29 Dec 2009, 11:02
phonexpo's Avatar
phonexpo phonexpo is offline
 
Join Date: Sep 2005
Location: Dublin
Real name: Patrick
Processed Database in 20.765 seconds

Backup Completed Successfully
Done
Working well for me

Thanks Paul,

-Patrick
Reply With Quote
  #18  
Old 29 Dec 2009, 12:29
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by dodgeboard.com View Post
No errors...just froze.

After about an hour on postindex, I gave up. Apparantly, this doesn't work so well on Hostgator shared hosting.
Hostgator probably timeout the script (The mod trys to set it to one hour, but some hosts disallow their timeout from being changed).

Given that it took 18.9 seconds to process about 127000 rows, then 2778108 is going to take about 20 times longer (over 6 minutes).

The only way I can think of getting round this is to process larger record counts in batches. It would have to be optional as it would probably slow down the backup, and not everyone would need it, but may help your issue. I will provide a beta version for people to test later.
__________________
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
  #19  
Old 29 Dec 2009, 14:18
Edrondol Edrondol is offline
 
Join Date: Aug 2009
Worked perfectly. Great work! I know my host does daily backups, but this prevents me from having to wait until they look at a trouble ticket, etc.
Reply With Quote
  #20  
Old 29 Dec 2009, 16:03
kisanjong kisanjong is offline
 
Join Date: Feb 2009
Originally Posted by Bouncer222 View Post
So how do you set the time interval for it to create a backup? And does it create only mysql or public_html (my forums directory) backups or both of them in the backups folder?

I would like to make it per week. How I do that?

goto Scheduled Tasks/Scheduled Task Manager in admincp and edit Automatic Database Backup for vBulletin settings.
Reply With Quote
  #21  
Old 29 Dec 2009, 16:44
Anseur's Avatar
Anseur Anseur is offline
 
Join Date: Jun 2004
Just FYI Hostgators script kills anything longer than 30 seconds. (at least, that's what they told me in a support ticket about an unrelated matter)

might look at this if Paul's next version works ok for me with splitting it up.
Reply With Quote
  #22  
Old 29 Dec 2009, 16:47
Delilahs Delilahs is offline
 
Join Date: Mar 2009
cheers Paul.

Installed and working fine.
Reply With Quote
  #23  
Old 29 Dec 2009, 20:46
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Anseur View Post
Just FYI Hostgators script kills anything longer than 30 seconds. (at least, that's what they told me in a support ticket about an unrelated matter)

might look at this if Paul's next version works ok for me with splitting it up.
Try 4.0.2 (check the options).

This is all I can do, if this fails then tbh, all I can suggest is move to a decent host
__________________
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
  #24  
Old 29 Dec 2009, 21:03
utahraves's Avatar
utahraves utahraves is offline
 
Join Date: May 2007
Real name: Cody Cook
I installed this and it slowed my server down more than anything I've ever used before; I actually ended up with database errors after using and had to take my server down for six hours to resolve. I didn't even get any of the "processing" status messages like others did... just completely frozen. I'll just stick with backing it up on the SQL side for now. Love your products though, Paul *uninstalled*
Reply With Quote
  #25  
Old 29 Dec 2009, 21:12
Front Range 4x4 Front Range 4x4 is offline
 
Join Date: Jan 2009
Real name: Chris
*installed* Thanks Paul!
Reply With Quote
  #26  
Old 29 Dec 2009, 22:55
Adem GENĒ's Avatar
Adem GENĒ Adem GENĒ is offline
 
Join Date: Apr 2005
Real name: Adem GENĒ
Hi,
My bad English

Create a backup directory for each mysql
As 3.8.x
3.8.4
384_yedek.PNG

4.0.0
400_yedek.PNG


Combine Files: No, No is selected, the necessary

Regards

Last edited by Adem GENĒ; 29 Dec 2009 at 23:04.
Reply With Quote
  #27  
Old 29 Dec 2009, 23:18
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by utahraves View Post
I installed this and it slowed my server down more than anything I've ever used before; I actually ended up with database errors after using and had to take my server down for six hours to resolve. I didn't even get any of the "processing" status messages like others did... just completely frozen. I'll just stick with backing it up on the SQL side for now. Love your products though, Paul *uninstalled*
This only runs once a day, at 6am. I dont see how simply installing it could possibly have the effect you describe.
__________________
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
  #28  
Old 29 Dec 2009, 23:23
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by AdemGENĒ View Post
Hi,
My bad English

Create a backup directory for each mysql
As 3.8.x
3.8.4
Attachment 108553

4.0.0
Attachment 108554


Combine Files: No, No is selected, the necessary

Regards
If "No" is selected for the Combine option then it will create the folder (and individual files), that has not changed.
__________________
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
  #29  
Old 29 Dec 2009, 23:40
Adem GENĒ's Avatar
Adem GENĒ Adem GENĒ is offline
 
Join Date: Apr 2005
Real name: Adem GENĒ
Originally Posted by Paul M View Post
If "No" is selected for the Combine option then it will create the folder (and individual files), that has not changed.
Yes, Thank you very much
Reply With Quote
  #30  
Old 30 Dec 2009, 07:24
Gleedo Gleedo is offline
 
Join Date: Oct 2008
Thanks Paul

Clicks Installed
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 14:59.

Layout Options | Width: Wide Color: