The path myisamchk is reporting do look a bit funny... is this you own users table or the mysql users table?
You might want to check you my.cnf file to see if different data directories have been specified under the various tools headings. - michael On 3/22/07, Jean-Sebastien Pilon <[EMAIL 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 > 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 PROTECTED]> wrote: > > - 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 > > > Subject: database corruption ? how to fix ? > > > > > > hi > > > when i try and do a mysqldump of the databases it exites with > > > this error > > > > > > [EMAIL PROTECTED] diaendomet]# mysqldump -ucojjohealth -p > --all-databases > > > > alldatabases.sql > > > Enter password: > > > mysqldump: Got error: 29: File '../diaendomet/users.MYD' not found > > > (Errcode: 2) when using LOCK TABLES > > > > > > so i ran > > > > > > mysqlcheck --all-databases --auto-repair -ucojjohealth -p > > > > > > and now i get the following > > > > > > error : File '../diaendomet/users.MYD' not found (Errcode: 2) > > > > > > what do i do next ? > > > > > > many thanks > > > -- > > > Gregory Machin > > > [EMAIL PROTECTED] > > > www.linuxpro.co.za > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > NOTICE: This email contains privileged and confidential > information and is intended only for the individual to whom > it is addressed. If you are not the named addressee, you > should not disseminate, distribute or copy this e-mail. > Please notify the sender immediately by e-mail if you have > received this transmission by mistake and delete this > communication from your system. E-mail transmission cannot be > guaranteed to be secured or error-free as information could > be intercepted, corrupted, lost, destroyed, arrive late or > incomplete, or contain viruses. > > > > AVIS: Le présent courriel contient des renseignements de > nature privilégiée et confidentielle et n'est destiné qu'à la > personne à qui il est adressé. Si vous n'êtes pas le > destinataire prévu, vous êtes par les présentes avisés que > toute diffusion, distribution ou reproduction de cette > communication est strictement interdite. Si vous avez reçu ce > courriel par erreur, veuillez en aviser immédiatement > l'expéditeur et le supprimer de votre système. Notez que la > transmission de courriel ne peut en aucun cas être considéré > comme inviolable ou exempt d'erreur puisque les informations > qu'il contient pourraient être interceptés, corrompues, > perdues, détruites, arrivées en retard ou incomplètes ou > contenir un virus. > > > > > -- > Gregory Machin > [EMAIL PROTECTED] > www.linuxpro.co.za > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
