title: windows batch file for mysqldump command
body: <p>this is first time I am upto making a windows batch file.I wish not to do experiments first as its related to live server.
  I use to back up mySql database by following 
  open cmd 
  write </p>
  
  <pre><code>mysqldump -u user -p DBname &gt;C:\DBname.sql
  </code></pre>
  
  <p>then cmd ask password </p>
  
  <pre><code>password = password
  </code></pre>
  
  <p>I want to make a windows batch file ,upon click I wish to perform the above functionality.
  Can any one please give some instructions related script of .bat file </p>
  
  <p>So far I wrote this </p>
  
  <pre><code>ECHO OFF
  mysqldump -u user -p DBname &gt;C:\DBname.sql
  GO
  SET password = password 
  Go
  </code></pre>
  
  <p>but still it prompts me for password . 
  I wish password get enter automatically </p>