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

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