LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-14-2008, 09:21 AM   #1
poonippi
Member
 
Registered: Dec 2007
Distribution: Debain Fluxbox
Posts: 76

Rep: Reputation: 15
MySQL Incorrect key file


I've recently run out of disk space on my hobby server, which seemed to cause problems with mail, probably delivering them.

I've got Postfix and Dovecot installed, with a MySQL backend, so I thought I'd have a look around MySQL tables.

Firstly, either I couldn't remember the MySQL root password or it had some how been corrupted. I managed to reset the password, but now after restarting MySQL I get the following error:

ERROR 126 (HY000) at line 1: Incorrect key file for table '/tmp/#sql_7e1b_0.MYI'; try to repair it

Thanks
 
Old 12-14-2008, 11:05 PM   #2
lineman60
Member
 
Registered: Oct 2003
Location: New Mexico
Distribution: CentOS, Ubnutu,
Posts: 35

Rep: Reputation: 15
no idea if this will help... but,
Have you tryed repairing mysql?
I tend to cheat and use mysql admin, but you can do a repair on the tables from the CLI. Also do a mysql dump (make a copy) of your data before you even think about trying it.

http://dev.mysql.com/doc/refman/5.1/...air-table.html
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
windows fonts file names incorrect edM Slackware 1 11-19-2007 05:49 PM
MySQL: Incorrect key file for table ??? BrianK Programming 2 01-31-2007 11:00 AM
mysql crash on startup: Incorrect file format 'host' cptnapalm Linux - Software 3 08-04-2006 12:10 AM
incorrect character for the log file treotan Red Hat 1 12-05-2005 09:21 PM
Bad Key / No Key Error MySql wasabi Linux - Software 1 04-19-2005 06:06 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:32 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration