List:General Discussion« Previous MessageNext Message »
From:Gregory Machin Date:March 22 2007 4:02pm
Subject:Re: database corruption ? how to fix ?
View as plain text  
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 <jspilon@stripped> 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:gregory.machin@stripped]
> > 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
> >
> > [root@www 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
> > gregory.machin@stripped
> > www.linuxpro.co.za
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=1on@stripped
> >
> >
> 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 un virus.
>


-- 
Gregory Machin
gregory.machin@strippedm
www.linuxpro.co.za
Thread
database corruption ? how to fix ?Gregory Machin22 Mar
  • RE: database corruption ? how to fix ?Jean-Sebastien Pilon22 Mar
    • Re: database corruption ? how to fix ?Gregory Machin22 Mar
      • RE: database corruption ? how to fix ?Jean-Sebastien Pilon22 Mar
        • Re: database corruption ? how to fix ?Michael Dykman22 Mar