Tag

innodb_force_recovery

0 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 15, 2020 · Databases

MySQL Crash After Hardware Replacement: Missing MLOG_CHECKPOINT Redo Log and Recovery Procedure

After replacing a MySQL server's CPU and motherboard, the instance fails to start due to a missing MLOG_CHECKPOINT marker in the redo log, and the article explains the underlying cause, recovery options using innodb_force_recovery levels, and step‑by‑step data restoration.

Database AdministrationInnoDBMySQL
0 likes · 4 min read
MySQL Crash After Hardware Replacement: Missing MLOG_CHECKPOINT Redo Log and Recovery Procedure
360 Quality & Efficiency
360 Quality & Efficiency
Jun 11, 2018 · Databases

Recovering a Crashed MySQL Server Using innodb_force_recovery and Data Export/Import

This article walks through diagnosing a MySQL crash, using innodb_force_recovery to start the server, exporting the data with mysqldump, handling charset mismatches, importing into a new instance, and restoring normal operation while offering best‑practice backup recommendations.

BackupCharsetDatabase Recovery
0 likes · 5 min read
Recovering a Crashed MySQL Server Using innodb_force_recovery and Data Export/Import