can't find MYD

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I'm running 3.23.54 on Windows 98. I cannot access any tables
of a database which previously worked fine and suddenly broke.
I get Error 1017 errno: 2 from both mysqlcc 0.9.4 and mysqlc.
The system complains that it cannot find any of the .MYD files,
although they are clearly there. The file system is perfectly
analogous to other databases in the same tree which work ok.

I can write a program to recover the MYD files in plain text form
if I knew the file structure, but I can't figure it out.

Any help, please.

Re: can't find MYD

Richard Trahan wrote:
Quoted text here. Click to load it
run mysqldump against one of your good databases.  It will
create a loadable file that you can use as a template in
building a file you can use to recreate your tables and reload
them with data.



Re: can't find MYD

Richard Trahan wrote:
Quoted text here. Click to load it

This error is discussed on this page:

Quoted text here. Click to load it

You could also try the many repair tools and options that come with
MySQL.  These are remarkably effective.  Try reading the docs for
myisamchk and see if you can repair the table:

And the subsections of that page.

Quoted text here. Click to load it

For what it's worth, the code to access a MYD file is all open-source
and available for download at  I'm referring to the source
code for the MySQL product itself.  You could theoretically find the
code within to read and write the MYD file.

However, IMHO it wouldn't be worth the effort to write such a program.
In most cases, your time will be better spent recovering the data from
backups, and recreating any additional data created since your last backup.

If the data is important and irreplaceable, you should always have a
reliable backup procedure in effect to ensure you have usable backups.

Bill K.

Site Timeline