Help with WordPress database error

[C3MDigital]

For some reason all my post categories are gone. When I got a edit a post in admin it shows the category but when I click categories none are listed but when i try to add one that was previously there it says category already exists.

Here is my error log:

[17-Apr-2010 19:34:21] WordPress database error Can't create/write to file '/tmp/#sql_5dea_0.MYI' (Errcode: 13) for query SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 9 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_list_bookmarks, get_bookmarks
[17-Apr-2010 19:34:50] WordPress database error Can't create/write to file '/tmp/#sql_5dea_0.MYI' (Errcode: 13) for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (287) ORDER BY t.name ASC made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms
[17-Apr-2010 19:34:50] WordPress database error Can't create/write to file '/tmp/#sql_5dea_0.MYI' (Errcode: 13) for query  SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)  WHERE 1=1  AND wp_term_taxonomy.taxonomy = 'category'  AND wp_term_taxonomy.term_id IN ('8')  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date asc LIMIT 0, 10 made by require, require_once, include, query_posts, WP_Query->query, WP_Query->get_posts
[17-Apr-2010 19:34:50] WordPress database error Can't create/write to file '/tmp/#sql_5dea_0.MYI' (Errcode: 13) for query SELECT *    FROM wp_links  INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y'  AND ( tt.term_id = 9 ) AND taxonomy = 'link_category'    ORDER BY link_name ASC made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_list_bookmarks, get_bookmarks

Only recent changes I have made were to remove execute privileges from my tmp directory for security purposes. I made that change a few days ago and everything worked until today. Any suggestions would be appreciated. Thanks.

[C3MDigital]

Problem solved. I had to ssh into root to edit the my.cnf file to use another directory for tmp