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:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

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