HELP! Error in restoring zen_customers

I've been trying to get a new store setup now for days...I have the new store installed, everything looks good but when I'm trying to restore the zen_customers table to keep my customers and their info, I get the following:

SQL query:

CREATE TABLE zen_customers (
customers_id int( 11 ) NOT NULL AUTO_INCREMENT ,
customers_gender char( 1 ) NOT NULL default '',
customers_firstname varchar( 32 ) NOT NULL default '',
customers_lastname varchar( 32 ) NOT NULL default '',
customers_dob datetime NOT NULL default '0001-01-01 00:00:00',
customers_email_address varchar( 96 ) NOT NULL default '',
customers_nick varchar( 96 ) NOT NULL default '',
customers_default_address_id int( 11 ) NOT NULL default '0',
customers_telephone varchar( 32 ) NOT NULL default '',
customers_fax varchar( 32 ) default NULL ,
customers_password varchar( 40 ) NOT NULL default '',
customers_newsletter char( 1 ) default NULL ,
customers_group_pricing int( 11 ) NOT NULL default '0',
customers_email_format varchar( 4 ) NOT NULL default 'TEXT',
customers_authorization int( 1 ) NOT NULL default '0',
customers_referral varchar( 32 ) NOT NULL default '',
PRIMARY KEY ( customers_id ) ,
KEY idx_email_address_zen ( customers_email_address ) ,
KEY idx_referral_zen ( customers_referral ( 10 ) ) ,
KEY idx_grp_pricing_zen ( customers_group_pricing ) ,
KEY idx_nick_zen ( customers_nick ) ,
KEY idx_newsletter_zen ( customers_newsletter ) ,
FULLTEXT KEY customers_password ( customers_password )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =174

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=174' at line 25

Furthermore, after it gives me this error, the zen_customers table isn't in my DB anymore! It just deletes it completely and I have to rebuild it each time.

do a search all and replace

` with (blank)

you also need to delete this

DEFAULT CHARSET = latin1

hmmm..

now I get this:

#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 '-- phpMyAdmin SQL Dump-- version 2.6.4-pl4-- http://www.phpm

Before this there is a long, LONG line of text where it looks like it's inserting a member, but they don't show up afterwards in the table. It looks like this (there are 170 of these):

) ENGINE = MYISAM AUTO_INCREMENT =174 ; -- -- Dumping data for table zen_customers-- INSERT INTO zen_customers
VALUES ( 1, 'm', 'xxx', 'xxx', '1971-10-12 00:00:00', '[email protected]', '', 1, '07031-720366', '', '03a6bbbdd6b8f11737e04f4800e43f42:d3', '', 0, 'TEXT', 0, '' ) ;

INSERT INTO zen_customers
VALUES ( 2, 'xxx', 'xxx', 'tas', '1987-01-17 00:00:00', '[email protected]', '', 2, '055537171711', '', 'ae1ae600f1161ccfa1dfc289e0da96d1:52', '', 0, 'TEXT', 0, '' ) ;

anyone? i thought this would just transfer over...its from the same site, same host and all

Anyone? I'd hate to make 170 people re-register.

Look at your current database table names ...

Do they all have prefixes of zen_

Note: you cannot create tables if they already exist ... do you want to drop the tables related to customers and load your old data? As in there is nothing in them at the moment of any worth for the customers?

The tables needed are the:
customers
customers_info
address_book

If you have prefixes, then they would be the same names but with the prefixes in front of them ...

Trying to restore just those three...I deleted them from the new store since there is nothing in them anyway, and using the backup from the old store with JUST those three tables, I tried to run them. This is what I keep getting:

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 ) 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 =192

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=192' at line 17