I just installed MySQL 5.0 on my windows machine and was trying to load
the output from a MySQLFront export from our 4.0.16 production system
when I got the following error..
C:\>mysql -u root mailprint < e:\mp20040205.sql
ERROR 1062 at line 7893168: Duplicate entry 'Name-4928 N Brooklyn
Kansas City' for key 3
I'm not sure why I would get a "Duplicate entry" error on an index that
was not defined as Unique.
Have the rules for indexes changed somewhere between 4.0.16 and 5.0 ?
Here is the table definition from the 4.0.16 machine.
| product_order_features | CREATE TABLE `product_order_features` (
`ordr_ID` int(11) unsigned NOT NULL default '0',
`poft_Sub_Month` char(3) NOT NULL default '0',
`poft_ID` tinyint(3) unsigned NOT NULL auto_increment,
`poft_Sub_Item` char(1) NOT NULL default '0',
`poft_Feature` varchar(40) NOT NULL default '',
`poft_Value` text NOT NULL,
`poft_Contents` text,
`poft_Active` enum('Yes','No','Mail Sent','Deleted','PKOR','PK Hold')
NOT NULL default 'Yes',
`poft_Timestamp` timestamp(14) NOT NULL,
`poft_Create` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ordr_ID`,`poft_Sub_Month`,`poft_Feature`,`poft_ID`),
KEY `Feature_Value_IDX` (`poft_Feature`,`poft_Value`(20)),
K
) TYPE=MyISAM |
C:\>mysql -u root mailprint
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.0-alpha-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
