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

Reply via email to