SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    Join Date
    Jan 2012
    Posts
    254
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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.

    Thanks.

  2. #2
    SitePoint Addict
    Join Date
    Jan 2012
    Posts
    254
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •