MYSQL ERROR: Can't create/write...Errcode: 2

[Danny Spell]

MYSQL ERROR: Can't create/write to file '/tmp/mysqltmpfs/MYMc2JqU' (Errcode: 2 - No such file or directory)


OK, before you jump to conclusions, I have tried to solve this by researching and applying many "fixes" to this issue.

I've tried setting up a new tmp directory and I set the config directive, restarted mysqld, but for some reason, MySQL keeps wanting to use /tmp/mysqltmpfs.

I have changed the permissions.

I have changed the owner and group to mysql.

Thing is, this was working for a very long time.

Someone suggested that the total number of files limit was exceeded. Well, hardly anyone is using this server, but I went ahead and set the open-files-limit=2048. Still no joy.

SELinux is disabled, so that's not the problem.

Some queries work on other tables, which leads me to believe that maybe there is a damaged table or tables. The table involved is the main customer account table. It isn't a very big table.

It is a MyISAM table with 1,951 rows.

Any suggestions? I'm stuck.

Thanks,
Danny