What is wrong in how I start the process?

Question

When I run the following from cmd it runs ok

>mysql -h 134.86.157.132 -u sas vm < c:\vm.sql

When I try to do the same from code it does not work

ProcessStartInfo info = new ProcessStartInfo("mysql");
info.Arguments = @"-h 134.86.157.132 -u sas vm < c:\vm.sql";
info.Domain = "134.86.157.132";
info.UserName = "sas";
info.Arguments = @"vm < c:\vm.sql";
info.UseShellExecute = false;
Process.Start(info);

What am I doing wrong here? It does not work and I get some wrong password exception?

Edit:

I run it like this now

            ProcessStartInfo info = new ProcessStartInfo("mysql");
            info.UseShellExecute = false;
            info.RedirectStandardInput = true;
            info.RedirectStandardOutput = true;
            info.RedirectStandardError = true;
            info.Arguments = @"-h 134.86.157.132 -u sas vm < c:\vm.sql";
            Process.Start(info);

and get following error The system cannot find the file specified

score 3 · Answer 1 · edited Dec 08 '10 at 15:59

3

Try it like this:

ProcessStartInfo info = new ProcessStartInfo("mysql");
info.Arguments = @"-h 134.86.157.132 -u sas vm < c:\vm.sql";
info.UseShellExecute = false;
Process.Start(info);

edited Dec 08 '10 at 15:59

SwDevMan81

48,814
22
151
184

answered Dec 08 '10 at 15:53

Øyvind Bråthen

59,338
27
124
151

It'll still need UseShellExecute as true in order to make the redirection work. – Jon Skeet Dec 08 '10 at 15:57
@Night Walker What is the error? "I get the following error..." – P.Brian.Mackey Dec 08 '10 at 16:03
@P.Brian.Mackey The system cannot find the file specified – Night Walker Dec 08 '10 at 16:11
You might need to specify the full path. See here: http://social.msdn.microsoft.com/forums/en-US/netfxbcl/thread/7f668b1c-e982-4d5b-b229-0b0e0cf9c249 – SwDevMan81 Dec 08 '10 at 16:30

score 3 · Answer 2 · answered Dec 08 '10 at 15:54

3

"-h 134.86.157.132 -u sas vm" are the arguments, don't use domain and username.

You also need to redirect the standard input stream to pass your vm.sql file in. See this example: ProcessStartInfo.RedirectStandardInput Property

answered Dec 08 '10 at 15:54

Simon Mourier

132,049
21
248
298

score 2 · Answer 3 · answered Dec 08 '10 at 15:52

2

You're setting UseShellExecute to false, but it's the shell that interprets the "<" part to redirect stdin from a file.

Unless there's a specific reason why you need UseShellExecute to be false, set it to true. Alternatively, redirect standard input for the new process, and give it the data directly.

EDIT: As specified in other answers, keep the original arguments, and don't set Domain/UserName on the ProcessStartInfo. Those refer to Windows usernames and domains, not MySQL ones.

At that point you'll be able to set UseShellExecute to true with no ill effects, with any luck.

answered Dec 08 '10 at 15:52

Jon Skeet

1,421,763
867
9,128
9,194

when i put it to true i get following error The Process object must have the UseShellExecute property set to false in order to start a process as a user. – Night Walker Dec 08 '10 at 15:54
@Night: Fair enough... so do you *definitely* have to start the process as that user? I suspect not, given that it's unlikely to be a *windows* user. See Marc's answer. – Jon Skeet Dec 08 '10 at 15:56

score 0 · Answer 4 · edited May 23 '17 at 11:58

How about something like from this post:

        Process p = new Process();
        ProcessStartInfo info = new ProcessStartInfo();
        info.FileName = "cmd.exe";
        info.RedirectStandardInput = true;
        info.UseShellExecute = false;

        p.StartInfo = info;
        p.Start();

        using (StreamWriter sw = new StreamWriter(p.StandardInput))
        {
            if (sw.BaseStream.CanWrite)
            {
                sw.WriteLine("mysql -h 134.86.157.132 -u sas vm < c:\vm.sql");
            }
        }

What is wrong in how I start the process?

Edit:

4 Answers4