How to Repair Corrupted MySQL (MyISAM) Table

Platform: Windows (should work on Linux)
Database name: activity
Table name: mamain

1. Copy myisamchk.exe to database folder

C:\xampp\mysql\bin>copy myisamchk.exe ..\data\activity

2. Run the executable

C:\xampp\mysql\bin>cd ..\data\activity
C:\xampp\mysql\data\activity>myisamchk -r mamain
- recovering (with sort) MyISAM-table 'mamain'
Data records: 81619
- Fixing index 1
Data records: 81618

3. Finish

Note: Make sure you have turned off the MySQL before execute the .exe file

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.