Mistakenly I have deleted "ibdata1" file in mysql server. Now my database is not working. All the tables are corrupted. But still I have "ib_logfile0" and "ib_logfile1" files.Also I have a recent backup of my database (2014/02/01). So I want to know can I be able to recover the database uptodate using "ib_logfile0" , "ib_logfile1" and recent backup ? I will be glad if someone can give me any idea. I am running on linux.

  • If found Googling "mysql recovery deleted ibdata1" helpful. Led me here (which you may find interesting) dba.stackexchange.com/questions/57120/…. What have you tried so far? BTW, 2014/02/01 is _not_ a recent backup! You could also <gasp...> RTF(ine)Manual here dev.mysql.com/doc/refman/5.0/en/point-in-time-recovery.html inter alia. – Vérace May 30 '14 at 9:16
  • I have tried googling. But I couldn't find anything. What I want to know is. Is there any possibility to recover a database without "ibdata1" file. – Evo SL May 30 '14 at 10:52
  • Try here for an answer (appears to be yes). Percona are pretty good for MySQL related material. mysqlperformanceblog.com/2011/06/03/… – Vérace May 30 '14 at 11:02
  • Thank you for the answer. I will try this out, will post the result here. – Evo SL May 30 '14 at 12:56
  • ib_logfile* don't keep any data, but recent changes. Take an image of your disk ASAP and then go to percona.com/docs/wiki/… (you'd need page_parser to find innodb pages on disk and constraints_parser to fetch records from the pages) – akuzminsky May 30 '14 at 21:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.