I'm trying to import a database and wonder how I can stop getting the following error?
"#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key "
"#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key "
Here's the result when importing using PHPMyAdmin.
SQL query:
--
-- Database: db_factorypattern
--
-- Table structure for table wp_commentmeta
--
-- Database: `db_factorypattern`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_commentmeta`
--
CREATE TABLE IF NOT EXISTS `wp_commentmeta` (
`meta_id` bigint(20) unsigned NOT NULL auto_increment,
`comment_id` bigint(20) unsigned NOT NULL default '0',
`meta_key` varchar(255) default NULL,
`meta_value` longtext
) ENGINE=MyISAM AUTO_INCREMENT=2610 DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS wp_commentmeta (
meta_id bigint(20) unsigned NOT NULL auto_increment,
comment_id bigint(20) unsigned NOT NULL default '0',
meta_key varchar(255) default NULL,
meta_value longtext
) ENGINE=MyISAM AUTO_INCREMENT=2610 DEFAULT CHARSET=utf8;
MySQLMySQL said: Documentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
"#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key "
