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.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when possible)

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