1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Recovering from a Table Drop in MySQL

Discussion in 'MySQL Forums' started by prashant, Oct 17, 2013.

  1. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
    MySQL Version: 5.5.28
    OS: Linux (centOS 6.3)
    Engine: innoDB
    innodb_files_per_table=1

    Hello Guys,

    In one of our Lab Setup a user has accidently dropped a table. Is there a way to recover the table?

    There is no backup available. I would like to know if there is a feature similar to flashback in MySQL.

    Thank you.

    Best Regards,
    Prashant
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
  3. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
    Thanks Jagadekara for your inputs!

    Yesterday I tried File recovery from Test Disk and was able to successfully recover the files. Post that I followed the below link for recovery:-

    http://www.chriscalender.com/?p=28


    The whole process was highly complex. So, just wanted to know if there is a feature similar to Flashback in MySQL which could be enabled to reduce the complexity by many folds.

    Best Regards,
    Prashant
     
    jagadekara likes this.
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Oh! good Prashant..