Recovering Dropped Database

I just deleted a database table, only to discover that I deleted my entire database! I didn’t even know that was possible.

Is there any way to recover a lost database?

On closer inspection, it looks like I didn’t delete the database; instead I deleted all the tables. I see this message: “No tables found in database.”

Another note:

I did a search on my Mac and discovered that I apparently still have files associated with at least some of my tables, like this:

gw_geog.myi, gw_geog.myd, gw_geog.frm

I don’t see any similar files for some tables I created earlier today, but they should be easy to recreate.


For anyone with similar problems who might find this thread, the solution turned out to be simple - assuming you back up your hard drive. Just find your database folder on your cloned hard drive, copy the contents of the database folder and past them into the same folder on your computer. If you’re using MAMP PRO on a Mac, this is the path to your database files:

/Library/Application Support/appsolute/living-el/MAMP PRO/db/mysql

However, if you’re using an old version of MAMP, the path might be /Library/Application Support/living-el/MAMP PRO/db/mysql