My mysql is 3.23.42 I use the mysqlcheck -A to check my database first, it report ok
and then I try the myisamchk use it as: myisamchk /var/lib/mysql/*/*.MYD it report: myisamchk: error: -1 when opening MyISAM-table '/var/lib/mysql/xx/dd.MYD' myisamchk: error: '/var/lib/mysql/xx/cc.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repare then I use mysqlcheck again, it report ok again. Is my db error? Why the mysqlcheck is report ok? Or my operation is not correct? Thank in advance. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php