Hi kuroi, i have done a back up of the old mysql as advised, when i attempt to import files i have this error

SQL query:

CREATE TABLE `zen_address_book` (

`address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customers_id` int( 11 ) NOT NULL default '0',
`entry_gender` char( 1 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_company` varchar( 32 ) COLLATE latin1_general_ci default NULL ,
`entry_firstname` varchar( 32 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_lastname` varchar( 32 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_street_address` varchar( 64 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_suburb` varchar( 32 ) COLLATE latin1_general_ci default NULL ,
`entry_postcode` varchar( 10 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_city` varchar( 32 ) COLLATE latin1_general_ci NOT NULL default '',
`entry_state` varchar( 32 ) COLLATE latin1_general_ci default NULL ,
`entry_country_id` int( 11 ) NOT NULL default '0',
`entry_zone_id` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `address_book_id` ) ,
KEY `idx_address_book_customers_id_zen` ( `customers_id` )
) ENGINE = MYISAM AUTO_INCREMENT =2DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci
MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '',
`entry_company