MySQL - Invalid query: Can't create/write to file \tmp\x (Errcode: 13) - Databases forum at WebmasterWorld

Forum Moderators: open

Message Too Old, No Replies

MySQL - Invalid query: Can't create/write to file \tmp\x (Errcode: 13)

andytwiz

8:40 pm on Mar 26, 2007 (gmt 0)

Hi,

Really not sure what is the sudden cause of this sparadic error I'm seeing a few times everyday on my Windows 2003, Apache 2.2 MySQL 5.027 server.

MySQL - Invalid query: Can't create/write to file \tmp\x (Errcode: 13)

I've searched Google and all I've been able to come up with is others with the same problem, but with no known solution.

This issue does NOT occur most of the time. Any ideas?

Thanks

Clark

9:43 pm on Mar 26, 2007 (gmt 0)

Is your hard drive full? Check how much space you have in the directory where your mysql databases are kept. Turn on slow query logging and see if there's a query that comes back slowly. Double check nightly processes. You might have a situation w/ a temporary hard drive full problem.

Edit: Just googled this and someone found that this happened after a mysql upgrade. Permission problem in the /tmp directory.

Try this:

sudo chown -R mysql /usr/local/mysql/*

[edited by: Clark at 9:45 pm (utc) on Mar. 26, 2007]