MySQL failed to create file/write file Error Resolution

If you encounter the following types of errors for some queries, it means that MySQL cannot create temporary files for the result set in the TEMP directory:

Unable to create/write file ' \\sqla3fe_0.ism '.

The aforementioned error is a typical message on the Windows platform, and the message on the UNIX platform is similar.

One way to correct this is to use the--TMPDIR option to start the mysqld, or to add the option in the [Mysqld] section of the option file. For example, to specify a directory C:\temp, you can use:

[mysqld]
tmpdir=C:/temp

The directory C:\temp must exist and there is enough space to allow MySQL to write to it. See section 4.3.2, "Working with options files."

Another reason for this error may be licensing matters. Make sure the MySQL server is able to write to the Tmpdir directory.

In addition, you use perror to check for error codes. One reason the server cannot write to the table is that the file system is full.

shell> perror 28
错误代码28：磁盘上无剩余空间