Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 06 Sep 2007, 02:04
BonsaiNut BonsaiNut is offline
 
Join Date: Oct 2006
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 06 Sep 2007, 02:22
nexialys
Guest
 
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 06 Sep 2007, 04:42
BonsaiNut BonsaiNut is offline
 
Join Date: Oct 2006
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?

Last edited by BonsaiNut; 06 Sep 2007 at 04:55.
Reply With Quote
  #4  
Old 06 Sep 2007, 07:31
blogtorank's Avatar
blogtorank blogtorank is offline
 
Join Date: Jan 2006
Real name: Demetrius
Get a new host period...
Reply With Quote
  #5  
Old 06 Sep 2007, 08:54
Eikinskjaldi's Avatar
Eikinskjaldi Eikinskjaldi is offline
 
Join Date: Feb 2006
Location: Hell, never looked better
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 06 Sep 2007, 11:11
nexialys
Guest
 
admincp >> attachments >> Attachment Storage Type
Reply With Quote
  #7  
Old 06 Sep 2007, 21:57
BonsaiNut BonsaiNut is offline
 
Join Date: Oct 2006
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 07 Sep 2007, 10:58
Eikinskjaldi's Avatar
Eikinskjaldi Eikinskjaldi is offline
 
Join Date: Feb 2006
Location: Hell, never looked better
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 23 Sep 2007, 02:04
BonsaiNut BonsaiNut is offline
 
Join Date: Oct 2006
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...

Last edited by BonsaiNut; 23 Sep 2007 at 02:31.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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 14:37.

Layout Options | Width: Wide Color: