Sub MySQL_Dump()
 
  Dim strCmdParameter As String
  Dim strSpath As String
  Dim strDpath As String
  Dim strUserPassword As String
  Dim strDB As String
  Dim strCommandstring As String
 
'Leerzeichen in beiden Pfaden
'Funktioniert auch wenn keine Leerzeichen vorkommen
  strCmdParameter = "cmd.exe /s /c "
  strSpath = """""D:\mysql test\bin\mysqldump.exe"""
  strDpath = """D:\Eigene Dateien\cdcoldump.txt"""""
  strUserPassword = " -u root "
  strDB = " cdcol "
 
  strCommandstring = strCmdParameter & strSpath & strUserPassword & strDB & "" & _
    "> " & _
  strDpath
 
  Call Shell(strCommandstring, vbHide)
 
End Sub