There are a number of reasons why you may be experiencing this error:
- MySQL cannot create a temporary file
- The file permissions are incorrect
To fix the problem you will need to either:
- Alter the tmpdlr variable to point to a writable directory.
- Correct the File Permissions.