Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vB Database Backup Details »»
vB Database Backup
Version: 3.7.001, by Paul M Paul M is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Category: Administrative and Maintenance Tools - Version: 3.7.x Rating:
Released: 01-07-2008 Last Update: 04-29-2008 Installs: 514
Translations  
No support by the author.

This modification is no longer available or supported.

Note: Because I did not write the original version, but rather have modified & adapted it, support of this modification may be limited

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it, first for vb 3.6 and now for vb3.7.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. In 2007 David gave me permission to release my adaptation.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (lite) version that does a php based dump of your database either as one file, or one file per table.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic backup functionality on 3.7.


History:

v3.7.001 : First version for vB 3.7.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #252  
Old 09-15-2008, 08:08 PM
1quick1 1quick1 is offline
 
Join Date: Jun 2007
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hey everyone. I've been using this Mod for a while now and haven't had a single issue until now. This last week or so I get this error message now when it runs and it causes my forum to be shut off until I go in and turn it off and on again. I haven't changed anything so I'm not sure what the problem is and why this just started happening.

Database error in vBulletin 3.7.0:

Invalid SQL:
SHOW CREATE TABLE `postedithistory`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, September 15th 2008 @ 04:01:51 PM
Error Date : Monday, September 15th 2008 @ 04:02:02 PM
Script : http://www.extremebodybuilding.net/f...cron&cronid=35
Referrer : http://www.extremebodybuilding.net/f....php?do=modify
Reply With Quote
  #253  
Old 09-15-2008, 09:45 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Perhaps you have a low mysql timeout value.
Reply With Quote
  #254  
Old 09-15-2008, 09:50 PM
1quick1 1quick1 is offline
 
Join Date: Jun 2007
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Paul M View Post
Perhaps you have a low mysql timeout value.
I'm on a shared server so I don't get to mess wtih any of those settings (at least I don't think). It's weird cause I haven't had an issue with this mod, even when I used the old one on 3.6.x

My site is pretty small so the backup usually completes really fast. Like 5,000 threads, 50,000 posts, and 3000 members
Reply With Quote
  #255  
Old 09-16-2008, 12:44 PM
Stryker412 Stryker412 is offline
 
Join Date: May 2005
Posts: 326
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Stupid question but I want this mod to do backups just like vbulletin does. So I would set combine all tables to one file to yes right?
Reply With Quote
  #256  
Old 09-16-2008, 12:46 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If thats what vb does then yes.
Reply With Quote
  #257  
Old 09-16-2008, 01:08 PM
Stryker412 Stryker412 is offline
 
Join Date: May 2005
Posts: 326
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Got it working, thanks.
Reply With Quote
  #258  
Old 09-27-2008, 04:55 PM
TsirhCitna TsirhCitna is offline
 
Join Date: Jul 2005
Location: Kent, OH
Posts: 158
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've had a couple of occasions where the board did not get reopened after the backup.
Reply With Quote
  #259  
Old 09-29-2008, 01:30 AM
forsanelhaq forsanelhaq is offline
 
Join Date: Oct 2007
Posts: 34
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i want it back up to ftp

where can i find that
Reply With Quote
  #260  
Old 09-30-2008, 09:59 PM
PAKIDIL PAKIDIL is offline
 
Join Date: Jan 2007
Posts: 264
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

finally i got it working .i was having this erorr : An error occured during the Backup : Could not open Destination SQL file for writing. even i gave my backup folder 777 and also providing the correct path . i have found that the problem was i changed

"Y-m-d"
in to
2008-10-01
Do not Change "Y-m-d" until u get it working for ya

that's why it was showing me this erorr
An error occured during the Backup : Could not open Destination SQL file for writing

Strange . So may be few guyz having this problem due to this edit "Y-m-d".

Installed Now. one thing if any one could tell me how to compress the backup in to zip or gzip ? thanks
Reply With Quote
  #261  
Old 09-30-2008, 10:02 PM
Chadi's Avatar
Chadi Chadi is offline
 
Join Date: May 2004
Location: USA
Posts: 2,043
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by chadi View Post
Could you possibly add this feature to automatically prune backups older than x amount of days? That would be great.
Would be great if you can add this feature please. Thanks.
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 03:19 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08455 seconds
  • Memory Usage 2,309KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete