Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 09-06-2007, 01:04 AM
BonsaiNut BonsaiNut is offline
 
Join Date: Oct 2006
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Newby questions about vBulletin and mySQL database(s)

I have had my site up for about 9 months and everything has worked flawlessly. However a week ago I exceeded my host's size limits for my mySQL database, and my host has since blocked access to the DB. My host currently limits mySQL databases to 100MB in size, though I can have up to 50 separate DB's under my hosting agreement. Given this situation, I have a couple of simple questions about DB Administration and how DB's work with vBulletin.

1) Can I have one forum that is supported by multiple DB's, and how (in general) would I configure the site? Would it be as simple as having a single forum category be its own DB? Would configuring the forum this way impact search functionality, site response time, or have any other negative or unforeseen consequences?

2) Would it be easy/better to just move to a new server host that offers a 5GB size limit on mySQL DB instead of my current host with the 100MB limit?

Thanks for helping me on my journey of self-discovery
Reply With Quote
  #2  
Old 09-06-2007, 01:22 AM
nexialys
Guest
 
Posts: n/a
Default

the best solution here would be to have a host with a larger webspace available, instead of a larger database range, and the save your attachments, avatars and profilepics to the file system instead of the database... you would light up your database, and not loose a single bit of data...
Reply With Quote
  #3  
Old 09-06-2007, 03:42 AM
BonsaiNut BonsaiNut is offline
 
Join Date: Oct 2006
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks very much for the response - that's all I needed to point me in the right direction

Is there a simple way for me to move the attachments, avatars and profilepics out of my existing database?
Reply With Quote
  #4  
Old 09-06-2007, 06:31 AM
blogtorank's Avatar
blogtorank blogtorank is offline
 
Join Date: Jan 2006
Posts: 450
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Get a new host period...
Reply With Quote
  #5  
Old 09-06-2007, 07:54 AM
Eikinskjaldi's Avatar
Eikinskjaldi Eikinskjaldi is offline
 
Join Date: Feb 2006
Location: Hell, never looked better
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by BonsaiNut View Post
Thanks very much for the response - that's all I needed to point me in the right direction

Is there a simple way for me to move the attachments, avatars and profilepics out of my existing database?
It is an option in admincp
Reply With Quote
  #6  
Old 09-06-2007, 10:11 AM
nexialys
Guest
 
Posts: n/a
Default

admincp >> attachments >> Attachment Storage Type
Reply With Quote
  #7  
Old 09-06-2007, 08:57 PM
BonsaiNut BonsaiNut is offline
 
Join Date: Oct 2006
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by nexialys View Post
admincp >> attachments >> Attachment Storage Type
Will this work with an existing forum that already has existing attachments? In other words, can I set the forum to save attachments to a web space folder instead of the DB, and will it "download" all existing attachments to the web folder and clear out the DB table?
Reply With Quote
  #8  
Old 09-07-2007, 09:58 AM
Eikinskjaldi's Avatar
Eikinskjaldi Eikinskjaldi is offline
 
Join Date: Feb 2006
Location: Hell, never looked better
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by BonsaiNut View Post
Will this work with an existing forum that already has existing attachments? In other words, can I set the forum to save attachments to a web space folder instead of the DB, and will it "download" all existing attachments to the web folder and clear out the DB table?
Yes.

Though depending on how much you currently have stored, it may take some time.
Reply With Quote
  #9  
Old 09-23-2007, 01:04 AM
BonsaiNut BonsaiNut is offline
 
Join Date: Oct 2006
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sorry to vent, but I continue to have problems with what I consider to be straight-forward issues.

So I decide to move my attachments from my DB to a file on the server. I create a folder on the server and CHMOD it to 777. Next I enter what I think is the proper path to the file. My URL is www.bonsainut.com. The folder is located at www.bonsainut.com/forums/attachments. It is pretty straightforward. Yet no matter what I do I cannot get past the next step. The Attachment Manager keeps saying "We attempted to write a test file to /forums/attachments, but we were unsuccessful. Please verify that the web server has write/delete permissions for this path."

I don't know whether I am writing the path incorrectly, or whether there is something wrong with the CMOD(?) Any help?

EDIT I realize now that you need to enter the FULL PATH to your attachments directory. All fixed now...
Reply With Quote
Reply

Thread Tools
Display Modes

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 05:49 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.05151 seconds
  • Memory Usage 2,232KB
  • Queries Executed 13 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (7)postbit_onlinestatus
  • (9)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_postinfo_query
  • fetch_postinfo
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete