开发者

Restore Mysql database query is not working in ASP.NET, C#

We are using Mysql.exe to restore database by the following query

string cmd ="-h" + ViewState["host"].ToString() + " " + "-u" + 
ViewState["user"].ToString() + " " + "-p" + ViewState["password"].ToString() + 
" " + ViewState["dbName"].ToString() + "<" + " " + 
Server.MapPath("BackupFiles/") + path;

The same query is executing in MySql command prompt but we are not able to restore using the 开发者_运维问答above query in VisualStudio .Net, we have tried MysqlImport.exe to do the restore but it was no use. we are newbie to MySql if any help would be appreciated.


you are passing extra parameters

Try:

 ProcessStartInfo proc = new ProcessStartInfo(@"C:\Inetpub\wwwroot\TFGRS1\PostgresDLLS\mysql.exe", cmd);
 Process p = new Process();
 p.StartInfo = proc;
 p.Start();
 p.WaitForExit();
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜