Fix corrupted MySQL tables through DirectAdmin.
Steps
- DirectAdmin → MySQL Management
- Check box next to database(s)
- Click Check/Repair
- Review results
What It Does
Runs MySQL commands:
- CHECK TABLE - Identifies problems
- REPAIR TABLE - Fixes corruption
- OPTIMIZE TABLE - Reclaims space
When to Use
- Database connection errors
- "Table crashed" messages
- Missing or corrupted data
- After server crash
- Slow queries
Alternative: phpMyAdmin
- MySQL Management → phpMyAdmin
- Select database
- Check all tables
- Choose "Repair table" from dropdown
Before Repairing
- Create backup first
- Note which tables have issues
- Check available disk space
Still Having Issues?
Try:
- OPTIMIZE instead of REPAIR
- Drop and recreate table (data loss)
- Restore from backup
- Check error logs for details
Common Messages
- "OK" - Table is fine
- "Table is already up to date" - No repair needed
- "Repaired" - Fixed successfully
- "Failed" - Manual intervention needed
