(mysql.info) cannot-create
Info Catalog
(mysql.info) full-table
(mysql.info) common-errors
(mysql.info) commands-out-of-sync
A.2.12 `Can't create/write to file'
-----------------------------------
If you get an error of the following type for some queries, it means
that MySQL cannot create a temporary file for the result set in the
temporary directory:
Can't create/write to file '\\sqla3fe_0.ism'.
The preceding error is a typical message for Windows; the Unix message
is similar.
One fix is to start `mysqld' with the -tmpdir option or to add the
option to the `[mysqld]' section of your option file. For example, to
specify a directory of `C:\temp', use these lines:
[mysqld]
tmpdir=C:/temp
The `C:\temp' directory must exist and have sufficient space for the
MySQL server to write to. See option-files.
Another cause of this error can be permissions issues. Make sure that
the MySQL server can write to the `tmpdir' directory.
Check also the error code that you get with `perror'. One reason the
server cannot write to a table is that the filesystem is full:
shell> perror 28
Error code 28: No space left on device
Info Catalog
(mysql.info) full-table
(mysql.info) common-errors
(mysql.info) commands-out-of-sync
automatically generated byinfo2html