I have all data in MySQL's .frm files. How can I restore the data? I do not want to restore all of them, just some records and tables so I need to make dumps out of them.
From what I can see, there are only .frm files, no .myd files. There is, however, ibdata1 file. How am I supposed to restore?
解决方案
I got it working.
1) I created an empty database named after what the real database was on the server in my local installation.
2) I killed "mysqld"
3) I copied the three ib* files to my local MySQL data directory (on Windows it was a hidden folder in root drive). Make sure you copied to InnoDB data file directory, depending on your my.cnf InnoDB and MyISAM data may be stored in different folders. I also copied the .frm files.
4) I ran "C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files (x86)\MySQL\MySQL Server 5.1\my.ini" --innodb-force-recovery=6
5) I ran mysql -uroot -pmypass to confirm use mydb; select * from mytable; returned results.
6) I used mysqldump mydb mytable --compact > file.sql
That's it!