Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

our server hdds has crashed and we didnt have a current backup so we sent our hdds to a data recovery company, they have been working on hdd's for over a week and they have finally managed to save some files from hdds... My problem is saved files are only myi files and they are named numerically so i dont know which one blongs to which mysql table, is it possible to recreate myd and frm files from a myi file? or is there anything else i can do to get current data from myi?

share|improve this question

migrated from stackoverflow.com Jul 11 '12 at 13:29

This question came from our site for professional and enthusiast programmers.

1  
The MYI is only for MyISAM tables, what about the InnoDB or other engines?, take a look to this post: stackoverflow.com/questions/879176/… good luck –  jcho360 Jul 10 '12 at 12:54
    
there was just 1 php application that was using only myisam tables so other engines are not important for me... I also read that post before opening this question and as i understood that person had frm(table structure), myd(data) and myi(indexes) but i have only myi files... not a single solution in that thread works for me... fyi i have already tried copying myi files to mysql data folder however since there isnt frm files tables dont show up in phpmyadmin... –  renova Jul 10 '12 at 13:00
    
I don't think that it's possible only with myi files, because they are more the structure(index) of the table than the data, I'm going to try yo put this question en DBA.stackoverflow –  jcho360 Jul 10 '12 at 13:07
add comment

1 Answer

No, it's not possible - you need the MYD file, too. The MYI file is only the indexes and does not contain any data. It is like trying to restore the contents of the book High Performance MySQL from only the index pages.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.