Moved servers and data base will not import any help?

[touchclothing]

I am moving to a new server and I have fallow the how to in the zen cart facts but i keep getting this error when I import. Any ideas?

Error

SQL query:

CREATE DATABASE `ms_store` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

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

[Merlinpa1969]

If you have already created the database,

then you need to remove the create database line from the top of the sql file

[touchclothing]

Yes I created a data base and then I droped the tables. how do I get rid of the create data base?

[touchclothing]

this is what I see

-- Database: `ms_store`
--
DROP DATABASE `ms_store`;
CREATE DATABASE `ms_store` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE ms_store;


do I take out everything after CREATE DATABASE

[Merlinpa1969]

remove this

DROP DATABASE `ms_store`;
CREATE DATABASE `ms_store` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE ms_store;

[touchclothing]

Why is it when I import it it does not build any tables? it still shows no tables found?

[touchclothing]

when i import it says this


Import has been successfully finished, 0 queries executed.

[touchclothing]

any ideas my shop is down right now and I really need to get it up and moving??? Please

[jetx]

Look I'm no expert but this is what I do when changing servers without root access, just your standard old hosted site. From the original server I export the database using phpmyadmin, export it to suit the new servers version of mysql. Export it as sql, save it 1. structure and data (name this file as such with sql extension), 2. data only.

Usually you can now just go to your new server, go to phpmyadmin, create the database, import sql file, use the same collation, and you should be good to go. Or if the structure is ok then empty the tables and import just the data.