Table Consistency/analize/check/repair

2010-06-18 Thread Steven Staples
Hello, I had an issue yesterday, where one of my tables ended up being closed improperly, and needed to be repaired. This isn't really an issue in itself, but I didn't know about it until 2 hours after it happened, and a script was trying to write to that table, and it failed, which caused a

Re: Table Consistency/analize/check/repair

2010-06-18 Thread a . smith
this built in command is probably a good start: http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Table Consistency/analize/check/repair

2010-06-18 Thread Prabhat Kumar
might be this will help you. http://adminlinux.blogspot.com/2010/05/mysql-checking-and-reparing-tables.html On Fri, Jun 18, 2010 at 6:59 PM, a.sm...@ukgrid.net wrote: this built in command is probably a good start: http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html -- MySQL