Re: Corrupted table
I switched the tmp directory to a much bigger partition and I am still getting the error. Any other ideas? TIA, Zak --- On Wed, 3/10/10, Walter Heck wal...@openquery.com wrote: From: Walter Heck wal...@openquery.com Subject: Re: Corrupted table To: Zakai Kinan titanyen2...@yahoo.com Cc: mysql@lists.mysql.com Date: Wednesday, March 10, 2010, 8:29 AM That message usually means you ran out of space in your temp folder location. cheers, Walter Heck -- Engineer @ Open Query http://openquery.com | http://openquery.com/blog On Thu, Mar 11, 2010 at 02:16, Zakai Kinan titanyen2...@yahoo.com wrote: Is there a way to know exactly which table is corrupted with such an error: [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_7885_0.MYI'; try to repair it. TIA, ZK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=titanyen2...@yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Corrupted table
That message usually means you ran out of space in your temp folder location. cheers, Walter Heck -- Engineer @ Open Query http://openquery.com | http://openquery.com/blog On Thu, Mar 11, 2010 at 02:16, Zakai Kinan titanyen2...@yahoo.com wrote: Is there a way to know exactly which table is corrupted with such an error: [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_7885_0.MYI'; try to repair it. TIA, ZK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
re: Corrupted Table (?)
Philip, Tuesday, October 01, 2002, 5:49:47 PM, you wrote: PD I have a table which was accessible for the last couple years but is now PD inaccessible after performing a simple alter table command. PD There are approx. 10 tables in this database on which the same alter table PD command was given (alter table table_name add glperiod varchar (3) null PD first;). All of these tables are O.K. (and were correctly altered) except 1. PD What happens is that whenever I try to perform an SQL command against this PD table (called codeprojects), either MySQL hangs (at the command prompt) PD or my perl script hangs in the $sth-execute($sql) statement. Like I PD said, all of these methods, etc. worked on this table in the past and still PD work on the rest of the tables. PD I've tried, restarting MySQL (which seemed to work at first but now does PD not), dropping and rebuilding the table (it hangs on the drop command), PD copying a working copy of the three table files from a backup database, PD deleting the three files and starting over again. Nothing has worked so far. PD Any ideas?? PD OS: Redhat 7.1 Linux PD MySQL: 3.23.41 Use CHECK table to see if the table is corrupted. If so you should repair it with REPAIR TABLE or myisamchk: http://www.mysql.com/doc/en/Repair.html -- 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
Re: corrUPted tabLE questions...
Jim Ray, @WD writes: I have a tabel that seems to be corrupted. Is there a way to fix it? It is running on a Lynx box. Atari Lynx? Does MySQL really run on that? Or did you mean Linux? Hmm... Anyway, look in the manual. REPAIR TABLE is good place to start, as is myisamchk. And make sure that you don't repeat whatever you did to get the table corrupted. killall -9 mysqld is a BAD idea, as is messing with the table files when mysqld is running. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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