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
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
The above is just sql that appears to be valid