Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How do you fix a MySQL "Incorrect key file" error when you can't repair the table?

Tags:

mysql

mysql-error-126

I'm trying to run a rather large query that is supposed to run nightly to populate a table. I'm getting an error saying Incorrect key file for table '/var/tmp/#sql_201e_0.MYI'; try to repair it but the storage engine I'm using (whatever the default is, I guess?) doesn't support repairing tables.

how do I fix this so I can run the query?

like image 975
Wayne Molina Avatar asked Mar 11 '10 21:03

Wayne Molina

People also ask

What is MySQL error?

Lost connection to MySQL server Network conditions should be checked if this is a frequent error. If an error message like “Lost connection to MySQL server” appears while querying the database, it is certain that the error has occurred because of network connection issues.

1 Answers

You must change the location of MySQL's temporary folder which is '/tmp' in most cases to a location with a bigger disk space. Change it in MySQL's config file.

Basically your server is running out of disk space where /tmp is located.

like image 123
marknt15 Avatar answered Sep 22 '22 10:09

marknt15
Sign in to Comment

Related questions

MySQL - How to parse a string value to DATETIME format inside an INSERT statement?
Best MySQL performance tuning tool? [closed]
Facebook user_id : big_int, int or string?
What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?
MySQL INSERT IF (custom if statements)
Calling a Stored Procedure in a Stored Procedure in MySQL
PHP PDO vs normal mysql_connect
MySQL Group By and Sum total value of other column
How do I find if my a table is MyISAM or Innodb [duplicate]
How to delete a range of records at once on MySQL?
PHP, MySQL error: Column count doesn't match value count at row 1
Indexes and multi column primary keys
MySQL select records for duplicates using multiple columns
Can you split/explode a field in a MySQL query?
Sorting by date & time in descending order?
MySQL timezone change?
How to populate a table with a range of dates?
mysql error : ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)
How can I see how many MySQL connections are open?
MySQL - How to select rows where value is in array?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!