Title: tmp file error
Last modified: August 18, 2016

---

# tmp file error

 *  Anonymous
 * [22 years ago](https://wordpress.org/support/topic/tmp-file-error/)
 * Hi,
    I have just got WordPress running, but when I browsed to index.php using
   my browser, the following error message appeared on the right hand column : QL/
   DB Error: [Can’t create/write to file ‘/tmp/#sql_111_0.MYI’ (Errcode: 28)] SELECT
   DISTINCT link_category, cat_name, show_images, show_description, show_rating,
   show_updated, sort_order, sort_desc, list_limit FROM `wp_links` LEFT JOIN `wp_linkcategories`
   ON (link_category = cat_id) WHERE link_visible = ‘Y’ ORDER BY cat_name Can anyone
   direct me to the relevant files so that I can manually edit the path of the temp
   file to some where with the correct permissions? Thanks a lot!

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Moderator [Matt Mullenweg](https://wordpress.org/support/users/matt/)
 * (@matt)
 * [22 years ago](https://wordpress.org/support/topic/tmp-file-error/#post-43962)
 * That is a MySQL error, you might want to try searching MySQL forums or documentation
   for better guidance. It sounds like it’s having trouble creating temporary tables.
 *  [macangel](https://wordpress.org/support/users/macangel/)
 * (@macangel)
 * [21 years, 12 months ago](https://wordpress.org/support/topic/tmp-file-error/#post-44050)
 * I had that problem and it was a file that the server admin had to deal with. 
   Write t your web host and tell them about it. They should be able to correct 
   it for you. It is related to other sites on the save server filling up the tmp
   file.
 *  Thread Starter Anonymous
 * [21 years, 6 months ago](https://wordpress.org/support/topic/tmp-file-error/#post-44587)
 * My host disabled my account because I was supposedly creating wierd files in 
   the /TMP directory. Is this caused by wordpress?
 *  [moshu](https://wordpress.org/support/users/moshu/)
 * (@moshu)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/tmp-file-error/#post-44588)
 * Very unlikely that is caused by WP. The number of total wordpress blogs is (was?)
   24219 and increasing…
    [http://wordpress.org/support/7/13002](http://wordpress.org/support/7/13002)
   and they do not report “weird” files. Try to work out with your host what was
   the problem.
 *  [frankmarion](https://wordpress.org/support/users/frankmarion/)
 * (@frankmarion)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/tmp-file-error/#post-44624)
 * What this is telling you is that mysql is pointing to a folder that is non-existent,
   or that does not have the permissions to write to. The problem is not with WordPress,
   but with MySQL’s .ini pointing to the an inacessible location. See the MySQL 
   documentation as a pointer.
 * [http://dev.mysql.com/doc/mysql/en/temporary-files.html](http://dev.mysql.com/doc/mysql/en/temporary-files.html)
 *  [zzzmarcus](https://wordpress.org/support/users/zzzmarcus/)
 * (@zzzmarcus)
 * [20 years, 5 months ago](https://wordpress.org/support/topic/tmp-file-error/#post-44625)
 * I’m having a similar problem–if /tmp isn’t executable, WordPress won’t run (many
   other php/mysql scripts will).
 * Is there some way to keep /tmp from being executable and still have WordPress
   work?

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘tmp file error’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 6 participants
 * Last reply from: [zzzmarcus](https://wordpress.org/support/users/zzzmarcus/)
 * Last activity: [20 years, 5 months ago](https://wordpress.org/support/topic/tmp-file-error/#post-44625)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics