Dyego,
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, November 19, 2002 1:35 PM
Subject: The Error in InnoDB upgrading from 3.23.53 to 4.0.5
The log put this error :
InnoDB: Error: table ./wnotas25/ITEMREC has no primary key in InnoDB
InnoDB: data dictionary, but has one in MySQL!
This error is normal ? if not , what is the command to *fix* this ?
MySQL tries to pick a primary key if there is no defined beforehand. It may
be the rule to pick it has changed from 3.23.53 to 4.0.5.
Please look with SHOW CREATE TABLE (in 3.23.53) what is the table definition
like. Send me also the .frm file of the table.
The fix is probably drop + dump + reimport, but I want to see what caused
the discrepancy in primary keys.
Tnks ;)
Regards,
Heikki
sql,query
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
E S C R I B A I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--
$ look into my eyes
look: cannot open my eyes
-
Reply: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
