On Wed, 4 Dec 2002, Heikki Tuuri wrote: > what MySQL version you are running? On what OS?
Version 3.23.53-max-nt-log on Windows Professional 2000 > What does SHOW CREATE TABLE tabdocumentoconsultado; print? I created again all the tables of the database called "bdatena". Now that the table is no more corrupt, it prints Create Table: CREATE TABLE `tabdocumentoconsultado` ( `IdDocConsultado` int(11) NOT NULL auto_increment, `IdAprendiz` varchar(15) NOT NULL default '', `codcurso` int(11) NOT NULL default '0', `IdP` int(11) NOT NULL default '0', `DiaHoraInicial` datetime NOT NULL default '0000-00-00 00:00:00', `Tipo` enum('Cur','Top','UE') NOT NULL default 'Top', `DiaHoraFinal` datetime default NULL, `EmPausa` enum('S','N') NOT NULL default 'N', PRIMARY KEY (`IdDocConsultado`), UNIQUE KEY `umDoc` (`IdAprendiz`,`codcurso`,`IdP`, `DiaHoraInicial`,`Tipo`,`DiaHoraFinal`,`EmPausa`), KEY `DoConsInd` (`IdAprendiz`,`codcurso`), FOREIGN KEY (`IdAprendiz`, `codcurso`) REFERENCES `bdatena.cursa` (`idaluno`, `codcurso`) ) TYPE=InnoDB > Have you used an InnoDB version <= 3.23.43 and stored characters with code > > 127 in the table? E.g., accent characters? The ordering of such characters > in the latin1 charset changed in 3.23.44. In other tables, I stored accent characters. In tabdocumentoconsultado (in English, something like ConsultedDocumentTable), I don't store characters with code > 127. How do I discover the InnoDB version? I don't know its version. > What kind of operations you did to the table? INSERT, UPDATE, DELETE? INSERT and UPDATE. > Can you repeat the corruption starting from a fresh table? The corruption didn't happen again with a fresh table. > You can repair the corruption by dump + DROP + CREATE + import of the table. Thanks for the hint! Regards, Willie D. Leiva --------------------------------------------------------------------- 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