Percona Data Recovery Tool for InnoDB

Lost database, have ibdata1, ib_logfile0, ib_logifle1 but can't recover it.

Asked by Alexandre Meneses de Melo

Hi, I'm trying to recover my lost database by setting innodb_force_recovery=1 (or higher) and restarting the server because I only have left these 3 files: ibdata1, ib_logfile0, ib_logifle1.

No success until now. I downloaded Percona Data Recovery Tool, but don't know how to use it (don't even know how to install - I'm not familiar with anything besides win.)

Is there anything I can do?

Thanks,
Alex

Question information

Language:
English Edit question
Status:
Expired
For:
Percona Data Recovery Tool for InnoDB Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Alexandre Meneses de Melo (meneses66) said : 		#1

Additionally, this is the error when I try to use innodb_force_recovery=1 (or higher).

[ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file E:\A.MELO1\DataDir\ibdata1 are 0x4800!
2019-06-18 11:41:42 0x5fd8 InnoDB: Assertion failure in thread 24536 in file ut0ut.cc line 916

Revision history for this message
Launchpad Janitor (janitor) said : 		#2

This question was expired because it remained in the 'Open' state without activity for the last 15 days.