HELP! Error in restoring zen_customers

[techbot]

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.

[Merlinpa1969]

do a search all and replace

` with (blank)

you also need to delete this

DEFAULT CHARSET = latin1

[techbot]

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', 'xxx######################', '', 2, '055537171711', '', 'ae1ae600f1161ccfa1dfc289e0da96d1:52', '', 0, 'TEXT', 0, '' ) ;

[techbot]

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

[techbot]

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

[Ajeh]

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 ...

[techbot]

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