RE: database corruption ? how to fix ?

2007-03-22 Thread Jean-Sebastien Pilon
- 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

Re: database corruption ? how to fix ?

2007-03-22 Thread Gregory Machin
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

RE: database corruption ? how to fix ?

2007-03-22 Thread Jean-Sebastien Pilon
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

Re: database corruption ? how to fix ?

2007-03-22 Thread Michael Dykman
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