Technote Details :: Cannot create/write to file

Issue

MX RSS Reader -Writer fails and displays the following error message:

Can't create/write to file 'C:\Temp\#sql564_b6_0.frm' (Errcode: 2)

Reason

MX RSS Reader-Writer needs to create temporary SQL tables in order to function properly. If you encounter an error similar to this one, it means MySQL cannot create a temporary file for the result set in the temporary directory.

Solution

In order to correct this error, open the my.ini or my.cnf file and add the following line of code after [mysqld]:

tmpdir=path

For example, to specify a directory of C:\temp, use these lines:

[mysqld]
tmpdir=C:/temp

Paths should be separated by colon characters (':') on Unix and semicolon characters (';') on Windows, NetWare, and OS/2. The path must be valid and the corresponding directory must have sufficient space for the MySQL server to write to. Otherwise, the error will occur again.

Regarding this issue, check out the clickable parts below:

  • details about this error.
  • article on where MySQL stores temporary files.
  • article on how to see the MySQL system variables (including tmpdir).


Home > Support > Knowledge Base > Technote Details
Search the Knowledge Base
© Adobe Systems Romania. All rights reserved.