install 2 osc sites on the same database server

[Guest]

Anybody has experience installing 2 osc sites using the same/shared database server?

 

How do you do it?

 

I have already one osc site running well, since this site does not occupy space that much. I decided to install a second site using the same server.

 

How do you do it with regards to the database server? Since I don't want them to have the same name convention for the first site and the second site.

 

During the osc installation, i don't see any option to specify a prefix for the database name/table.

 

Please help, I am stuck!

[Benm]

All table names are defined constants, that you could change - add a prefix for example.

 

However, i'd spare me the trouble and create a second mysql database - there is little difference in disk usage between 2 dabases running 20 tables each or 1 database holding 40.

[nottheusual1]

All table names are defined constants, that you could change - add a prefix for example.

 

However, i'd spare me the trouble and create a second mysql database - there is little difference in disk usage between 2 dabases running 20 tables each or 1 database holding 40.

<{POST_SNAPBACK}>

 

 

Ditto here. Create a second database with different user, etc.

 

It's a safety/security thing, too. A second DB/User/Pword is another barrier.

[Guest]

Ditto here. Create a second database with different user, etc.

 

It's a safety/security thing, too. A second DB/User/Pword is another barrier.

<{POST_SNAPBACK}>

 

 

How do i create a second database? Do i ask it from the hosting company?

You meant, i would have different db username, password and name?

 

I am a little blind about this matter, any detail of how to do this would really appreciated.