title: Windows Server 08 mysqldump variable filename using timestamp
body: <p>I'm trying to create a batchfile that does a mysqldump with a timestamp filename.</p>
  
  <p>I have tried:</p>
  
  <pre><code>mysqldump -uuser -ppassword database &gt; C:\backup\%DATE%.sql
  </code></pre>
  
  <p>I get error: </p>
  
  <pre><code>C:\backup\06/18/13.sql
  </code></pre>
  
  <p>Which gives me an error:</p>
  
  <pre><code>The system cannot find the path specified.
  </code></pre>
  
  <p>Which I assume is because of the forward slashes.  I've tried using set to set DATE and then invoke it in the mysqldump line, but then batch file crashes.</p>