Web Hosting Geeks | Web Hosting Experts
Need help? Call us 1(866)TOP-HOST

14611 reviews 1734 hosting providers

Questions & Answers

Invalid or corrupt MySQL table

Jun 2, 2012 by carebare
Hi there,

when I run any query I get a error message telling me that I have a corrupt or invalid MySQL table. I checked my tables and everything looks fine. Can someone please tell me what should I do?

thanks

2 Answers

0 votes
Jun 2, 2012 by FixHost
do the following;
1.Use SSH to login to MYSQL server
2.From shell prompt type’’mysqlcheck—auto-repair[database name]
3.This utility will now run automatic check and repair in the specified database and it will report results.
0 votes
Jun 2, 2012 by expert
if your working on a Linux server, try this code at the shell cd /var/lib/mysql/[database name]
myisamchk -r *.MYI