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

  #241  
Old 19 Jul 2010, 17:03
Blue91's Avatar
Blue91 Blue91 is offline
 
Join Date: Apr 2002
Yes, I do. That's fine. I'm guessing it changed between 3 and 4 since my 3.8 install uses folders and the 4.x doesnt, . No problem. I just had to change the directory in my scheduled task code that downloads a copy of the DB from my server to my home PC once a week.

Thanks for the quick reply and continued support of great mods.
Reply With Quote
  #242  
Old 19 Jul 2010, 18:32
gchristo gchristo is offline
 
Join Date: Jan 2006
seems to run, and leaves a backup in the correct folder, but I do not get the backup complete or done, it ends here
Processing searchgroup (24905)
Actually just looked and that is the last folder that it saved as well. Am I missing a setting somewhere?
Reply With Quote
  #243  
Old 20 Jul 2010, 13:12
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Sounds like its probably being timed out.
__________________
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
  #244  
Old 20 Jul 2010, 17:12
bfdzio bfdzio is offline
 
Join Date: Oct 2007
Question, I haven't had a chance to make a backup forum for testing so I don't know how good my backups are...so I am wondering about this:
My cpanel says that my database is 760mb. The backups come in at about 680mb. Is this normal?
Reply With Quote
  #245  
Old 20 Jul 2010, 23:41
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Yes, they are two different things.
__________________
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
  #246  
Old 21 Jul 2010, 10:35
Robru's Avatar
Robru Robru is offline
 
Join Date: Aug 2005
Hello Paul,

Can You give me an advise, what I must do with this mention? Put a higher mem in php?

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 4458722 bytes) in /var/www/forum/includes/mysqlbackup.php on line 436
Thanks!
Reply With Quote
  #247  
Old 21 Jul 2010, 16:07
Dragonsys's Avatar
Dragonsys Dragonsys is offline
 
Join Date: Jan 2008
Real name: Eric
Originally Posted by Robru View Post
Hello Paul,

Can You give me an advise, what I must do with this mention? Put a higher mem in php?



Thanks!
if you can use php.ini create one in your admincp and make the amount of mem = 8MB and increase by 4 (12, 16, 20, etc) until you stop getting this message.
Reply With Quote
  #248  
Old 21 Jul 2010, 16:11
gchristo gchristo is offline
 
Join Date: Jan 2006
Originally Posted by Paul M View Post
Sounds like its probably being timed out.
I set this
Set to yes to enable processing of larger tables in blocks. You may need this if your host timesout the backup on large tables.
still only goes to search and stops, what should i be changing?
Thanks for your help as well
Reply With Quote
  #249  
Old 21 Jul 2010, 18:02
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
There is nothing else you can change - some hosts simply prevent the timeout being changed.
__________________
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
  #250  
Old 24 Jul 2010, 16:46
dmlysiak dmlysiak is offline
 
Join Date: Feb 2010
I have a problem when I go to the forum page is displayed to me



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


vb 4.0.5
happens at 23.00 hours, when the cron to do backups
* 23 * * * Automatic Database Backup for vBulletin
Reply With Quote
  #251  
Old 24 Jul 2010, 17:35
Robru's Avatar
Robru Robru is offline
 
Join Date: Aug 2005
Originally Posted by Dragonsys View Post
if you can use php.ini create one in your admincp and make the amount of mem = 8MB and increase by 4 (12, 16, 20, etc) until you stop getting this message.
Thanks for your advise, a higher Mem increase to 16 do the trick, it works well now
Reply With Quote
  #252  
Old 24 Jul 2010, 20:20
oddmud's Avatar
oddmud oddmud is offline
 
Join Date: Oct 2009
Thanks this is great, I wasn't backing up at all until now. LOL!!!
__________________
Like Fly Fishing?
www.flyfishbc.com
Reply With Quote
  #253  
Old 25 Jul 2010, 22:39
dmlysiak dmlysiak is offline
 
Join Date: Feb 2010
Originally Posted by dmlysiak View Post
I have a problem when I go to the forum page is displayed to me



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


vb 4.0.5
happens at 23.00 hours, when the cron to do backups
* 23 * * * Automatic Database Backup for vBulletin
who help me?
Reply With Quote
  #254  
Old 29 Jul 2010, 02:04
sas forum sas forum is offline
 
Join Date: Jan 2008
I installed, chose my folder and then ran the task manager and got an email showing me a DB error. After processing all the tables the page said:

Processed Database in 170.889 seconds

[Compressing Combined File] : Processed File Compression in 27.256 seconds

Backup Completed Successfully

And then:

Database error in vBulletin 4.0.5:

Database error in vBulletin 4.0.5:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('cbu_crontask',
#########,
'Backup Completed Successfully',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, July 28th 2010 @ 07:51:13 PM
Error Date : Wednesday, July 28th 2010 @ 07:54:32 PM
Script : http://www.website.com/forum/admincp...cron&cronid=20
Referrer : http://www.website.com/forum/admincp....php?do=modify
IP Address : ##.###.###.##
Username : username
Classname : vB_Database
MySQL Version :



From what I could tell, the file did not save in the specified folder either.

Any help would be great. This looks like a welcome addition to my site. Thanks for the work put into this.
Reply With Quote
  #255  
Old 29 Jul 2010, 15:15
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
The file must have saved somewhere, otherwise you would not get the timing messages.

The database error means vbulletin failed to insert the completed ok message in the cronlog - the actual error suggests the database connection of the session running the task timed out.
__________________
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
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 07:32.

Layout Options | Width: Wide Color: