1

We Have Mistakenly Dropped a Table in my DB and am using MySql . Is it Possible to ROLL Back or any other options . Please Provide your Valuable Suggestions

  • 1
    Question 1: do you have backups? Question 2: Have you tested them? – ypercubeᵀᴹ Feb 17 '16 at 17:16
  • no i don't have backups, tested means – Hari Shankar Feb 17 '16 at 17:32
  • 1
    And did you drop or delete from the table? Did you use DROP TABLE t; or DELETE FROM t ;? If you used DELETE inside a transaction, you can of course ROLLBACK the transaction and everything will be fine. – ypercubeᵀᴹ Feb 17 '16 at 17:38
  • dropped the table – Hari Shankar Feb 17 '16 at 17:39
  • 2
    Read this answer: Is there a way to recover a dropped mysql database? – ypercubeᵀᴹ Feb 17 '16 at 17:41

Browse other questions tagged or ask your own question.