Can I have more then one MySQL database?

[Chad711]

I have one for my forums right now. I need another one for a gaming ladder script. Can I do this and I assume I pay for the second one as well?

[alphadesk]

You can have as many as you need. There will be $10 activation fee per DB.

[SimCoWeb]

You can have more than one MySQL database but I think that 3 is the limit. Not positive on that, however ;)

[RocketJeff]

As the previous posters have stated, you can have more then one database. The real question is: do you really need more then one.

As long as the table names don't overlap, both uses should be able to co-exist in the same database. If you search through prior forum messages, you'll see people hosting multiple forums on the same database (by using different table prefixes for each board).

[Atomic-Design]

A logical reason to want more then 1 is if you are following a book that has a long/large tutorial which use many different databases instead of formatting in just different tables. If you are new to what they are teaching, which you probably are, you'll probably want to follow their walk-through specifically and exactly.

Just food for though.

(I only use 1 database)

[Chad711]

Well the second one is going to be for a gaming ladder script that I'm buying from here. This script cost more then everythig I have done for my site put together so far:( $200 bones!

You can see what I'm talking about here:

http://www.lurkemweb.com/scripts/

I'm getting the first one along with a tourney bracket as well.

So what do you suggest from here? That I get another MySQL or no?

[RadioRob]

Hello!

If you can change your table prefixes (or if it already comes with a unique prefix), then you will have absolutely no problem with the database you already have.

If it does not use a prefix at all (and the tables are named only like "members", "profiles", "ranks", etc)... AND you have another program that does the same exact thing... then you might possibly have issues.

So most likely 1 database should be fine... just need to do some double checking. :)

[Chad711]

I just saw that databases cost $10.00. I think I will go that route and save some headaches.

[RadioRob]

Cool. :) Either way works just fine.

Good luck with the script!