Transfered site, can't import localhost.sql or database

Permalink
the following error comes up when i try to import the database in the myphpadmin:

SQL query:

--
-- Database: `theextr6_cnc2`
--
-- --------------------------------------------------------
--
-- Table structure for table `AreaGroupBlockTypes`
--
CREATE TABLE IF NOT EXISTS `AreaGroupBlockTypes` (
`cID` int( 10 ) unsigned NOT NULL DEFAULT '0',
`arHandle` varchar( 255 ) NOT NULL ,
`gID` int( 10 ) unsigned NOT NULL DEFAULT '0',
`uID` int( 10 ) unsigned NOT NULL DEFAULT '0',
`btID` int( 10 ) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY ( `cID` , `arHandle` , `gID` , `uID` , `btID` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;


and the following comes up when i try to import the localhost file:

SQL query:

--
-- Database: `theextr6_cnc2`
--
CREATE DATABASE `theextr6_cnc2` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

Can anyone help me? thanks

the site is listprocessdirect.com

 
TheRealSean replied on at Permalink Reply
TheRealSean
Maybe I am missing something but I can not actually see an error message here?

The above is just sql that appears to be valid
TheRealSean replied on at Permalink Reply
TheRealSean
I am going to assume you are unable to load these, which probably means you have some permission issues, both run just fine as SQL queries on my_sql

Are you trying to run the Create table before creating the database?