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

  #1006  
Old 01 Nov 2014, 19:36
john7911 john7911 is offline
 
Join Date: Feb 2013
Advisor

Join Date: Oct 2008
Posts: 2,133
Design: Red Rum,Wide
You would have to leave us more details on what you did. How did you restore the database? What was the reason you had to restore your database from a backup?

Reply With Quote
I did a back up of my forum , before manipulating into the template, but i was not happy with the modification, and decided to restore the forum.
I have tried directly via phpmyadmin but it does not work properly , then I have used bigdump to do it.
All the table are in the database.



Thank you
Reply With Quote
  #1007  
Old 01 Nov 2014, 19:38
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Real name: Richie
Well this backs up only the database, not the files.

What do you mean it did not work? Do you have ssh access?
__________________

Let us take care of your forum, seo, seo reports, maintenance, what ever you need.

Reply With Quote
  #1008  
Old 06 Nov 2014, 00:46
ZeroDoom ZeroDoom is offline
 
Join Date: Dec 2013
Hi, I'm still confused about the date format and directory of the backups.. Could anyone help? I want mine to backup daily and have the backups stored in public_html/backups

Thanks!
Reply With Quote
  #1009  
Old 02 Jan 2015, 05:01
Mariner1 Mariner1 is offline
 
Join Date: Jan 2009
Hi. This has been working fine until a few days ago.When trying to do backups now i get this error in admincp

Database error in vBulletin 4.2.2:

Invalid SQL:
OPTIMIZE TABLE `filedata`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, January 2nd 2015 @ 05:54:35 AM
Error Date : Friday, January 2nd 2015 @ 05:55:08 AM
Script : http://www.xxxxxxxxxxx.com/admincp/c...cron&cronid=95
Referrer : http://www.xxxxxxxxxxxx.com/admincp/....php?do=modify
IP Address : xx.x.xxx.xx
Username : xxxxxxx
Classname : vB_Database
MySQL Version :

Any idea what this is and how to fix it pls
Reply With Quote
  #1010  
Old 02 Jan 2015, 07:40
charlesr charlesr is offline
 
Join Date: Aug 2009
Seems pretty straightforward - the database server was down when you tried to backup. Restart it.
On my linux server this is something like /etc/rc.d/init.d/mysqld restart.
Check logs to see if there's any clue why it was down. Maybe your server overloaded? If so, upgrade to one with more RAM or better IO. VB4 really needs 2GB RAM for a largish forum.
Reply With Quote
  #1011  
Old 02 Jan 2015, 09:50
Mariner1 Mariner1 is offline
 
Join Date: Jan 2009
Thanks charlesr,server reboot worked.

Last edited by Mariner1; 02 Jan 2015 at 10:03.
Reply With Quote
  #1012  
Old 02 Jan 2015, 10:57
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Jul 2009
Real name: Chris
Originally Posted by Mariner1 View Post
Hi. This has been working fine until a few days ago.When trying to do backups now i get this error in admincp

Database error in vBulletin 4.2.2:

Invalid SQL:
OPTIMIZE TABLE `filedata`;

MySQL Error : MySQL server has gone away

Any idea what this is and how to fix it pls
I see you got it going by doing a server reboot, that's great. But you may run into the issue again.

MySQL Server has gone away" is a server issue. See this: https://www.vbulletin.com/docs/html/...mysql_goneaway and this: https://www.vbulletin.com/forum/show...265#post310265 You will need to talk to your host about this in order to get it resolved.
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #1013  
Old 02 Jan 2015, 12:38
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Mariner1 View Post
Hi. This has been working fine until a few days ago.When trying to do backups now i get this error in admincp

Database error in vBulletin 4.2.2:

Invalid SQL:
OPTIMIZE TABLE `filedata`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, January 2nd 2015 @ 05:54:35 AM
Error Date : Friday, January 2nd 2015 @ 05:55:08 AM
Script : http://www.xxxxxxxxxxx.com/admincp/c...cron&cronid=95
Referrer : http://www.xxxxxxxxxxxx.com/admincp/....php?do=modify
IP Address : xx.x.xxx.xx
Username : xxxxxxx
Classname : vB_Database
MySQL Version :

Any idea what this is and how to fix it pls
It looks like optimizing that table took longer than your mysql timeout.

It should have run fine again next time.

You dont really need to have that [optimize] option enabled, I would turn it off.
__________________
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
  #1014  
Old 11 Jan 2015, 07:00
Daniel's Avatar
Daniel Daniel is offline
 
Join Date: Jul 2005
Real name: Daniel
Hi Will this work for big boards (1mil+ posts & attachments allowed)?
__________________
Daniel
Reply With Quote
  #1015  
Old 11 Jan 2015, 21:20
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
I have over two million posts.

Attachments will only be backed up if you store them in the database.
Thats generally not a good idea if you have a lot, as your database will be large.
__________________
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
  #1016  
Old 20 Jan 2015, 17:43
thunderclap82 thunderclap82 is offline
 
Join Date: Dec 2008
Is there a way to configure this so that the database is sent off server to something like Dropbox or Google Drive?
Reply With Quote
  #1017  
Old 20 Jan 2015, 19:12
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Not unless there is a way to specify it as a server path.
__________________
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
  #1018  
Old 23 Jan 2015, 07:51
ebp123 ebp123 is offline
 
Join Date: Mar 2010
can someone explain to me how to actually run this backup program? I just installed it and set the backup folder location and am a bit confused.
Reply With Quote
  #1019  
Old 23 Jan 2015, 15:38
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Well the title and description should give you a clue

vBulletin Cron Based Database Backup
It is a simple vBulletin cron trigged php system that does a dump of your database

It runs automatically, thats the purpose of cron based systems.
__________________
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
  #1020  
Old 23 Jan 2015, 19:33
ebp123 ebp123 is offline
 
Join Date: Mar 2010
So once i set up the backup folder, it automatically puts back ups of my database in it? Forgive my ignorance, im just a lumberjack trying my hand at the internet.
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 08:32.

Layout Options | Width: Wide Color: