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: 1435
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

  #901  
Old 21 Aug 2013, 17:02
rinkrat's Avatar
rinkrat rinkrat is offline
 
Join Date: Jan 2002
Originally Posted by WorldCraft View Post
When I try to restore one of these backups via SSH, I get the following error

ERROR 1265 (01000) at line 100114: Data truncated for column 'method' at row 1

An other backup I tried I got the same error but at column 'datastore'

Running vBulletin 4.2.0 with innoDB setting enabled as I do have a few tables in this format.

Any ideas??


Try doing a repair on the mysql tables before backup, that worked for me.
__________________
Los Angeles Kings Fan Page
Reply With Quote
  #902  
Old 21 Aug 2013, 17:03
scottct1 scottct1 is offline
 
Join Date: Mar 2002
I tried to fragment the backup and still stalled out when it hit the posts table.

Oh well.
Reply With Quote
  #903  
Old 21 Aug 2013, 19:57
smirkley smirkley is offline
 
Join Date: Apr 2008
Originally Posted by scottct1 View Post
I tried to fragment the backup and still stalled out when it hit the posts table.

Oh well.
Can you increase your php's execution time ?
Reply With Quote
  #904  
Old 07 Sep 2013, 13:12
Bob_R Bob_R is offline
 
Join Date: Jun 2009
How come/Why are the queued files are a different count every day. I understand if you had a mod the count changes. But, I haven't added anything lately and the numbers seem to be different most of the time after being a constant number for the longest time.

Thanks.
Reply With Quote
  #905  
Old 07 Sep 2013, 16:20
friendlymela's Avatar
friendlymela friendlymela is offline
 
Join Date: Dec 2012
Real name: Zeeshan Shams
This Mod will work on VB 4.2.1?
Reply With Quote
  #906  
Old 07 Sep 2013, 18:35
DemOnstar's Avatar
DemOnstar DemOnstar is offline
 
Join Date: Dec 2012
Originally Posted by friendlymela View Post
This Mod will work on VB 4.2.1?
Works for me.
Reply With Quote
  #907  
Old 08 Sep 2013, 08:18
charlesr charlesr is online now
 
Join Date: Aug 2009
Originally Posted by Bob_R View Post
How come/Why are the queued files are a different count every day. I understand if you had a mod the count changes. But, I haven't added anything lately and the numbers seem to be different most of the time after being a constant number for the longest time.

Thanks.
Cache files?
Reply With Quote
  #908  
Old 08 Sep 2013, 10:19
friendlymela's Avatar
friendlymela friendlymela is offline
 
Join Date: Dec 2012
Real name: Zeeshan Shams
Originally Posted by DemOnstar View Post
Works for me.
which Vb version u r using?
Reply With Quote
  #909  
Old 11 Sep 2013, 10:17
mad4social mad4social is offline
 
Join Date: Dec 2012
When i insert the directory of backup, should i insert /var/www/namesite/backups and so on, or only /backups?
Reply With Quote
  #910  
Old 11 Sep 2013, 16:33
Bob_R Bob_R is offline
 
Join Date: Jun 2009
Originally Posted by Bob_R View Post
How come/Why are the queued files are a different count every day. I understand if you had a mod the count changes. But, I haven't added anything lately and the numbers seem to be different most of the time after being a constant number for the longest time.

Thanks.
Need answer. TY.
Reply With Quote
  #911  
Old 11 Sep 2013, 17:27
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Originally Posted by Bob_R View Post
How come/Why are the queued files are a different count every day. I understand if you had a mod the count changes. But, I haven't added anything lately and the numbers seem to be different most of the time after being a constant number for the longest time.

Thanks.
Originally Posted by charlesr View Post
Cache files?
Originally Posted by Bob_R View Post
Need answer. TY.
I think Charles answered you. There are database changes that change:

various log files
autosave
cache, externalcache
cpsession
datastore
indexqueue if you use it
mailqueue if you use it
plugin as you add and delete add-ons
session
Reply With Quote
  #912  
Old 17 Sep 2013, 15:50
sivaganeshk sivaganeshk is offline
 
Join Date: Oct 2010
possible to take this backup once in a week to AWS Glacier?
Reply With Quote
  #913  
Old 18 Sep 2013, 01:19
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
I dont know what that is.

This will only backup to a folder on your server. Technically that could be an NFS mapped drive or some other remote system, however, it must appear as a folder or simlink on the server.
__________________
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
  #914  
Old 18 Sep 2013, 04:22
DemOnstar's Avatar
DemOnstar DemOnstar is offline
 
Join Date: Dec 2012
Originally Posted by friendlymela View Post
which Vb version u r using?
4.2.1
Reply With Quote
  #915  
Old 11 Oct 2013, 19:28
chikuru chikuru is offline
 
Join Date: Nov 2011
After 4.2.2 upgrade:

I ran the scheduled task manually,


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

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 23:10.

Layout Options | Width: Wide Color: