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

Improve this question
5
  • 1
    Question 1: do you have backups? Question 2: Have you tested them?
    – ypercubeᵀᴹ
    Commented Feb 17, 2016 at 17:16
  • no i don't have backups, tested means
    – Hari Shankar
    Commented Feb 17, 2016 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ᵀᴹ
    Commented Feb 17, 2016 at 17:38
  • dropped the table
    – Hari Shankar
    Commented Feb 17, 2016 at 17:39
  • 2
    Read this answer: Is there a way to recover a dropped mysql database?
    – ypercubeᵀᴹ
    Commented Feb 17, 2016 at 17:41

0

Reset to default

Browse other questions tagged or ask your own question.