vb Mysql

[jonybd]

/////////////////////////////////////////////////////////
Backup & Recovery function not working can anybody tell why ? 1st two function working from module1 , but how to
let other 2 function work.
/////////////////////////////////////////////////////////

Global exePath As String
Global exeCmd As String
Global dBase As String

Global bPath As String
Global rPath As String

Function dRop()
Shell ("C:\mysql\bin\mysqladmin drop test&quot
'Shell (exePath & "\" & exeCmd & ".exe " & "-f drop " & dBase)
End Function

Function cReate()
Shell ("C:\mysql\bin\mysqladmin create test&quot
'Shell (exePath & "\" & exeCmd & ".exe " & "-f create " & dBase)
End Function

Function bAckup()
Shell "C:\mysql\bin\mysqldump --opt -u root test > f:\vbSql.sql", vbNormalFocus
'Shell (exePath & "\mysqldump.exe " & "--opt -u root " & dBase & " > " & bPath)
End Function

Function reCover()
Shell &quot;C:\mysql\bin\mysql -u root test < f:\inforev.sql&quot;
'Shell (exePath & &quot;\mysql.exe &quot; & &quot;-u root &quot; & dBase & &quot; < &quot; & rPath)
End Function

 

[TomKane]

Do the commands work if you run them from thje command line?

 

[jonybd]

------------Not Solved----------
------------Not Solved----------
------------Not Solved----------
------------Not Solved----------

yes four commands run perfectly.
if i run them from command line.

------------Not Solved----------
------------Not Solved----------
------------Not Solved----------
------------Not Solved----------

 

[jonybd]

useing shell(&quot;cmd.exe /c&quot its working now.