Toubleshooting InnoDB corruption


Browse by products and services

  • Applies to: Grid
    • Difficulty: Medium
    • Time Needed: 20
    • Tools Required: Account Center access
  • Applies to: DV
    • Difficulty: Medium
    • Time Needed: 20
    • Tools Required: Account Center access

Introduction

The following article contains information on troubleshooting an innodDB corruption issue.

Please keep in mind that troubleshooting the configuration/functionality of third-party applications is not covered by our statement of support. These resources were provided as a courtesy to assist you to the extent of our abilities. For more information on our statement of support, feel free to click here.

Instructions

1. Ensure that force innodb recovery is enabled:

Click on the blue Admin button next to your Grid server.
grid1.png

Located under Databases, select GridContainers.
grid2.png

Click on Manage.
grid3.png

Scroll down to MySQL Config. Then select Edit Config.
grid4.png

You wish to keep a copy of your config file, copy/pate the data into a text editor.

Insert the following: innodb_force_recovery=1
(you may also use alternative numbers should 1 not be successful).

Then select Save Config.


grid5.png

2. Export all of your database.
3. Reset the my.cnf file on your Grid Container:

Go to Edit Config outlined in Step 1.
Select Revert To Original.
Then select Save Config.

4. Drop the databases from MySQL.
5. Re-import the databases.

If you require a fresher on exporting and re-importing your databases, feel free to review our community article:

Export and Import MySQL Databases

Instructions

The process to dealing with innodb corruption generally entails the following:

  1. Backup all of the databases
  2. Force innodb recovery via the my.cnf file.
  3. Drop all tables in the databases.
  4. Restore/Re-import the databases.

If you require a fresher on exporting and re-importing your databases, feel free to review our community article:

Export and Import MySQL Databases

Below is reputable third-party documentations from Plesk and cPanel which provide more detailed information on the exact commands and steps that can be taken. However, please bear in mind the links below are from non-Media Temple sources and are to be used at your own discretion.