1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

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

Discussion in 'Plesk for Windows - 8.x and Older' started by luca.micheletti, Dec 7, 2007.

  1. luca.micheletti

    luca.micheletti Guest

    0
     
    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
     
  2. JackL

    JackL Guest

    0
     
    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.
     
  3. luca.micheletti

    luca.micheletti Guest

    0
     
  4. JackL

    JackL Guest

    0
     
    Actually it is the same solution

    John S.G.
     
Loading...