(I emailed this to Martin and Jaime rather than to the discussion group, so I'm re-sending it.)
Martin Gainty <mgai...@hotmail.com> 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: r...@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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org