Hello.


Have you stopped MySQL server before executing myisamchk?





sirisha gnvg <[EMAIL PROTECTED]> wrote:

> [-- text/plain, encoding 8bit, charset: iso-8859-1, 21 lines --]

> 

> hello everybody,

> 

>     I used myisamchk  /path/to/datadir/mysql/*.*  to find memory already in 
> use and free memory available for all tables in 'mysql' database.where mysql 
> in above path refers to mysql database.

> 

> I got two types of errors for all tables in that directory.

> 

> They are

> myisamchk:error: -1 when opening myisam_table 'abcd.MYD'

> 

> myisamchk1 error:'abcd.frm' doen't have a correct index definition.You need 
> to create it before u can do a repair.I am using Red hat linux mysql version.

> 

> Please give more information about these errors and the ways to rectify them.

> 

> Thank you,

> 

> yours,

> sirisha.

> 

> 

> 

> Yahoo! India Matrimony: Find your life partneronline.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to