Creating database in SQL/phpMyAdmin

[wiggy]

I was running InvisionBoard and Coppermine Gallery on my website. Now that I've moved to the new DA servers, I need to create a new database with the same name as the old one, and import the dump file, right? However, DA only creates database names with the prefix 'apartment2_xxxx', I've tried manually creating it in phpMyAdmin, but it gives me this error message:

Database apartment2l_com running on localhost
Error

SQL-query :

CREATE DATABASE `apartment2l_com`

MySQL said:


Access denied for user: 'apartment2@localhost' to database 'apartment2l_com'

I remember Ensim allowing you to create a database with whatever name you wanted.

[Joe]

Because of the structure of DA, you can only create username_databasename

Shouldn't be too hard - just change your Coppermine config.php file to reflect the new changes in the database name.

Joe

[thevillageinn]

to add to what Joe said...

create the new database, and then update your config files for coppermine and IPB. The dump file will take care of naming tables correctly (exactly as they were in your old DB), so you won't have to worry about that.

[wiggy]

Didn't think of that... thanks guys.