Zen Cart Logo
Forums / Installing on a Linux/Unix Server / Error message after importing database from other server

Error message after importing database from other server

Locked

Views: 1,566

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
8 Mar 2007, 3:13 AM
#1
ken_joy avatar

ken_joy

New Zenner

Join Date:
May 2006
Posts:
62
Plugin Contributions:
0

Error message after importing database from other server

Hi, I'm getting the following error message when importing my database to my new server:

SQL query:

CREATE TABLE 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_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_zen ( customers_id )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

MySQL said: Documentation
#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 17

additionally, when using this database with zencart 3.1.7, I get this message when trying to create a customer account:

1146 Table 'hojpub.address_book' doesn't exist
in:
[INSERT INTO address_book (customers_id, entry_firstname, entry_lastname, entry_street_address, entry_postcode, entry_city, entry_country_id, entry_gender, entry_company, entry_suburb, entry_zone_id, entry_state) VALUES ('1', 'adfad', 'adsfadf', '13321 adfadf', '91306', 'aadsfad', '223', 'm', '', '', '12', '')]

I'm sure I've overlooked something very simply, although I followed all the directions for moving from one sever to another.

Thanks for helping this newbie. :)