What to Do If MySQL Tables Are Corrupted

MySQL tables (authorization database) may be lost, due to disk corruption, system failure, etc.
If you cannot import dumped data (data retrieved using mysqldump) due to corruption of a MySQL table, you can retrieve MySQL data from another system, and then restore the backed up data.

Image describing how to deal with them

Steps:

  1. Prepare a new server and install Garoon.

  2. Back up the Garoon data that you installed in step 1 using the OS commands, and obtain a known-good MySQL table.

    For details, see the "Backing up Garoon Using OS Commands" section.

  3. Using the OS commands, restore the data from the normal MySQL table retrieved in step 2 to the Garoon server where the MySQL table is corrupted.

    For details, see the "Restoring Garoon Using OS Commands" section.

  4. On the Garoon server where the table is corrupted, restore the data that you have backed up using mysqldump.

    For details, see the "Restoring Garoon Using mysqldump" section.