(I emailed this to Martin and Jaime rather than to the discussion
group, so I'm re-sending it.)
Martin Gainty <mgainty@stripped> writes:
> Jesse ..please keep us apprised on your progress..we would like to
> know how fubar the db can be before it becomes 'unrecoverable'
Well, I'm not having much luck so far.
I have a file that I'm certain is recorded.frm. I also have a file
that I'm almost certain is recorded.MYD. I stuck an arbitrary .MYI
file in as recorded.MYI, in the hopes that it would be overwritten
with good data.
Unfortunately, here's the result:
root@pw:/var/lib/mysql/mythconverg# myisamchk -o recorded.MYI
Warning: option 'key_buffer_size': unsigned value 18446744073709551615 adjusted to
Warning: option 'read_buffer_size': unsigned value 18446744073709551615 adjusted to
Warning: option 'write_buffer_size': unsigned value 18446744073709551615 adjusted to
Warning: option 'sort_buffer_size': unsigned value 18446744073709551615 adjusted to
- recovering (with keycache) MyISAM-table 'recorded.MYI'
Data records: 0
Key 1 - Found wrong stored record at 0
Found link that points at 19054226382932 (outside data file) at 36708
Found link that points at 13556668244051 (outside data file) at 44344
Found link that points at 13673551504478720 (outside data file) at 59948
Found link that points at 5996055336546156 (outside data file) at 59956
Found link that points at 17916077434656 (outside data file) at 64864
Found block with too small length at 69120; Skipped
and so on.
The result is an empty database, of course.
Now, someone mentioned that I need to be sure I have the same versions
of MySQL. I thought that I had the same versions, since I thought
that I had the same versions of Ubuntu on my working and non-working
machines. Unfortunately, it looks like the non-working machine had
5.0.67-0ubuntu6, while the working machine has
5.1.30really5.0.75-0ubuntu10.3 (referring here to Ubuntu package
versions, but I think the mysql versions are 5.0.67 and 5.0.75,
Perhaps that's the problem? Or perhaps I'm wrong about the .MYD file
and it isn't really recorded.MYD?
"So how do you go on? [...] How will you keep moving for the next few
weeks or months until you are known for what you are, the story
becomes huge all over the world, and you have reporters at your
schools asking you, why?" -- Another JSH mystery