I've created a database at my localhost, which works fine. I've requested my ISP to allow me use of MySQL and a database. They charged a small amount and created a database to their thinking—my login username! I uploaded the tables via a textfile.sql OK.

In order for my PHP files, many, to work, I'd have to find/replace all of the references to my original database to the new database name. What I'd like to do is add a database within the one they assigned. Can it be done? One of their support people said yes, another said no and asked for more money to make another database.

I've tried via telnet to create a new one but get caught with permissions denied. I've also tried using a txtfile.sql but get caught again.

Any suggestions?

What do you mean by creating database within a database? That is not possible. You can create another database or create table objects within any database.

_________________________
- Vijay G
Strive for Perfection

Thanks! You have just confirmed what I thought. The support personnel at my ISP need to get together! I didn't think creating a database within a database was possible.

TwoNames