News:

CPG Release 1.6.29
During HTML5 upload, keep pseudo blank code 200 messages from triggering error condition
added Russian language
correct failure to use theme menu icons in album manager
minor vulnerabilities mitigation

Main Menu

Typical Error: Can't create/write to file '/tmp/#sql_45d5_0.MYI'

Started by kegobeer, August 28, 2004, 04:00:15 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

kegobeer

August 28, 2004, 04:00:15 PM Last Edit: May 15, 2006, 08:00:57 AM by GauGau
The error:

Can't create/write to file '/tmp/#sql_45d5_0.MYI'

The problem:

MySQL can't create a temporary file for the result set in the given temporary directory.

The solution:

Alter the tmpdir variable to point to a writable directory.  It requires changing the tmpdir line in the my.cnf file, usually in the [mysqld] section (tmpdir = /writable/dir, where /writable/dir is a directory to which you can write).

Ask your webhost to make the above changes.
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots
Print
Go Up Pages1
User actions