I have a web-server running windows server 2003 web-edition, with a mysql database. The server runs without problems since more than 1 year. Recently however I sometimes get the error: Can't create/write to file 'c:\winnt\temp\#sql_3bc_0.MYI' (Errcode: 13).
Yes, the directory exists and the right security settings are applied. The error occurs not every query, but only now and then. Has it something to do with the growing size of the database? Use of memory? When a result of a table gets too large it's written to disk?
Hope someone can help!