how to use .myd files

[Logical1]

In trying to recover data from a crashed server I have managed to get .myd files for each of the tables.-  Structure of tables where simple and they are re-created in the new server. 

 

Question is: How can I get the data from .myd files into any other format or file (deli. text/excel/access/....) that can be used to export them into the new tables?

 

Any suggetions?

Thanks in advance.

 

[aschk]

You need to load these tables up into another MySQL installation (by placing the files into the MySQL directory structure, google it). Then you can do a mysqldump from cmd line to get a SQL script to run with most other dbs

[Mchl]

Basically if you have only myd files you've a problem. You should've backup all files (including .frm and .myi).

[Logical1]

For each of tables there are three files (with extentions you mentioned). Versions of MySQL are not the same, would placing them in the corresponding directory take care of the problem?

On the other hand since the new system is already prepared by making the identical tables, can't we get the data somehow out of .myd files and then export them in to the new tables?

Thanks in advance for your suggestions.

 

[Mchl]

What was the previous MySQL version, and what is the new one.

 

Basically you should create a database and tables with the structure coresponding to the backed up database.

Then shut down the server, and copy the backed up files over the files created by new server.

 

Note that if the MySQL versions are very different, this might not work.

[Logical1]

Thank you for the suggestions.

What is the structure of this file?  Can't I extract the data out of them into excell or even a text file and then simply export the new data?

 

[Mchl]

These are binary files, so you're likely to run into problems if you try to this with text tools... It is not impossible I suppose, but tricky for sure.