hi all,

i just tried to set a fulltext index on a field, but got the following error where 'hbot' is my db name....

#1005 - Can't create table './hbot/#sql-24eb_4c7864.frm' (errno: 140)

...i attempted to restart the db server and even cleared a bit of room in temp, but to no avail. The table is rather big....almost 1GB of disk space and about 1/2 a million rows. I am thinking I may still not have enough room in /tmp (how much space is enough?), but was looking for other solutions. 'check table' showed I was in good shape. Could this be another issuse? any ideas?

Many thanks!