Please see the weird problem below... Why it happens?
mysql> create table a (name varchar(255) NOT NULL); Query OK, 0 rows affected (0.01 sec)
mysql> desc a; ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_92b_0.MYI' (Errcode: 13)
Well it is trying to create the table in tmp dir so probably you have not selected a database to create the table in first.
Roger Ramjet wrote:Well it is trying to create the table in tmp dir so probably you have not selected a database to create the table in first.
The table is successfully created. Something else is wrong here.
MYI = mysql index file, /tmp/#sql_92b_0.MYI' = tmp dir so something is wrong
Sounds to me like you ran out of disk space.
Change permission on 'tmp' folder - solved the problem.
Thanks
Why was the tmp folder not open to the public?
