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
