Multiple databases


#1

anyone know how I can get multiple databases on the same db host?
i have already created a databse under sql.mydomainname.com
but for this application im using, i need to create another database on the same host and dreamhost doesnt seem to allow me to do this. I even logged into my mysql databse and did
CREATE DATABASE databasename;
and it gave me a permission error…

anyone know if this can be done?


#2

You’re only allowed one database per hostname.

You CAN create as many tables in that database as you want.

Try figuring out a prefix or suffix for the field names to differentiate what would be in one and what would be in another db.

Ex: “namexyz” and “nameabc”