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?