title: Changing MySQL 5.0's tmp folder within my.ini in Windows
body: <p>I have a MySQL server (version 5.0.67) running on Windows 7. While I was working with hibernate within Eclipse, I got the following error:</p>
  
  <blockquote>
    <p>Caused by: java.sql.SQLException: Can't create/write to file 'C:\Windows\TEMP#sql_e9c_0.MYI' (Errcode: 17)</p>
  </blockquote>
  
  <p>I tried to configure the TmpPath of MySQL and set Systemparameters to TMPDIR:</p>
  
  <pre><code>TEMP=C:\Users\JDD09~1.HER\AppData\Local\Temp
  TMP=C:\Users\JDD09~1.HER\AppData\Local\Temp
  TMPDIR=C:\tmp\tmpdir
  </code></pre>
  
  <p>Within my.ini, I made the following change:</p>
  
  <pre><code>[mysqld]
  tmpdir=C:\tmp\tmpdir
  </code></pre>
  
  <p>However, now MySQL aborts when it tries to start up.</p>
  
  <p>I've read this thread (<a href="https://stackoverflow.com/questions/11990887/changing-the-tmp-folder-of-mysql">Changing the tmp folder of mysql</a>), but it didn't help. How can I fix this?</p>