forum.coppermine-gallery.net
No Support => General discussion (no support!) => Topic started by: kegobeer on August 28, 2004, 04:00:15 pm
-
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.