Re: myisamchk and table corrupt

2002-03-25 Thread Mr. Ozette Brown
Patrick, Try this from your shell: You want to flush the tables (I'm assuming you want to keep the database up and running), do a recover, safe recover, and check to make sure you don't get the error messages when everything is finished. $ mysqladmin flush-tables $ myisamchk -r -o /var/lib/mys

myisamchk and table corrupt

2002-03-24 Thread Patrick Hsieh
Hello list, There's an corruption in my mysql table. I tried to use myisamchk -o to recovery, but still exists when I use myisamchk -s. What is the possible reason of the problem? linux95:/var/lib/mysql# myisamchk -s stocks/TimelyDeals.MYI myisamchk: ISAM file stocks/TimelyDeals.MYI myisamchk: