Trying to transfer SQL dump from one database to another

[datatv]

Trying to import my SQL file from one database to another and I go to PHPmyAdmin and try to import it and get this error instead.

--
-- Current Database: `db60293_store`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `db60293_store` /*!40100 DEFAULT CHARACTER SET latin1 */;

MySQL said: Documentation
#1044 - Access denied for user 'dbXXXXXX'@'%' to database 'db60293_store'

db60293 is the old database. I don't know how to edit a SQL file. Can I just bring it into Excel and make changes to it? I think this is ZC 1.3.8a although I'm not certain of that. I plan to upgrade to 1.5 once this is completed. But this import needs to be made first.

[schoolboy]

Can I just bring it into Excel and make changes to it?

NO !!!

Do not bring excel anywhere near your database!

Have you CREATED a new database first?

[datatv]

Yes, the new DB is installed.

[DrByte]

How to make a database backup:
http://www.zen-cart.com/content.php?...ith-phpmyadmin

You obviously skipped step 2: "select your database from the pulldown on the left BEFORE exporting". If you don't pre-select your database from the list, then the CREATE DATABASE statement will be included in the export. And then, since most hosts don't let you create databases using raw SQL statements like CREATE DATABASE, you'll get the error you reported.