title: how to backup my sql database in vb.net
body: <p>i want the user of my vb application to be able to backup and restore the database (MySQL) onto a storage medium. my problem is that i dont want to specify 'c:\ in the code because i want the application to be able to locate the dumb file whether it is created on drive c or not. below is the code i used but when i installed it on another machine, it had its windows and program files on D:. it turns out that i have to check the drive letter of every machine, change it in the code before i publish the application to allow backup which i dont want to do that. i want it do be universal. thus whether the dump file is on driver C, G or whatever. any help. below is the code i used.
      Dim cmd As String</p>
  
  <pre><code>Private Sub cmdBackup_Click()
      Screen.MousePointer = vbHourglass
      DoEvents
  
      cmd = Chr(34) &amp; "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump" &amp; Chr(34) &amp; " -uroot -psecretpswd --routines --comments db_name &gt; c:\MyBackup.sql"
      Call execCommand(cmd)
  
      Screen.MousePointer = vbDefault
      MsgBox "done"
  End Sub
  </code></pre>