Corrupt tables after restoring entire MySQL data directory from xtrabackup

Hi All,

Our server was forcefully shutdown and rebooted in the early hours of Saturday morning and as such corrupted some of our MySQL (MariaDB) data, namely the ib* files.

Currently we have innodb_force_recovery=6 and innodb_purge_threads=0.

Our logs are full of:

I have backups using Xtrabackup nightly, so that’s not an issue. The issue is restoring these. I put all the data back but MySQL errors out and doesn’t seem to be able to start without an innodb_force_recovery option, probably because it’s missing ib_logfile0 and ib_logfile1 files?

Any ideas how I can go about getting this database back up and running? :frowning:

can you please share what errors you got during backup restore ? What are your steps to restore database ?
Do you able to dump database tables backup via mysqldump after restore ?