PDA

View Full Version : Need quick answer for too many mySQL db's


soundwash
8-27-06, 10:31 PM
Hi,

I need some help with the SQL migration mess.

-I've read about the reason behind having too many mysql db's..

First: fast answer question...

I have 7 of 5 mySQL in use (should be 5)

Ques: If attempt (via instant installer) to un install my phpBB
forum and reinstall it. will it bark at me and say NO WAY, your
already over your quota of 5 mySQL's? and lock me out till
i clear the extra 3?

Or will it allow me to reinstall and make a new db, no
questions asked?

(side note: i had paid $10 a long time ago for a 6th lifetime db,
did i lose this 6th one with the buy-out, or can i still run 6 mysql's
with no additional montly charge?
(- I see the mySQL policy
has changed..)

thank you,
-soundwash

IanS
8-28-06, 05:03 AM
If attempt (via instant installer) to un install my phpBB
forum and reinstall it. will it bark at me and say NO WAY, your
already over your quota of 5 mySQL's? and lock me out till
i clear the extra 3?

Or will it allow me to reinstall and make a new db, no
questions asked?
You don't need new databases for each program you install so you don't need to add another one. It will probably tell you that you've reached or exceeded you quota and send you to a page to pay for a new one. It may simply generate a charge to the account for an extra database. Support should be able to tell you.

i had paid $10 a long time ago for a 6th lifetime db,
did i lose this 6th one with the buy-out, or can i still run 6 mysql's
with no additional montly charge?Again, you'll need to ask support for an answer to that one.

Finally, I have 7 of 5 mySQL in use (should be 5)This is a quirk of the migration process. Apparently the migration scripts couldn't tell the difference between a DB that was 'live' and one that had existed and had been deleted so they transferred them all over to the new platform MySql servers. At least one of the databases you've got will be redundant and not in use by you.

spamjim
9-1-06, 12:14 PM
I've read about the reason behind having too many mysql db's..

I'm lost. Can this be explained? I am working on optimizing my site and was wondering if there is a performance issue with having all 5 databases used. What is meant by 'having too many mysql dbs'? Or is this just an inocuous comment on the limit of Powweb's number of databases per account?