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.
I do not have that much experience using ASP but should you not be using UseShellExecute = true? The redirection is something that is part of the shell and most likely will not be recognized by the application. Again I do not have that much experience so I cannot say for sure.
The second thing that comes to mind is that the redirection from your backup file, is this a full pathname or relative pathname?
Finally if a string is returned after executing this might give more information as to the source of the problem.