How to check, repair, and optimize MySQL database tables?
1. From Windows All programs look for MySQL folder then click it.
2. Look for MySQL administrator then click it.
3. Enter your server name (computer name of the server), username=root; password (password you provided when you are installing mysql server).
4. From MySQL Administrator menu, click Catalogs
5. Select your database (ex. rdadb).
6. click Maintenance button
7. Click Check tables radio button then click Next button
8. Let the Medium radio button checked, Click Check Tables button
9. Afterwards, click Close button
10. Click Maintenance button again
11. Click Repair tables radio button then click Next button
12. Check checkbox Use FRM, Click Repair Tables button
13. Afterwards, click Close button again
14. Click Maintenance button again
15. Click Optimize Tables radio button then click Next button
16. Then Click Optimize Tables button
17. Afterwards, click Close button.
18. Click Refresh
2. Look for MySQL administrator then click it.
3. Enter your server name (computer name of the server), username=root; password (password you provided when you are installing mysql server).
4. From MySQL Administrator menu, click Catalogs
5. Select your database (ex. rdadb).
6. click Maintenance button
7. Click Check tables radio button then click Next button
8. Let the Medium radio button checked, Click Check Tables button
9. Afterwards, click Close button
10. Click Maintenance button again
11. Click Repair tables radio button then click Next button
12. Check checkbox Use FRM, Click Repair Tables button
13. Afterwards, click Close button again
14. Click Maintenance button again
15. Click Optimize Tables radio button then click Next button
16. Then Click Optimize Tables button
17. Afterwards, click Close button.
18. Click Refresh