Million Dollar Script

You can help!

Donations help improve software by giving developers more time to work on it. Every bit helps, no matter how small.

Amount: 

Welcome, Guest
Username Password: Remember me

Can't create/write to file '/var/lib/mysql/tmp/#sq
(1 viewing) (1) Guest
  • Page:
  • 1

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

Can't create/write to file '/var/lib/mysql/tmp/#sq 1 year, 3 months ago #334

  • drkpy
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
Can't create/write to file '/var/lib/mysql/tmp/#sql_10d5_0.MYI' (Errcode: 2)

how to solve this problem

Re: Can't create/write to file '/var/lib/mysql/tmp/#sq 1 year, 3 months ago #338

  • Ryan
  • OFFLINE
  • Administrator
  • Posts: 208
  • Karma: 7
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.

dev.mysql.com/doc/refman/5.0/en/cannot-create.html
  • Page:
  • 1
Time to create page: 0.13 seconds