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();
精彩评论