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

  #811  
Old 11 Feb 2013, 11:26
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
You cannot delete it, otherwise all your crons will crash.

Truncating it would reduce the records of course, but then you will probably find you timeout on some other table.
__________________
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
  #812  
Old 12 Feb 2013, 02:43
snowlion snowlion is offline
 
Join Date: Mar 2005
Originally Posted by Paul M View Post
You cannot delete it, otherwise all your crons will crash.

Truncating it would reduce the records of course, but then you will probably find you timeout on some other table.
OK, so what can I do now?
The backup process stopped at cronlog and can not complete
Reply With Quote
  #813  
Old 14 Feb 2013, 05:26
gsmlover4u's Avatar
gsmlover4u gsmlover4u is offline
 
Join Date: Jan 2007
installed on 2 forums
working fine on 1 my forum
and not completing backup on second forum always stoped
Reply With Quote
  #814  
Old 26 Feb 2013, 20:02
Leica.Robbiani Leica.Robbiani is offline
 
Join Date: Sep 2007
Hi there,

I dont wanna talk the work of Paul bad, but as a friend of mine told me about mysqldumper I checked out this tool. Since once installed this tool and checked it out I love it. I think there is no better way to make database backups and restore them if needed.

Sorry Paul, my post is not against you personally and your work, but I think everybody has to find out his best way to make and restore backups and tell it to the other users.

Best regards

L.R.
Reply With Quote
  #815  
Old 26 Feb 2013, 20:25
DAMINK DAMINK is offline
 
Join Date: Jun 2010
Originally Posted by Leica.Robbiani View Post
Hi there,

I dont wanna talk the work of Paul bad, but as a friend of mine told me about mysqldumper I checked out this tool. Since once installed this tool and checked it out I love it. I think there is no better way to make database backups and restore them if needed.


Best regards

L.R.
Agree 100000%
i have been using it for some time.
Backing up and sending the backup to my local NAS.
Could not ask for a better result.
Restored the backup many times and never had an issue.
__________________
FTW Forum <- Home of the damned!
Reply With Quote
  #816  
Old 01 Mar 2013, 04:47
smirkley smirkley is offline
 
Join Date: Apr 2008
I have used mysqldumper too,... and yes it is quite nice.

But this mod conveniently performs the backup service automatically , replaces older files by your discretion settings, and stores them in a non-public fashion ready for you to ftp off site at your convenience. All within the vb cron mechanism.

I prefer to use mysql to perform my restores directly.

It is a nice bundling of backup service when using vb. Perfect for my forum.
Reply With Quote
  #817  
Old 01 Mar 2013, 10:33
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Originally Posted by smirkley View Post
But this mod conveniently performs the backup service automatically , replaces older files by your discretion settings, and stores them in a non-public fashion ready for you to ftp off site at your convenience. All within the vb cron mechanism.
How does it do that? I go in manually once a week or so to delete old backups - how do you do that automatically?
Reply With Quote
  #818  
Old 01 Mar 2013, 20:36
CharlieDelta CharlieDelta is offline
 
Join Date: Apr 2010
Originally Posted by djbaxter View Post
How does it do that? I go in manually once a week or so to delete old backups - how do you do that automatically?
I do it as well.
Date Format in the settings. I have mine set at Y-m.
Reply With Quote
  #819  
Old 03 Mar 2013, 15:30
smirkley smirkley is offline
 
Join Date: Apr 2008
I have the date format set for simply 'd' for date of the month.

This way my server holds 31 backup files, and overwrites each day the same file.

I can backup anytime within a month from any date, or from older offsite saved files if needed.
Reply With Quote
  #820  
Old 03 Mar 2013, 15:47
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Originally Posted by smirkley View Post
I have the date format set for simply 'd' for date of the month.

This way my server holds 31 backup files, and overwrites each day the same file.
That's actually pretty clever if you have plenty of diskspace.

What would be better is a cron job to delete backups older than X days.
Reply With Quote
  #821  
Old 03 Mar 2013, 22:52
Leica.Robbiani Leica.Robbiani is offline
 
Join Date: Sep 2007
Hi there,

for a long time I used this mod, but I found out I have a war with the mysql console. I had a solution for this, but the problem was the wrong one. So I was searching for another solution.

But this mod conveniently performs the backup service automatically , replaces older files by your discretion settings, and stores them in a non-public fashion ready for you to ftp off site at your convenience. All within the vb cron mechanism.
mysqldumper does his work also automatically, but not within the vB cron. I think this is not a problem. You can use an external cronjob service (there are many sites of them for free in the net) or you can write your own file.

I have configured my server in the way where mysqldumper is not reachable from the document root of any website, and it stores the backups in a private directoy.

You can configure the dumper, how many backup's it stores.

At least everyone has to decide for himself what he wants to use. The dumper is an easier way for me.

Best regards

L.R.
Reply With Quote
  #822  
Old 04 Mar 2013, 03:41
smirkley smirkley is offline
 
Join Date: Apr 2008
Originally Posted by djbaxter View Post
That's actually pretty clever if you have plenty of diskspace.

What would be better is a cron job to delete backups older than X days.
I suppose if you are running a very popular forum and a large database, you would already have the headroom in your account. My database isnt huge but isnt small. And I still have plenty of headroom left on my drives. I run on a basic vps and my backups delete and rewrite each date of the month. I suppose you could just set your date format for day of the week and that way you would be limiting your backup files to 7 total before overwrite. You would just hafta download ftp your weekly backups once a week.
Reply With Quote
  #823  
Old 04 Mar 2013, 03:47
smirkley smirkley is offline
 
Join Date: Apr 2008
Originally Posted by Leica.Robbiani View Post
for a long time I used this mod, but I found out I have a war with the mysql console. I had a solution for this, but the problem was the wrong one. So I was searching for another solution.

...

At least everyone has to decide for himself what he wants to use. The dumper is an easier way for me.
And for that you are correct.

This mod works exceptionally well for me, maybe because I am on a vps I have complete control in my mysql and server in general. I dunno. But not a solution for everyone I suppose. I am glad that works for you.
Reply With Quote
  #824  
Old 12 Mar 2013, 00:03
Deuces73 Deuces73 is offline
 
Join Date: Jul 2011
I always get :

Backup Error : Could not write to destination file ( ../../backups/2013-03-12/Forum-2013-03-12-Access.sql )

What's wrong here ?
Reply With Quote
  #825  
Old 12 Mar 2013, 00:23
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Originally Posted by smirkley View Post
you could just set your date format for day of the week and that way you would be limiting your backup files to 7 total before overwrite.
Excellent suggestion. This works very well.
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 15:38.

Layout Options | Width: Wide Color: