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: Aug 2014 I like it Show Printable Version Email this Page

vB Version: 4.2.x Rating: (154 votes - 4.89 average) Installs: 1381
Released: 28 Dec 2009 Last Update: 26 Nov 2013 Downloads: 6599
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.
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.

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

  #106  
Old 11 Feb 2010, 06:29
XxSparks XxSparks is offline
 
Join Date: Sep 2008
Kay, so I figured it out, and installed it, and it's working, I run the Cron Job manually to test if it works, and it does, at the end I get this:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

After it's completely figured, then I go to my FTP, and the folder I set, and boom, blank, nothing there. What's the problem?
Reply With Quote
  #107  
Old 11 Feb 2010, 12:11
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul Marsden
You are looking in the wrong place - if its completed than its written the data to the path you specified.
__________________


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.
Cable Forum - DigiGuide
Reply With Quote
  #108  
Old 14 Feb 2010, 17:39
dcuellar dcuellar is offline
 
Join Date: Nov 2007
I've installed this successfully but I want to make sure that what I did was correct.

There was one file saved as "Forum-February-14-Full-Backup.sql". Is that all I need? Is the date method I used sufficient? I basically only want to save one year's worth of files before it starts to overwrite them.

What are the advantages and disadvantages of selecting the first option? (To save as one file)
Is it safe to install to "../../backups"?

Last edited by dcuellar : 14 Feb 2010 at 17:46.
Reply With Quote
  #109  
Old 14 Feb 2010, 23:01
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul Marsden
As far as the database is concerned, yes, thats all you need.

As to one file or multiple files, it depends - its easier to restore one table if you have seperate files. If you need to restore the whole database, one file is easier (but in DOS its also easy to join all the single files into one big file anyway).

I dont quite understand your last question.
__________________


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.
Cable Forum - DigiGuide
Reply With Quote
  #110  
Old 14 Feb 2010, 23:06
kf4eok's Avatar
kf4eok kf4eok is offline
 
Join Date: Sep 2009
Real name: Daniel
how do you restore a backup?
all I have ever used is mysqldumper.
thanks
Reply With Quote
  #111  
Old 15 Feb 2010, 00:30
XxSparks XxSparks is offline
 
Join Date: Sep 2008
I have this installed, but it seems like Cron Job isn't being run daily, could this have something to do with the forum being offline perhaps? Or should it run daily regardless?
Reply With Quote
  #112  
Old 15 Feb 2010, 09:21
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul Marsden
The vbulletin cron system relies on people visiting the 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.
Cable Forum - DigiGuide
Reply With Quote
  #113  
Old 15 Feb 2010, 15:08
XxSparks XxSparks is offline
 
Join Date: Sep 2008
ah, okay, thanks so much Paul!
Reply With Quote
  #114  
Old 16 Feb 2010, 06:44
mrdexx mrdexx is offline
 
Join Date: Feb 2010
Sorry if this is a newb question, but this program generates a .sql file, and then I take this file and import it within cpanel to restore the database through importing in phpwizard? (in the event of things going sideways etc.)

Basically just wondering if important/restoring the database using this mod is different than the backups done through exporting from phpmyadmin?

Thanks!

Last edited by mrdexx : 17 Feb 2010 at 05:15. Reason: edit of phpmyadmin from phpwizard
Reply With Quote
  #115  
Old 16 Feb 2010, 09:32
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul Marsden
I have no idea what phpwizard is.
__________________


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.
Cable Forum - DigiGuide
Reply With Quote
  #116  
Old 17 Feb 2010, 05:16
mrdexx mrdexx is offline
 
Join Date: Feb 2010
Sorry I was exhausted when I wrote that, I meant to say does it generate the same files as if I had exported my database through phpmyadmin?
Reply With Quote
  #117  
Old 17 Feb 2010, 10:34
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul Marsden
All text based mysql exports are similar, whatever software creates them.
__________________


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.
Cable Forum - DigiGuide
Reply With Quote
  #118  
Old 23 Feb 2010, 02:02
Ark del KAOS's Avatar
Ark del KAOS Ark del KAOS is offline
 
Join Date: Sep 2002
Hi Paul!
I had a problem yesterday when I put back a sq backup made with this mod, and maybe you cant give me some advice about it.

I use a utf8 Spanish forum, because there's some symbols like the or accents who cant be showed properly without utf8.
The forum work perfect with the language option of charset tuned to utf8, etc
But yesterday I migrate the forum from a cluster server to a dedicated one, and when I put the system back the database shows all the special characters wrong.

I put it back uploading the backup with ftp, and the running this:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Well, It's the standard one Nothing out of ordinary.

When I open the mysql with phpmyadmin, and examine the data itself, (ej: post) in the pagetext column I can read the info contained, but It's wrong with the same mistaken charset symbols.

The MySQL charset its UTF-8 Unicode (utf8)
And the collation its utf8_general_ci
But then there some of the tables collated in latin1_swedish_ci

I don't know anything more to play with, trying to recover it.
Could you give me some advice?
Reply With Quote
  #119  
Old 23 Feb 2010, 02:32
Ark del KAOS's Avatar
Ark del KAOS Ark del KAOS is offline
 
Join Date: Sep 2002
.....You know when you get out of ideas, and make a post....and then, coming from anywhere, the one only thing you don't think off shows up, and save the day?
Its always the same XD

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

That did the trick, and save me from this mess XD
(I swear I try it, but It seems I misspelled the option some where in the process... )

Well, anyway, thanks for all your hard work with so many good mods! ^ ^

Last edited by Ark del KAOS : 23 Feb 2010 at 02:49.
Reply With Quote
  #120  
Old 23 Feb 2010, 12:38
s0lidgr0und's Avatar
s0lidgr0und s0lidgr0und is offline
 
Join Date: Dec 2006
Real name: Bill
Trying now.

*crosses fingers*

Edit: Failure. Looks like HostGator is the issue.
__________________
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
Forum Jump


New To Site? Need Help?

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

Layout Options | Width: Wide Color: