slider

How can i be sure my Dropped table still exist or it's overwritten?

  1. Backup and Data Recovery for MySQL
  2. How can i be sure my Dropped table still exist or it's overwritten?
1
1

Hello there.

I can easily find some of my lost table’s records

Exact deleted record by mixing two adjacent col’s record

grep -a exact_deleted_record disk.img
.......exact_deleted_record ........ printed

Also search for match :
➜ grep -r exact_deleted_record disk.img
Binary file disk.img matches

But after last step of parsing data (As blog posts) again i used grep for that records by using :
grep deleted_record dumps/default/users

But result is empty ! 🙁

I should notice that I checked all of possible tables that exist inside 00000000001.page
And just one of tables had a primary keys there.
So i’m sure that i have not any other table to recover inside log.

So to make sure to do steps again and again please first tell me , Even after i see my record inside disk image (by grep) is it possible that my data is not recoverable ?

    • Guest
    • 3 months ago
    Do you get any matches when you run `grep -r deleted_record pages-disk.img`?
    • Guest
    • 3 months ago
    Yes , even i can see that row completely by -a option——–i Updated question— You can check the question again to see the bash result.
  • You must to post comments
Showing 0 results
Your Answer

Please first to submit.