Hi everyone,

I have deleted the database by mistake . I didn't have any record for this, I really need that deleted database.
If its not too much trouble to get it back, please provide best insights.
It would bethankful if you give a best suggestion !
Thank you!

    Tempted to just say "sucks for you". It really is a hard thing. Automate those backups right away!

    How was the data put into the database? I lost a very small one once. I had put all the data in via the CLI, and was able to reconstruct it by reading my .mysql_history file in the shell.

      If it was deleted by a file system command that actually deleted relevant files, it might be possible to recover with an OS-specific file recovery tool, since deleting a file typically just deletes references to the stored data on the disk -- the data itself remains there until it gets overwritten by some new/modified file. That does depend though on that disk data not having been overwritten yet.

      If it was deleted by some database transaction, if there's no backup in place and you don't have the transactions recorded anywhere (as alluded to above) . . . 🙁

        8 days later

        What OS and filesystem are you using? Have you done many writes to the drive since deleting?

          Write a Reply...