Daily Archives: November 2, 2011

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…