Results 1 to 2 of 2
  1. #1
    Join Date
    May 2013

    Unhappy Unanswered: How to recover data for any failed operation

    Hello Everyone,

    Suppose I am using any DBMS such as oracle, Microsoft sql server or MySQL. Again suppose i am doing any operation such as inserting new data or select query and my this operation fails. How to recover this data?



  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    If your database is using the Innodb engine, you can use BEGIN TRANSACTION and ROLLBACK TRANSACTION.

    If your database is not using InnoDB, I don't know of any way to recover the data other than going back to a known good backup that has the missing data and restoring it manually.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts