02-27-2009, 08:56 PM
When I opened my database and clicked "Structure" in phpmyadmin. It gives me this error.
SQL query: Edit
SHOW FULL FIELDS FROM `users` ;
MySQL said: Documentation
#1 - Can't create/write to file '/ramdisk/mysql/tmp/#sql_17c9_0.MYI' (Errcode: 2)
02-27-2009, 11:00 PM
Judging from other people who have reported this problem (see this google search here (http://www.google.com/search?hl=en&q=mysql+can%27t+create+write+to+file+%27+tmp&aq=0&oq=mysql+Can%27t+create%2Fwrite+to+file)), it's a problem with that temp directory. Either it's not there, or its permissions are set up wrong, or something like that.
02-28-2009, 02:07 AM
Hmm it just doesn't make any sense, it's never had a problem before and I haven't altered it, I just logged in and it was like that.
EDIT: Ahhhh that is weird, I just checked it now a few hours later and its not there anymore, looks to be running normal. Must have been an error with the webhost.