List:General Discussion« Previous MessageNext Message »
From:Jesse F. Hughes Date:June 4 2010 6:29pm
Subject:Re: Missing database file names
View as plain text  
(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
4294963200
Warning: option 'read_buffer_size': unsigned value 18446744073709551615 adjusted to
4294967295
Warning: option 'write_buffer_size': unsigned value 18446744073709551615 adjusted to
4294967295
Warning: option 'sort_buffer_size': unsigned value 18446744073709551615 adjusted to
4294967295
- 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,
resp.).

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
Thread
Missing database file namesJesse F. Hughes3 Jun
  • Re: Missing database file namesDan Nelson3 Jun
    • Re: Missing database file namesJesse F. Hughes3 Jun
    • Re: Missing database file namesJesse F. Hughes4 Jun
    • Re: Missing database file namesJesse F. Hughes4 Jun
      • Re: Missing database file namesJaime Crespo Rinc√≥n4 Jun
Re: Missing database file namesJesse F. Hughes4 Jun
  • Re: Missing database file namesJesse F. Hughes4 Jun
    • Re: Missing database file namesJesse F. Hughes5 Jun