Try changing the keyname unique to email. SO:
UNIQUE KEY email (email) -->-----Original Message----- -->From: Chris W. Parker [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 11:04 AM -->To: [EMAIL PROTECTED] -->Cc: [EMAIL PROTECTED] -->Subject: RE: DB not restoring from dump file --> -->[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> --> on Monday, October 27, 2003 10:52 AM said: --> -->> can you send the contents of your dumpfile up to this point. -->> assuming its line 118 of hte dumpfile and 21 of this build table query --> -->Line 118 is the beginning of the 'customers' table definition and line -->21 is the last line of that definition. --> -->Thanks for you help so far. --> -->Chris. --> --> -->DUMP: --> -->-- MySQL dump 8.22 -->-- -->-- Host: localhost Database: aardcart -->--------------------------------------------------------- -->-- Server version 3.23.56 --> -->-- -->-- Table structure for table 'cart' -->-- --> -->DROP TABLE IF EXISTS cart; -->CREATE TABLE cart ( --> id int(10) unsigned NOT NULL auto_increment, --> phpsessid varchar(32) NOT NULL default '', --> cust_id int(10) unsigned NOT NULL default '0', --> created datetime NOT NULL default '0000-00-00 00:00:00', --> lastaccessed datetime NOT NULL default '0000-00-00 00:00:00', --> PRIMARY KEY (id) -->) TYPE=MyISAM; --> -->/*!40000 ALTER TABLE cart DISABLE KEYS */; --> -->-- -->-- Dumping data for table 'cart' -->-- --> --> -->LOCK TABLES cart WRITE; -->INSERT INTO cart VALUES -->(1,'89ba2322b4b0723bf052ffc2758266a9',6,'2003-10-07 -->14:50:17','2003-10-10 -->16:27:49'),(2,'89ba2322b4b0723bf052ffc2758266a9',12,'2003-10-07 -->16:04:01','2003-10-07 -->16:05:09'),(10,'cdf88dc1c29adde03b6e3e79942f2a07',0,'2003-10-22 -->09:48:01','2003-10-22 09:48:01'); --> -->/*!40000 ALTER TABLE cart ENABLE KEYS */; -->UNLOCK TABLES; --> -->-- -->-- Table structure for table 'cart_contents' -->-- --> -->DROP TABLE IF EXISTS cart_contents; -->CREATE TABLE cart_contents ( --> id int(10) unsigned NOT NULL auto_increment, --> cart_id int(10) unsigned NOT NULL default '0', --> prod_id varchar(25) NOT NULL default '', --> price float(4,2) unsigned NOT NULL default '0.00', --> qty smallint(5) unsigned NOT NULL default '0', --> PRIMARY KEY (id) -->) TYPE=MyISAM; --> -->/*!40000 ALTER TABLE cart_contents DISABLE KEYS */; --> -->-- -->-- Dumping data for table 'cart_contents' -->-- --> --> -->LOCK TABLES cart_contents WRITE; -->INSERT INTO cart_contents VALUES -->(1,1,'testing013',99.00,4),(10,1,'MONUTB',145.00,1),(9,1,'MONUTB',145 .00 -->,1),(6,1,'MONUTB',145.00,2),(8,1,'ATITCB',194.00,1),(11,10,'testing01 9', -->104.00,1),(12,10,'testing011',99.00,1); --> -->/*!40000 ALTER TABLE cart_contents ENABLE KEYS */; -->UNLOCK TABLES; --> -->-- -->-- Table structure for table 'cart_contents_attributes' -->-- --> -->DROP TABLE IF EXISTS cart_contents_attributes; -->CREATE TABLE cart_contents_attributes ( --> cart_cont_id int(10) unsigned NOT NULL default '0', --> attr_id smallint(5) unsigned NOT NULL default '0', --> option_id smallint(5) unsigned NOT NULL default '0', --> cart_id int(10) unsigned NOT NULL default '0' -->) TYPE=MyISAM; --> -->/*!40000 ALTER TABLE cart_contents_attributes DISABLE KEYS */; --> -->-- -->-- Dumping data for table 'cart_contents_attributes' -->-- --> --> -->LOCK TABLES cart_contents_attributes WRITE; -->INSERT INTO cart_contents_attributes VALUES -->(9,40,118,1),(8,24,4,1),(8,7,17,1),(8,6,14,1),(6,40,118,1),(8,2,8,1), (10 -->,40,118,1),(12,39,113,10); --> -->/*!40000 ALTER TABLE cart_contents_attributes ENABLE KEYS */; -->UNLOCK TABLES; --> -->-- -->-- Table structure for table 'categories' -->-- --> -->DROP TABLE IF EXISTS categories; -->CREATE TABLE categories ( --> id int(10) unsigned NOT NULL auto_increment, --> name varchar(50) NOT NULL default '', --> lft smallint(5) unsigned NOT NULL default '0', --> rgt smallint(5) unsigned NOT NULL default '0', --> description tinytext NOT NULL, --> PRIMARY KEY (id) -->) TYPE=MyISAM; --> -->/*!40000 ALTER TABLE categories DISABLE KEYS */; --> -->-- -->-- Dumping data for table 'categories' -->-- --> --> -->LOCK TABLES categories WRITE; -->INSERT INTO categories VALUES (31,'Riot Gear',98,99,''),(30,'Entry -->Tools',96,97,''),(29,'Hydration',94,95,''),(28,'Load -->Bearing',78,93,''),(27,'Gloves',74,77,''),(26,'Apparel',70,73,''),(21 ,'A -->rmor',52,53,''),(20,'WMD',24,51,''),(19,'Less-Lethal',6,23,''),(25,'F las -->hlights',68,69,''),(24,'Batons',62,67,''),(23,'Duty -->Gear',56,61,''),(22,'Holsters',54,55,''),(32,'Gear -->Bags/Cases',100,101,''),(38,'Root',1,102,''),(39,'Nuclear',49,50,''), (40 -->,'Biological',45,48,''),(41,'Chemical',27,44,''),(73,'Force -->Protection',4,5,''),(74,'Batons',2,3,''); --> -->/*!40000 ALTER TABLE categories ENABLE KEYS */; -->UNLOCK TABLES; --> -->-- -->-- Table structure for table 'customers' -->-- --> -->DROP TABLE IF EXISTS customers; -->CREATE TABLE customers ( --> id int(10) unsigned NOT NULL auto_increment, --> fname varchar(20) NOT NULL default '', --> lname varchar(20) NOT NULL default '', --> address1 varchar(40) NOT NULL default '', --> address2 varchar(40) default '', --> city varchar(20) NOT NULL default '', --> state char(2) NOT NULL default '', --> zip varchar(10) NOT NULL default '', --> phone varchar(20) default '', --> fax varchar(20) default '', --> email varchar(32) NOT NULL default '', --> newsletter tinyint(1) NOT NULL default '0', --> password varchar(32) NOT NULL default '', --> signupdate datetime NOT NULL default '0000-00-00 00:00:00', --> lastvisit datetime NOT NULL default '0000-00-00 00:00:00', --> type tinyint(3) unsigned NOT NULL default '0', --> security smallint(6) NOT NULL default '0', --> company varchar(64) default '', --> PRIMARY KEY (id), --> UNIQUE KEY unique (email) -->) TYPE=MyISAM; --> -->-- -->Don't like reformatting your Outlook replies? Now there's relief! -->http://home.in.tum.de/~jain/software/outlook-quotefix/ --> -->-- -->MySQL General Mailing List -->For list archives: http://lists.mysql.com/mysql -->To unsubscribe: -->http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
