MySQL Fails to Start After Reboot – InnoDB Corruption Detected

Hello

After rebooting my server, MySQL refuses to start in HestiaCP. Checking the logs at /var/log/mysql/error.log, I see several errors related to InnoDB corruption; :innocent: including:
InnoDB: Page corruption detected at page 1678953
InnoDB: Cannot continue operation due to corruption

Before the reboot, MySQL was functioning without issues, so I suspect an unclean shutdown or possible disk-related problems. I’d like to avoid unnecessary downtime and data loss while attempting to repair the database. :upside_down_face:

I have already tried the following steps:

  1. Running mysqlcheck --all-databases --auto-repair, but it fails due to InnoDB corruption.
  2. Adding innodb_force_recovery=1 in /etc/mysql/my.cnf, but MySQL still does not start.
  3. Checking available disk space and file system integrity—everything seems fine.
  • What is the safest way to repair InnoDB tables without causing further damage?
  • Should I attempt higher innodb_force_recovery levels (e.g., 3 or 5), or could that lead to permanent data loss? :thinking:
  • Would a complete database restore from backups be the best solution at this point?:thinking:

Checked https://mariadb.com/kb/en/innodb-recovery-modes-Splunk guide for reference and found it quite informative.
Any guidance or best practices from those who have encountered this issue would be greatly appreciated!

Thank you!! :slightly_smiling_face: