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 (Dr Pepper Addict) Paul M is offline
Developer Last Online: Jun 2016 I like it Show Printable Version Email this Page

vB Version: 4.2.x Rating: (160 votes - 4.89 average) Installs: 1436
Released: 28 Dec 2009 Last Update: 26 Nov 2013 Downloads: 7033
Not Supported Uses Plugins Additional Files Translations  

For vBulletin 4.1.0 Onwards

Versions Attached

4107: vBulletin 4.1.0 to 4.1.12
4200: vBulletin 4.2.0 (+)

This modification is not available for vBulletin 4.0.x

Please remember to click Mark as Installed if you use this modification.

This modification is no longer officially supported.
It will remain available for download and use, but the thread is no longer monitored.


Please fee free to nominate this modification for the MOTM, and/or use the donate link provided (Support Developer).

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


Notes:



To install, download and unzip the files, and follow the instructions in the text file.


Support

Support will not be provided for vBulletin 4 Alpha, Beta or RC versions.
Low priority will be given to posters who do not have this marked as installed
In some cases, support can only be provided if I have an admin login and ftp access.


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 experimental mysqldump backup.

Download Now

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

Addons

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • 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

Comments
  #2  
Old 28 Dec 2009, 20:01
utahraves's Avatar
utahraves utahraves is offline
 
Join Date: May 2007
Real name: Cody Cook
Woot woot. Why did they take it out in the first place? duh... i used it all the time.
Reply With Quote
  #3  
Old 28 Dec 2009, 20:09
Floris Floris is offline
 
Join Date: Jan 2002
I care for my site, so I do not trust apache/php/mysql limits from the browser. And use a shell to back it up. This way apache can be down, but I can still make a database. And after 15mb for example on most hosts I still get a complete sql dump.

But strange that they removed it. I guess they didn't add any value to backing up database or something. Good to see a vBulletin.org administrator show he cares about sites too and adding this as a plugin to version 4.
__________________
My community; http://wetalknation.net
Reply With Quote
  #4  
Old 28 Dec 2009, 20:28
dodgeboard.com's Avatar
dodgeboard.com dodgeboard.com is offline
 
Join Date: Nov 2005
Thanks Paul, for your work on this.

Q: How does this deal with PHP script timeouts? Will it work with a 200 mb database for example?

I know that MSD will use refreshes and resume routines to get around script timeouts for large databases...will this do the same?

TIA
Reply With Quote
  #5  
Old 28 Dec 2009, 20:34
Alecsmith's Avatar
Alecsmith Alecsmith is offline
 
Join Date: Sep 2009
Real name: Nick
Installed very good wwork paul
__________________

Reply With Quote
  #6  
Old 28 Dec 2009, 20:49
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul Marsden
Originally Posted by dodgeboard.com View Post
Q: How does this deal with PHP script timeouts? Will it work with a 200 mb database for example?
It sets the timeout to 1 hour (unless your php setup disallows this).

My database it well over 1GB, and i use this daily (it takes < 5 minutes to run the backup).
__________________

Cable Forum
Lead Developer, vBulletin.Org & vBulletin.Com
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
  #7  
Old 28 Dec 2009, 20:54
Adem GENĒ's Avatar
Adem GENĒ Adem GENĒ is offline
 
Join Date: Apr 2005
Real name: Adem GENĒ
Thank you very much
Installed
Reply With Quote
  #8  
Old 28 Dec 2009, 21:10
BlackJacket's Avatar
BlackJacket BlackJacket is offline
 
Join Date: Nov 2008
Real name: V
This was the last mod i have been waiting for. Thank you very much Paul. Your work is much appreciated.
Reply With Quote
  #9  
Old 28 Dec 2009, 21:18
dodgeboard.com's Avatar
dodgeboard.com dodgeboard.com is offline
 
Join Date: Nov 2005
Originally Posted by Paul M View Post
It sets the timeout to 1 hour (unless your php setup disallows this).

My database it well over 1GB, and i use this daily (it takes < 5 minutes to run the backup).

AWESOME! Great Work Paul. Always love your mods! <clicks install>
Reply With Quote
  #10  
Old 28 Dec 2009, 21:30
Adem GENĒ's Avatar
Adem GENĒ Adem GENĒ is offline
 
Join Date: Apr 2005
Real name: Adem GENĒ
My bad English

Installed forum
AND
I wanted to make a backup manually
Can not write file error has
AND
Forum no files within the directory was deleted or I do not see all did not stay

Error occurred: 403 - no permission
Reply With Quote
  #11  
Old 29 Dec 2009, 04:56
dodgeboard.com's Avatar
dodgeboard.com dodgeboard.com is offline
 
Join Date: Nov 2005
Things looked like they were going fine until....

Processing poll (72) : Processed 72 Rows in 0.006 seconds
Processing pollvote (2284) : Processed 2284 Rows in 0.176 seconds
Processing post (127205) : Processed 127205 Rows in 18.943 seconds
Processing postedithistory (2571) : Processed 2571 Rows in 0.629 seconds
Processing posthash (7) : Processed 7 Rows in 0.015 seconds
Processing postindex (2778108)

No errors...just froze.

After about an hour on postindex, I gave up. Apparantly, this doesn't work so well on Hostgator shared hosting.

It was worth a try. Thanks anyway Paul. I use many other mods you've created.

UNinstalling.
Reply With Quote
  #12  
Old 29 Dec 2009, 05:34
JHUMON JHUMON is offline
 
Join Date: Aug 2008
Thanks a lot.
__________________
www.hostsaller.com Hosting Service
www.forum4phone.com Gsm Community
Reply With Quote
  #13  
Old 29 Dec 2009, 06:27
Bouncer222 Bouncer222 is offline
 
Join Date: Oct 2009
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?
Reply With Quote
  #14  
Old 29 Dec 2009, 07:45
M3xital's Avatar
M3xital M3xital is offline
 
Join Date: Jan 2009
Thanks! Works great.
__________________
www.m3xital.com
Reply With Quote
  #15  
Old 29 Dec 2009, 10:10
KEKforce KEKforce is offline
 
Join Date: Feb 2007
Originally Posted by dodgeboard.com View Post
Things looked like they were going fine until....

Processing poll (72) : Processed 72 Rows in 0.006 seconds
Processing pollvote (2284) : Processed 2284 Rows in 0.176 seconds
Processing post (127205) : Processed 127205 Rows in 18.943 seconds
Processing postedithistory (2571) : Processed 2571 Rows in 0.629 seconds
Processing posthash (7) : Processed 7 Rows in 0.015 seconds
Processing postindex (2778108)

No errors...just froze.

After about an hour on postindex, I gave up. Apparantly, this doesn't work so well on Hostgator shared hosting.

It was worth a try. Thanks anyway Paul. I use many other mods you've created.

UNinstalling.
Got the same problem.....
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
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 10:27.

Layout Options | Width: Wide Color: