CMS Made Simple Forums

Hi:

I need to make big changes to a client's website.  The site is hosted on their Ubuntu machine (erver version 5.0.22-Debian_0ubuntu6.06.5-log).  I want to recreate the site in a folder on my webserver (cpanel with phpmyadmin running MySQL version 5.0.90-community, Apache version 1.3.42, and PHP version 5.2.13)

original db:
Db name: cmseclipse
user: eclipsecms
pass: ec32ma21de

New db:
DB: myuser_cmseclipse
user: myuser_eclipse
pass: ec32ma21de

• I have uploaded the files, ran the install, added the tables using the new db info, but DID NOT add the sample pages.
• I opened the sql text file I got from the client and changed the DB name and User name to the new ones.  
• in phpMyAdmin, i chose the new DB, clicked import, found the text file, clicked go

the result is the following error:
Error

SQL query:

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

MySQL said: Documentation
#1044 - Access denied for user 'myuser'@'localhost' to database 'cms'

Can anyone guide me through this process?

Something tells me that Current Database is incorrect, but I'm no expert, a novice at best..  

I think I solved it.  i changed the following info as well on the old DB txt file:

--
-- Current Database: `myuser_eclipse`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `myuser_eclipse` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `myuser_eclipse`;

I'm able to access admin using the login the client had created for me.  sorry for the panic, but it might help someone else, I hope.