How do I recover a broken table?
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 tried to use the analyze and recover commands but I only get the message that the table doesn't support these commands. Happy for any help I can get to try recover the table without having to read out all the data and recreate the table. /Magnus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How do I recover a broken table?
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 [EMAIL PROTECTED] wrote: 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 tried to use the analyze and recover commands but I only get the message that the table doesn't support these commands. Happy for any help I can get to try recover the table without having to read out all the data and recreate the table. /Magnus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Broken table
Hello! :) One of my table suddunly stop working when I try to execute SQL statement it'returns error msg: Got error 127 from table handler Is there a way to repair it. The information in this table i very important for me. Thank you. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Broken table
Konstantin, Wednesday, May 22, 2002, 2:02:42 PM, you wrote: KY One of my table suddunly stop working when I try to KY execute SQL statement it'returns error msg: KY Got error 127 from table handler KY Is there a way to repair it. The information in this KY table i very important for me. Sure. Use myisamchk utility or REPAIR TABLE. For more info about repairing tables look at: http://www.mysql.com/doc/R/e/Repair.html about myisamchk: http://www.mysql.com/doc/T/a/Table_maintenance.html about REPAIR TABLE at: http://www.mysql.com/doc/R/E/REPAIR_TABLE.html KY Thank you. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php