Copying database to a new server/Concrete install.

Permalink August 08, 2014 at 12:09 PM

I'm trying to move a site to a new server. The new server has CPanel and Softaculous which I used to create a new Concrete install,

I've transerfered the files/packages/themes to the new site, but when I attempt to import the SQL dump from the old server to the new one using PHPmyAdmin, I get an error:

rror

SQL query:

-- ----------------------------
-- Table structure for AreaGroupBlockTypes
-- ----------------------------
CREATE TABLE `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;

MySQL said: Documentation
#1050 - Table 'AreaGroupBlockTypes' already exists

Is there some other way of getting the mySQL to overwrite the original table(s).

Thanks

Ken

JohntheFish replied on Aug 8, 2014 at 12:19 pm Permalink Reply

You get that error simply because it is the first table to be created and copied in (if the import hadn't stopped, you would get the same on the next table ....... etc.)

You can't create a table over a table that already exists, so you will need to empty the database first by dropping all tables.