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

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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