MySQL Error : Can't create/write to file '/var/tmp/#sql_8fda_0.MYI'

[Steve Machol]

This error means:

System error: 13 = Permission denied

The directory in that error either does not exist, or it is not world-readable and writable (chmod777.) You need to check and correct both situations to fix this error.

[Wordz]

Anyone can help me with this?

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error : Can't create/write to file '/var/tmp/#sql_8fda_0.MYI' (Errcode: 13)
Error Number : 1

I just moved from one server to another