MySql: "Can't create/write to file 'C:\WINDOWS\TEMP\#xxxxxxxx.MYD' (Errcode: 17)"

[luca.micheletti]

Hello.
I've a problem with mysql/drweb (I think). Sometimes, running a query, MySql returns:
"Can't create/write to file 'C:\WINDOWS\TEMP\#xxxxxxxxxx.MYD' (Errcode: 17)"

After deleting this file, mysql works fine for a bit, but this error message comes back again and again...
I use DrWeb antivirus and the problem went away with DrWeb off (Is it possible?).
Perhaps there is a conflict between MySQL and the installed antivirus program.
Can I exclude temp directory from DrWeb? How can I do? Is it a bug?

Thanks a lot

Luca

 

[JackL]

It looks that you are running 2 mysql and they are trying to create temp file in the same folder.
For Plesk client myslq try to change temp folder (%plesk_dir%\databases\mysql\data\my.ini)
add line to my.ini like tmp_dir=path-to-folder(different from c:\windows\temp)

restart mysql

John S.G.

 

[luca.micheletti]

Thanks, John.
The server came with a default standard Plesk 8.2 installation.

I've found this:
http://forums.mysql.com/read.php?24,169274,178492#msg-178492

But I'll check also about your tip, thanks again...

Luca

 

[JackL]

Actually it is the same solution

John S.G.