Favourite Host

RunCloud (free 5 day trial)

Install Service

Premium Support


Login or register to post.

Can't create/write to file '/var/lib/mysql/tmp/#sq

Can't create/write to file '/var/lib/mysql/tmp/#sql_10d5_0.MYI' (Errcode: 2)how to solve this problem

Looks like your mysql can't write to its temp file.It could be caused by improper file permissions or wrong temp folder setting, services running under a wrong/unexpected username, or maybe your temp disk is out of space.http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html