| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Hank | Date: | July 31 2005 8:48pm |
| Subject: | myisamchk error | ||
| View as plain text | |||
While running a -rq on a large table, I got the following error:
myisamchk: warning: Duplicate key for record at 54381140 against
record at 54380810
How do I find which record is duplicated (without doing the typical
self-join query)? This table has 70 million rows, so that's not
really feasible.
myisamchk --block-search # looked promising, but I can't find any
documentation on how to use it properly.
thanks.
--
-Hank
| Thread | ||
|---|---|---|
| • myisamchk error | Hank | 31 Jul |
| • Re: myisamchk error | beacker | 1 Aug |
