1007 Can't create 'dbStore'; database exists error

[jadams]

Hi. I am running ZC v1.39h and am moving my site from shared hosting to dedicated on a CentOS 5. Both the old and new sites are hosted with GoDaddy. I have successfully installed ZC on the dedicated server, having walked through that tutorial. Renaming the admin folder and updating both config files went smoothly as well. My issue concerns importing the db from the shared hosting site to the dedicated server. I appropriately backed up the db. Note two things: First, I renamed the db from the long alpha-numeric string provided when it was installed on the old server. Let's call that dbOldName. The new db is called dbStore. Second, I am using a new dba username. Let's call the old one dbOldUserName and the new one dbNewUserName. I went into the backed up sql file and carefully changed all instances of dbOldName to dbStore, using Microsoft Visual Studio. So I dropped all of the tables in the new db, dbStore, that was created upon the ZC installation. When I navigate to my hard drive and import the backed-up database, I get the 1007 error: Can't create database 'dbStore'; database exists. All I want to do is import the tables with my good data into the shell database. What am I missing??? Thanks.

[kuroi]

Sounds like when you did your export, you included (knowingly or not) a create database statement.

As you've demonstrated that you're comfortable editing the SQL, and the database already exists, simply remove it from your the SQL that you're importing. It'll be very close to the beginning of the file.

[jadams]

Thanks. I tried that, but now it's giving me a #1044 - Access denied for user 'dbNew'@'%' to database 'information_schema'. Stupid question, but should I be using the server username and the server password or the db username and the db password? I've triple-checked my config files and the connection info is exactly the same as my db UserName and db password. Thanks.

[jadams]

Never mind. Got it! Thanks.