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

  #1021  
Old 24 Jan 2015, 17:56
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by ebp123 View Post
So once i set up the backup folder, it automatically puts back ups of my database in it?
Thats the idea, yes.
__________________
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
  #1022  
Old 29 Jan 2015, 09:44
hanm15 hanm15 is offline
 
Join Date: May 2013
Working with 4.2.2?
Reply With Quote
  #1023  
Old 30 Jan 2015, 08:53
Fields Fields is offline
 
Join Date: Jun 2014
Real name: Moritz
Originally Posted by hanm15 View Post
Working with 4.2.2?
Yes
Reply With Quote
  #1024  
Old 30 Jan 2015, 09:35
Marv Marv is offline
 
Join Date: Jun 2002
Originally Posted by Paul M View Post
Thats the idea, yes.
Paul,

I guess you know MySQLDumper. Any chance you could implement something similiar to MSQLDs FTP-transfer into this mod? Ild always like to have my backups on a secure location, like a dedicated ftp-server or repository, since our harddrive crashed last year and with it - of course - all of our backups were gone, too. What do you think? Makes sense?
Reply With Quote
  #1025  
Old 05 Feb 2015, 19:21
spd2612 spd2612 is offline
 
Join Date: Nov 2012
I installed this quite a while back on 4.2.0 and works very well, so well I keep forgetting about it and I keep filling up my HDD is there a way to limit the number of backups or is it just up to me to remember to clean up my backup folder?
Reply With Quote
  #1026  
Old 05 Feb 2015, 19:49
Marv Marv is offline
 
Join Date: Jun 2002
Store your sitemaps in a separate partition of your hdd. So, if you forget to delete them, your site will still work. Elseif the hdd where your forum is on is full, your server will have major headaches - and so will you
Reply With Quote
  #1027  
Old 06 Feb 2015, 02:26
MistViper MistViper is offline
 
Join Date: Jan 2015
Downloaded and marked as installed! I have a couple basic questions though. How do I find the back up after it is done? Also should I select yes for combining all tables into one backup file?
Reply With Quote
  #1028  
Old 08 Feb 2015, 17:07
CvP's Avatar
CvP CvP is offline
 
Join Date: Aug 2006
Originally Posted by Marv View Post
Paul,

I guess you know MySQLDumper. Any chance you could implement something similiar to MSQLDs FTP-transfer into this mod? Ild always like to have my backups on a secure location, like a dedicated ftp-server or repository, since our harddrive crashed last year and with it - of course - all of our backups were gone, too. What do you think? Makes sense?
I actually have added this functionality to this add-on years ago. I will see if I can release it here. In the mean time, you can check the add-on I published just now which works in conjunction with Paul's add-on.
Reply With Quote
  #1029  
Old 26 Jan 2016, 17:43
patracy patracy is offline
 
Join Date: Feb 2006
Originally Posted by bzcomputers View Post
[SIZE=2]

1) Do I have to turn off my site to run this backup? No.

2) While running backup, does it affect the site performance (slow)? Depending on how large your database is will depend on how much time/server resources your backup will take. It's a cron job so just schedule it to run at the slowest time of the day for your site. A backup is a lot more important than worrying about slowing your site for few seconds or minutes at an off-peak time.

How would one setup the site to turn off during this backup process? Have a rather large db here (1gb zipped). Would rather have the site off, let the backup run, then turn the site back on.
Reply With Quote
  #1030  
Old 26 Jan 2016, 17:53
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Originally Posted by patracy View Post
How would one setup the site to turn off during this backup process? Have a rather large db here (1gb zipped). Would rather have the site off, let the backup run, then turn the site back on.
To be honest if your database is reaching a point where it's getting quite big, you should not rely on such plugin anymore but create your own OS based cronjob. In Linux you can make use of crontabs and create a basic bash script that executes the mysqlbackup command.
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #1031  
Old 27 Jan 2016, 17:34
patracy patracy is offline
 
Join Date: Feb 2006
Originally Posted by Dave View Post
To be honest if your database is reaching a point where it's getting quite big, you should not rely on such plugin anymore but create your own OS based cronjob. In Linux you can make use of crontabs and create a basic bash script that executes the mysqlbackup command.
That's true. And actually that's the direction I've been meaning to go in. But I've not been able to find a method on scheduling vB on/off. I suppose I could cron apache on and off, but that'd leave users in the dark.
Reply With Quote
  #1032  
Old 27 Jan 2016, 19:16
shimei shimei is offline
 
Join Date: Feb 2015
Originally Posted by patracy View Post
That's true. And actually that's the direction I've been meaning to go in. But I've not been able to find a method on scheduling vB on/off. I suppose I could cron apache on and off, but that'd leave users in the dark.
I began a thread here on the subject: Maintenance Page for Cron Backup
Reply With Quote
  #1033  
Old 17 Mar 2016, 16:44
Davidinh Davidinh is offline
 
Join Date: Apr 2005
seem something were missing in the Auto-backup.txt and base on my problem I would like to share to all

Installation
------------

1. Copy all files in the 'includes' folder to the server.

2. Upload the product XML via the Product Manager.

3. Set your choice of options in the ACP (vBulletin Options).

4. Alter the timing of the cron job to suit.

5. To use the (experimental) MySQL backup option, you need to edit the mysqlbackup.php file.

Find var $DTYPE = 'php'; and change it to var $DTYPE = 'mysql'

In a case for new version of mysql you should add var $MYSQLI; (after var $MYSQL) in mysqlbackup.php then change var $DTYPE = 'mysqli' ;

6. Create the new folder as "backups" or what ever you desire for it then set permission as 777

if it is in the root website in AdminCP option should set ./backups/
if it is in the forum directory in AdminCP option should set ../backups/

and so on.

hope it helps

THANK YOU PAUL it is useful mode
Reply With Quote
  #1034  
Old 17 Mar 2016, 23:18
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Davidinh View Post
In a case for new version of mysql you should add var $MYSQLI; (after var $MYSQL) in mysqlbackup.php then change var $DTYPE = 'mysqli' ;
This isnt necessary, and wont do anything.
In fact, if you set $DTYPE = 'mysqli' you will end up using the php backup process.
You seem to be confusing variable names with actual database systems, the fact you are now using MySQLi doesnt affect the variable names.

For the backup path, you should never use a website location (i.e. one thats accessible via a url) such as the two examples you gave, otherwise anyone can potentially just download your backup files.
__________________
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
  #1035  
Old 18 Mar 2016, 05:07
twlMavRic twlMavRic is offline
 
Join Date: Nov 2015
Installed and ran backup in just over 11 secs. Works as advertised
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 11:48.

Layout Options | Width: Wide Color: