News:

CPG Release 1.6.31
Minor maintenance release
Clean up remaining remnants of the .net CPG website
Improved installer_stub compatibility with various server configurations

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.

kegobeer

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