Forums

Sql import error

Permalink
I have exported the sql database from the live environment using phpMyAdmin. When I trie to import the sql file in my local environment (MAMP 3.0.6) via phpMyAdmin I receive an error.

Incorrect table definition; there can be only one auto column and it must be defined as a key


The version of Concrete5 for this site is 5.2.1 and uses MYISAM as engine. 

CREATE TABLE IF NOT EXISTS `Areas` (
  `arID` int(10) unsigned NOT NULL auto_increment,
  `cID` int(10) unsigned NOT NULL default '0',
  `arHandle` varchar(255) NOT NULL,
  `arOverrideCollectionPermissions` tinyint(1) NOT NULL default '0',
  `arInheritPermissionsFromAreaOnCID` int(10) unsigned NOT NULL default '0',
  `arIsGlobal` int(1) unsigned NOT NULL default '0'
) ENGINE= MYISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=353 ;


With all newer websites this problem does not accure and the sql is somewhat different. 

CREATE TABLE `Areas` (
`arID` int(10) unsigned NOT NULL,
  `cID` int(10) unsigned NOT NULL DEFAULT '0',
  `arHandle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `arOverrideCollectionPermissions` tinyint(1) NOT NULL DEFAULT '0',
  `arInheritPermissionsFromAreaOnCID` int(10) unsigned NOT NULL DEFAULT '0',
  `arIsGlobal` tinyint(1) NOT NULL DEFAULT '0',
  `arParentID` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=90 ;


After updating the concrete5 site to 5.6.3.2 the db export still gives the same error.