MySQL:表'/tmp/#sql_185e_0.MYI'的密钥文件不正确;尝试修复它 [英] MySQL: Incorrect key file for table '/tmp/#sql_185e_0.MYI'; try to repair it
本文介绍了MySQL:表'/tmp/#sql_185e_0.MYI'的密钥文件不正确;尝试修复它的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Incorrect key file for table '/tmp/#sql_185e_0.MYI'; try to repair it
此错误是什么意思?
"Incorrect key file for table '/tmp/#sql_185e_0.MYI'; try to repair it"
我正在命令行中使用PHP在表中插入40万条记录(每批25k). 如果我仅插入1k条记录,则不会产生MySQL错误.
I'm inserting 400k records in a table by 25k per batch using PHP in command line. If I inserted only 1k records then it will not produce the MySQL error.
该错误是否表示我的服务器没有更多的磁盘空间?
Does the error mean that my server has no more disk space?
谢谢.
推荐答案
根据google-此错误通常与临时目录所在的驱动器空间不足有关.
According to google - this error often related to not enough space for the drive your temporary directory is located at.
这篇关于MySQL:表'/tmp/#sql_185e_0.MYI'的密钥文件不正确;尝试修复它的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文