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: 1434
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

  #421  
Old 11 Apr 2011, 21:29
Phaedrus Phaedrus is offline
 
Join Date: Aug 2006
Originally Posted by Vick98 View Post
I don't know why I am having issues with this. it should be simple, I know. I am using ../backupfiles/ for the setting and have the file permission 777 but am still getting an error message...

Automatic Database Backup for vBulletin

Backup Error : Could not write to destination file ( ../backupfiles/Forum-2011-04-11-Full-Backup.sql )
Where did you create your backupfiles file?
Reply With Quote
  #422  
Old 11 Apr 2011, 22:02
Vick98 Vick98 is offline
 
Join Date: Nov 2010
Originally Posted by Phaedrus View Post
Where did you create your backupfiles file?
I created a new directory above the public_html
Reply With Quote
  #423  
Old 11 Apr 2011, 22:04
StudentCreche StudentCreche is offline
 
Join Date: Feb 2011
Processed Database in 2.694 seconds! Wooo!

Last edited by StudentCreche; 11 Apr 2011 at 22:17.
Reply With Quote
  #424  
Old 11 Apr 2011, 22:20
Vick98 Vick98 is offline
 
Join Date: Nov 2010
Originally Posted by StudentCreche View Post
Processed Database in 2.694 seconds! Wooo!
I would like to do the same but an having issues.
Reply With Quote
  #425  
Old 11 Apr 2011, 22:34
StudentCreche StudentCreche is offline
 
Join Date: Feb 2011
Originally Posted by Vick98 View Post
I would like to do the same but an having issues.
What do you need help with mate?
__________________
- http://www.StudentCreche.co.uk
- A student forum for GCSE, A Level and University students.
- Come and join one of the fastest growing online student communities today.
Reply With Quote
  #426  
Old 12 Apr 2011, 08:32
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Vick98 View Post
I created a new directory above the public_html
Then your path is probably wrong, try ../../backupfiles/
__________________
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
  #427  
Old 12 Apr 2011, 13:54
Vick98 Vick98 is offline
 
Join Date: Nov 2010
Originally Posted by Paul M View Post
Then your path is probably wrong, try ../../backupfiles/
That worked. I really appreciate your support. Again, thank you.
Reply With Quote
  #428  
Old 12 Apr 2011, 14:29
Phaedrus Phaedrus is offline
 
Join Date: Aug 2006
Originally Posted by Vick98 View Post
I created a new directory above the public_html
f'get it, you go tit answered.

Last edited by Phaedrus; 12 Apr 2011 at 14:30. Reason: no reason
Reply With Quote
  #429  
Old 12 Apr 2011, 14:30
Phaedrus Phaedrus is offline
 
Join Date: Aug 2006
Originally Posted by StudentCreche View Post
Processed Database in 2.694 seconds! Wooo!
LOL. Wow, back in the day.
Reply With Quote
  #430  
Old 16 Apr 2011, 23:18
Trusster Trusster is offline
 
Join Date: Jul 2010
Backup Error : Could not write to destination file tried to add all write permission "777" to the folder but didn't help.

Fixed it thanks for the mod

Last edited by Trusster; 16 Apr 2011 at 23:24.
Reply With Quote
  #431  
Old 21 Apr 2011, 10:24
shuuk shuuk is offline
 
Join Date: Sep 2010
i want to make a everyday at 20:00 autobackup..
how can i do that?

please can anyone show me that in a pic?
Attached Images
File Type: jpg Unbenannt.jpg (45.0 KB, 27 views)
Reply With Quote
  #432  
Old 25 Apr 2011, 11:52
TeknoSounds TeknoSounds is offline
 
Join Date: Nov 2006
change Stunde to 20... unless your server time is offset, then you'll need to adjust for that.
Reply With Quote
  #433  
Old 01 May 2011, 21:20
Stefan118 Stefan118 is offline
 
Join Date: Dec 2010
Every week I let this mod make a backup of the database, and every week I get this error in my mailbox:

Database error in vBulletin 4.1.3:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, May 1st 2011 @ 05:03:34 AM
Error Date : Sunday, May 1st 2011 @ 05:20:46 AM
Script : http://www.papegaaienforum.nl/cron.php?rand=1304219014
Referrer : http://www.papegaaienforum.nl/search.php?searchid=81263
IP Address : 94.211.138.61
Username : Niet Geregistreerd
Classname : vB_Database
MySQL Version :


What can I do about it exept for disabling this mod?
Reply With Quote
  #434  
Old 01 May 2011, 21:47
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
Originally Posted by Stefan118 View Post
What can I do about it exept for disabling this mod?
You can just ignore it. Its only the logging of the cron run after backup completion.

I would guess your mysql timeout is quite small and its timing out before the log command can be run (are you using the gzip option ?).
__________________
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
  #435  
Old 02 May 2011, 13:07
Stefan118 Stefan118 is offline
 
Join Date: Dec 2010
Ok, thank you.

Yes, I do use that, because the database is about 1.5 Gb. (350Mb with gzip)
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 03:42.

Layout Options | Width: Wide Color: