Yesterday after a driver update my Windows crashed and I got a BSOD right at startup so I didn't had a choice I set Windows back to the last working point but sadly my last working restore point is from few days ago and since than I was working on a lots of stuff and this restoration messed up two of my databases.

Now when I check the database I see every table in the schema view but when I click it of course it says table doesn't exist.

So I checked C:\ProgramData\MySQL\MySQL Server 5.6\data\mydb\ and there I saw that the .MYD and .MYI files are missing for those tables and only the .frm files are there.

Than I tried to run Recuva on the folder but it didn't found anything.

Is there any way to recover those lost tables or I have to start my work form the beginning?

  • Is there a restore point from the driver installation? – davidbaumann May 2 '15 at 19:12
  • yes there is but when I tried to set Windows to that the restore process throw an error and it did not restore Windows so I chose the clostet date which was made by Avast before I updated it and that worked – Laci K May 2 '15 at 19:16
  • I don't understand... so the problem was already solved? Maybe this helps: sevenforums.com/tutorials/… – davidbaumann May 2 '15 at 19:18
  • No the problem isn't solved, because the restoration process damaged 2 database in MySQL which I was working on and I want to recover those MySQL tables which were lost. – Laci K May 2 '15 at 19:22
  • Does my link help? – davidbaumann May 2 '15 at 19:25

You can restore the files from your latest restore point using http://nicbedford.co.uk/software/systemrestoreexplorer/

Just copy them to your mysql folder (I would backup the old files before).

Here you can see, how to restore the data from a backup: https://stackoverflow.com/questions/10680261/restore-mysql-database-folder-from-a-recovered-hard-disk

In fact, you should stop all mysql services before copying the files.

After restore, check all the tables.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.