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: 1436
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 16:12

  #721  
Old 23 Sep 2012, 18:05
Superorb Superorb is offline
 
Join Date: Feb 2012
Originally Posted by Delfi_r View Post
Wich file I should modify?
The mysqlbackup.php file, but this code did not work for me when I added it to the test or live sites.
Reply With Quote
  #722  
Old 24 Sep 2012, 08:55
charlesr charlesr is offline
 
Join Date: Aug 2009
Originally Posted by betterthanyours View Post
Is there anything similar that will backup and then also upload to remote site at all?
If you have server access to two servers you could set up an rsync with ssh on a cronjob to sync the backups created by this mod to a remote server. Probably.
Reply With Quote
  #723  
Old 24 Sep 2012, 21:22
betterthanyours betterthanyours is offline
 
Join Date: May 2012
I do have shell access to both servers. Is there a tutorial on this anywhere?
__________________
http://www.unrealkillers.com | UnrealTournament 1999 | siege | combogib | instagib | bunnytrack | UT99
Reply With Quote
  #724  
Old 25 Sep 2012, 09:47
charlesr charlesr is offline
 
Join Date: Aug 2009
I haven't tried it myself. I googled and found this which should probably work: http://troy.jdmz.net/rsync/index.html and could include your forum filesystem as well as the db backup. Please report back on your progress
Reply With Quote
  #725  
Old 25 Sep 2012, 20:38
Delfi_r Delfi_r is offline
 
Join Date: Jul 2011
Originally Posted by Superorb View Post
The mysqlbackup.php file, but this code did not work for me when I added it to the test or live sites.
thanks, I'll try and report
Reply With Quote
  #726  
Old 26 Sep 2012, 22:43
Cicada Cicada is offline
 
Join Date: Mar 2002
doesn't seem to be backing up _all_ of the tables...
Reply With Quote
  #727  
Old 26 Sep 2012, 22:54
Superorb Superorb is offline
 
Join Date: Feb 2012
Originally Posted by Cicada View Post
doesn't seem to be backing up _all_ of the tables...
Which tables is it missing? My backups seem to be smaller than the DB size, but when restored to a test installation all the stats and data usage reported in the Vb admin pages is identical.
Reply With Quote
  #728  
Old 27 Sep 2012, 03:44
steeler7 steeler7 is offline
 
Join Date: Oct 2009
Paul,

Mod was working like a charm and then we changed accounts (stayed with the same host, just moved to a different server) and ever since, I'm not getting any Backups made. It's not version or vbulletin version based either since I recent;y upgraded to 4.2.0 and the newest version of this Mod and nothing.

Could there be something on the host side (using VPS) preventing this from working?
Reply With Quote
  #729  
Old 27 Sep 2012, 04:58
Superorb Superorb is offline
 
Join Date: Feb 2012
Originally Posted by steeler7 View Post
Paul,

Mod was working like a charm and then we changed accounts (stayed with the same host, just moved to a different server) and ever since, I'm not getting any Backups made. It's not version or vbulletin version based either since I recent;y upgraded to 4.2.0 and the newest version of this Mod and nothing.

Could there be something on the host side (using VPS) preventing this from working?
Did the directories or permissions change? When you manually run the script does it complete successfully?
Reply With Quote
  #730  
Old 27 Sep 2012, 18:43
rgf207 rgf207 is offline
 
Join Date: Mar 2008
i created the backups folder in the root of my vbulletin install and changed permissions to 777 but I still get this error

Backup Error : Could not write to destination file ( ../../backups/2012-09-27/Forum-2012-09-27-Vb_access.sql )
Reply With Quote
  #731  
Old 28 Sep 2012, 02:24
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
../../ will take you a couple of levels up the folder tree - on most steups, that will be outside of the sites html folder completely (which is where backups should be).
__________________
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
  #732  
Old 15 Oct 2012, 19:56
Delfi_r Delfi_r is offline
 
Join Date: Jul 2011
Last week we had a problem, something was deleted. After installing the last backup on a test server we extracted a copy of the deleted content and all went fine. One of the most useful plugins I have installed.
Reply With Quote
  #733  
Old 18 Oct 2012, 22:13
RedTurtle's Avatar
RedTurtle RedTurtle is offline
 
Join Date: May 2006
Originally Posted by betterthanyours View Post
I do have shell access to both servers. Is there a tutorial on this anywhere?
I use a cronjob on my destination server to login to my site server daily and sync up the backup folder.

Here's the command on the destination server:

rsync -vrltuzDP --rsh='ssh -p2222' admin@mydomain.com:~/backup/ /volume1/Backups/Database/

One thing you do have to do is set up a SSH authentication (I forget the exact term for this) but what it will let you do is login from your destination server into your site server without a password and still encrypt the data transfer.
Reply With Quote
  #734  
Old 25 Oct 2012, 10:42
kemana's Avatar
kemana kemana is offline
 
Join Date: Oct 2012
Smile About Version

Hey Paul This mod is really Great,,

i already mark installed

But there's one thing that really confuse me,,
i already set my timing at "Scheduled Task Manager" but it's not working.
but when i used "Run Now" it's worked.
i'm using Vbulletin Version 4.1.3

thx before
Reply With Quote
  #735  
Old 25 Oct 2012, 17:12
Superorb Superorb is offline
 
Join Date: Feb 2012
Originally Posted by kemana View Post
Hey Paul This mod is really Great,,

i already mark installed

But there's one thing that really confuse me,,
i already set my timing at "Scheduled Task Manager" but it's not working.
but when i used "Run Now" it's worked.
i'm using Vbulletin Version 4.1.3

thx before
Your site needs to be busy enough to run the cron jobs.
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 12:09.

Layout Options | Width: Wide Color: