Hello. My fault - it is a typo, instead of dealer_type_name, I should have written PRIMARY KEY (`dealer_type_id`,`dealer_type_id`). I don't know how it was possible to import this table to the same version, but it is not a right syntax. Change it to PRIMARY KEY (`dealer_type_id`).
cybermalandro cybermalandro wrote: > My fault about not replying to the list. What is the cause of this extra > line? is this a mysqldump bug in that older version of MySQL? how come I was > able to export and import this DB in the same version but different > platform? Any ideas? > > Thanks, > > cybm > > On 1/17/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > >>Hello. >> >>Sorry for such a late reply. The problem is in the duplicate line >>`dealer_type_name`. Remove one of these lines. Please, always send >>a copy of the message to the list. Most probably somebody whould have >>suggest you the same, if you had posted you mail to the list as well. >> >> >> >> >>Kuai >>cybermalandro cybermalandro wrote: >> >>>Sorry about that >>> >>>-- >>>-- Table structure for table `dealer_type` >>>-- >>> >>>CREATE TABLE `dealer_type` ( >>> `dealer_type_id` int(11) NOT NULL auto_increment, >>> `dealer_type_type` varchar(40) NOT NULL default '', >>> `dealer_type_name` varchar(40) NOT NULL default '', >>> PRIMARY KEY (`dealer_type_id`,`dealer_type_id`) >>>) TYPE=MyISAM PACK_KEYS=1; >>> >>> >>>Here it is, thanks a lot for your help. >>> >>>Kuai >>> >>> >> >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: >>http://lists.mysql.com/[EMAIL PROTECTED] >> >> > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
