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]