Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- can't find MYD
- Richard Trahan
April 16, 2005, 11:01 pm
rate this thread
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:
This error is discussed on this page:
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.
For what it's worth, the code to access a MYD file is all open-source
and available for download at MySQL.com. 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.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum