I have done this many times before excatly the same as this http://isenselabs.com/posts/step-by-ste ... new-server
When importing the database into phpmyadmin locally (wamp server) I get this error below?
Code: Select all
SQL query:
CREATE TABLE IF NOT EXISTS `address` (
`address_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customer_id` int( 11 ) NOT NULL ,
`firstname` varchar( 32 ) COLLATE utf8_bin NOT NULL default '',
`lastname` varchar( 32 ) COLLATE utf8_bin NOT NULL default '',
`company` varchar( 32 ) COLLATE utf8_bin NOT NULL ,
`company_id` varchar( 32 ) COLLATE utf8_bin NOT NULL ,
`tax_id` varchar( 32 ) COLLATE utf8_bin NOT NULL ,
`company_no` varchar( 32 ) COLLATE utf8_bin NOT NULL ,
`company_tax` varchar( 32 ) COLLATE utf8_bin NOT NULL ,
`address_1` varchar( 128 ) COLLATE utf8_bin NOT NULL ,
`address_2` varchar( 128 ) COLLATE utf8_bin NOT NULL ,
`city` varchar( 128 ) COLLATE utf8_bin NOT NULL ,
`postcode` varchar( 10 ) COLLATE utf8_bin NOT NULL ,
`country_id` int( 11 ) NOT NULL default '0',
`zone_id` int( 11 ) NOT NULL default '0'
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_bin AUTO_INCREMENT =253;
MySQL said: Documentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key