mysql database too large

I am receiving an error message from VB that basically is telling me that the mysql database associated with my VB forum is too large (9+ mb).

What exactly can I do to reduce the size of the database and not screw up the forum(s)?

Andrew

What is generating that message?

Chances are it's your hosting options and you need more disk space, but that's a guess.

9mb is a small database.

Exactly, My Database is over 400MB and I have no troubles.

a 9mb db is only a speck of dust. i dont understand why you would be getting that error. we need more information than what you have given.

What info would you want?

My web host says that 9mb is my limit, does that sound right?

Andrew

Absolutely not.... No credible webhost would impose such pathetic limits on a MySQL db. My advice... and I am certain everyone elses here... is to get away from your current host ASAP. Like now...!!!

Thanks.

FYI...

Here is my error message:



Database error in vBulletin 3.0.6:

Invalid SQL:
REPLACE INTO datastore
(title, data)
VALUES
('birthdaycache', 'a:4:{s:4:\"day1\";s:10:\"2005-05-17\";s:4:\"day2\";s:10:\"2005-05-18\";s:6:\"users1\";N;s:6:\"users2\";N;}')

mysql error: insert command denied to user: 'pbuilder_poll@supremeserver13.com' for table 'datastore'

mysql error number: 1142

Date: Tuesday 17th of May 2005 03:35:00 PM
Script: http://www.buildyourowncomputer.info/





Any input is great appreciated :)

Andrew

You need to grant update rights to that DB for the DB user from what I can tell.

I don't know if mysql would throw that error on a full DB/account.

Have you been able to use vB up to now...? or is this a new error that has only recently appeared. If yuo are telling us that your webhost is stating that your dB is too large and that is the maximun size of MySQL dB they are going to provide you then you absoltuely need to find a new webhost.

There are several mentioned on here... asmallorange.com being one of the highest rated. Perhaps take a look at Joey's top 10 webhosts url.

Good luck...

Thank you all for your help.

I was able to get my storage amount increased and that fixed the error.

I will take head to your hosting suggestions :)

Andrew

You shouldn't have had to get your storage amount increased.... what was there excuse...?

Change hosts....There is a thread on vB hosts somewhere in here look it up, some useful info there.

Also, it's good practice NOT to display Mysql Usernames publicly because it just eliminates one step for a hacker to have to go through.

is it possible it could just be a broken user profile which needs fixed in admincp