Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

How ro Recover dropped table from MYSQL database?

Mar 15, 2016 6:34AM PDT

Hi All,

I am urgently seeking advise on methods and tools to recovery 3 tables that I dropped from my db.
I have no backups only the mdf and ldf files.
DB is not very big. Not sure how big but fairly small in size.
Several rows though.
Please try to point me to easy and cost effective tools or advise.
Kind regards

Discussion is locked

- Collapse -
Answer
Since you have no backups.
Mar 15, 2016 8:49AM PDT

You have to recreate the tables and fill with data you do have.

No tools required for that work.

-> Now two more things.

1. You see the spammers love this question. Any recoversomething.com site is your spammer reply. They have something to sell you without any warranty or refund if it fails.
2. Now that you lost your tables, what did you change so you won't lose them again?

- Collapse -
Answer
How ro Recover dropped table from MYSQL database?
Mar 23, 2016 7:02AM PDT

First, do a full back up of your existing db. When a table is dropped, SQL doesn't overwrite the disk area, but it will use the space for future allocations. A backup now will insure that you have a copy of the db with the least overwrite having already occurred.
What is the recovery model for the db -- is it Simple or Full (or Bulk-logged)?

- Collapse -
Answer
How ro Recover dropped table from MYSQL database?
Mar 23, 2016 7:59AM PDT

Looks like the recovery model is set to simple.
Have made a backup of the db as suggested.
Can you please advise...