- Stop you mysql server
- change working directory to $MYSQL_DATA_DIR
- run myisamchck with */*.MYD
This will run a check on all your table files
-Original Message-
From: Gregory Machin [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 22, 2007 8:41 AM
To: mysql@lists.mysql.com
it gives
the following errors for all the databases ..
myisamchk: error: './diaendomet/users.MYD' is not a MyISAM-table
myisamchk: error: './diaendomet/users.MYD' is not a MyISAM-table
phpmyadmin reports the tables as being MyISAM..
any sugetions
On 3/22/07, Jean-Sebastien Pilon [EMAIL
Sorry it is */*.MYI instead of */*.MYD
-Original Message-
From: Gregory Machin [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 22, 2007 12:02 PM
To: Jean-Sebastien Pilon
Cc: mysql@lists.mysql.com
Subject: Re: database corruption ? how to fix ?
it gives
the following errors
PROTECTED] wrote:
Sorry it is */*.MYI instead of */*.MYD
-Original Message-
From: Gregory Machin [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 22, 2007 12:02 PM
To: Jean-Sebastien Pilon
Cc: mysql@lists.mysql.com
Subject: Re: database corruption ? how to fix ?
it gives