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; 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.
I have already tried the following steps:
- Running
mysqlcheck --all-databases --auto-repair
, but it fails due to InnoDB corruption. - Adding
innodb_force_recovery=1
in/etc/mysql/my.cnf
, but MySQL still does not start. - 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
or5
), or could that lead to permanent data loss? - Would a complete database restore from backups be the best solution at this point?
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!!