Quick help moving mysql database

I am trying to move a mySQL database for an osCommerce solution from one server to another - but I keep getting an error, shows as:

CREATE TABLE IF NOT EXISTS `address_book` (

`address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,

`customers_id` int( 11 ) NOT NULL default '0',

`entry_gender` char( 1 ) NOT NULL default '',

`entry_company` varchar( 32 ) default NULL ,

`entry_company_tax_id` varchar( 32 ) default NULL ,

`entry_firstname` varchar( 32 ) NOT NULL default '',

`entry_lastname` varchar( 32 ) NOT NULL default '',

`entry_street_address` varchar( 64 ) NOT NULL default '',

`entry_suburb` varchar( 32 ) default NULL ,

`entry_postcode` varchar( 10 ) NOT NULL default '',

`entry_city` varchar( 32 ) NOT NULL default '',

`entry_state` varchar( 32 ) 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` ( `customers_id` )

) ENGINE = MYISAM DEFAULT

I've moved sites from my testing server to the deployment server before with no problem, so any help would be appreciated.

Kĩ năng: PHP

Xem nhiều hơn: mysql database server, int i, help php, moving from, server help, primary, php mysql database, oscommerce help, null, Mysql, mysql error, mysql database , int, database no, database c#, c++ mysql, C# MySQL, C# database, c mysql, move database oscommerce

ID dự án: #64958