title: create a windows 2000 batch file that executes a mysql stored procedure
body: <p>I want to create a batch file that I can run from the desktop. This batch file should execute a stored procedure in MySQL.</p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>cd\
  cd Program Files
  cd mysql
  cd mysql server 5.1
  cd bin
  mysql.exe -h host_ip -u login --password=password
  mysql use database_name \g
  mysql call sp_stored_proc_name \g
  </code></pre>
  
  <p>The batch file logs into the server but it doesn't execute the stored procedure.</p>