Repeated table crashes (Errno 145). Why?

2004-02-12 Thread Andrew Iles
Hi, Recently I've been seeing the following kind of error message for several of the MyISAM tables in my database: General error: Can't open file: 'build_packages.MYI'. (errno: 145) Running a simple repair operation on the corrupted table will make MySQL happy again, even though the repair

Re: errno: 145

2002-05-24 Thread Egor Egorov
Anil, Thursday, May 23, 2002, 8:30:33 PM, you wrote: AG when i try to read a table using query AG select * from table name AG it shows following error: AG cant open file:'anil.MYD'.(errno: 145) AG y such an error can come!! AG earlier it was fine. # perror 145 Error code 145: Unknown error

errno: 145

2002-05-23 Thread Anil Garg
hi when i try to read a table using query select * from table name it shows following error: cant open file:'anil.MYD'.(errno: 145) y such an error can come!! earlier it was fine. thanx for help anil - Before posting