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.