August 23rd, 2013, 06:31 AM
Can a dropped database/schema be recovered?
This morning I started MySQL Workbench and tried connecting to my default schema, but it wouldn't let me. So, I changed to a different schema and connected. I see that 2 out of 3 schemas are gone. I did not delete them. A couple of days back I was able to connect to the default one fine.
Is there a way to recover what is lost? I don't have a dump of those schemas. Volume Shadow Copy service was not running on my computer.
More info. In the ProgramData folder (where MySQL data is stored) I can see the folder for my schema with a bunch of frm files. Is there a way to restore these?
thanks a lot.