How do I recover a broken table?

2002-08-27 Thread magnus.s
Hi I have a table that returns the following error message as soon as I run a query that reads out more then 300 posts from the table ERROR 1030: Got error -1 from table handler The strange part is that the table works without any problem except when I try to select more then 300 posts. I have

Re: How do I recover a broken table?

2002-08-27 Thread Iikka Meriläinen
Hello, If you're using MyISAM tables, shut down your server and run myisamchk For example, myisamchk \mysql\data\dbname\*.MYI See the MySQL Technical Reference for detailed syntax and usage information. However, it seems like your table is corrupted, indeed. Regards, Iikka On Tue, 27 Aug 2002