I'm not sure where to post this question, so I'll give it a try here. I am going to be adding Links SQL in the near future. The server that I am on now, only gives me one mySQL database, which I am currently using for another program. I am about to do another large installation on my site, but before I do, I am wanting to know if I need to change web host providers. They are telling me that I do not need separate databases for each program. He said that I only need one, and create separate tables for each program. If this is not correct I want to change providers before I start this new install. Can anybody confirm if my provider is correct. Or should I look for a new one?

Thanks.

Jimmy Crow
http://www.homewithgod.com/

You need only one install of mysql on a server, but you need to have more than one databases inside this.
If they would let you install another db (you called it table) inside this mysql, everything its ok.
We have a provider (next to our own servers) that have installed one mysql, but let us use only one db inside. (There we could do so much tables as we want, but we would need for every links sql a new db inside.)

To make it clearer (sorry for my english)

MYSQL on server
| | |
database1 database x database n
| | | |
table 1..n

Ask them if you could install that thing you have now a second time. Then everything its ok.

Robert

Okay I think my server may have the same policy as yours. They are saying that all I can do with the one database that I have now is create more tables But that I can have only one database within it. But then they also told me that you could have many separate programs running off the single database by just addding new tables. I ask them if I could create another database within it and they said no that I could only add tables.

But if I understand you correctly, each program requires a separate database, whether it be completely separate or a database within a database. Is this correct?

Thank you for taking the time to answer my question.

Jimmy Crow
http://www.homewithgod.com/

Hi,

Your provider is right. You only need one database. You can use this database for any amount of programs including Links SQL as long the use different tables.

regards, alexander

Thanks for the help Alexander & Robert.

Jimmy Crow
http://www.homewithgod.com/

Think this only a question of "how to name it";
we are all right :-)
Robert

I thought I had answered on this (but maybe it was with the performance problems I was having -- seems better today).

You _can_ put all the things you need to do in one database, as long as the table names are not the same. You can only have one table with each name in any database. If you don't have any tables with any of the names of the databases in Links, you'll be ok.

The reason for using different databases is for ease in backing up, and for keeping data separate.

It's nicer if you have the ability to use different databases for different programs/purposes, but as long as you don't try to use the same table names, you'll be ok with one.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/