Back up mysql db

yokzu

Hello,
I want to back up mysql db. For this process, I am using the command below;
-------------
mysqldump -u root -pc111 dbtest db_table_ci > deneme4.sql
-------------

But I want to execute this command from c#. I try the codes below but not working;
-------------
       string parametre1 = "mysqldump -u root -pc111 dbtest db_table_ci > deneme4.sql";
            Process islem = new Process();
            islem.StartInfo.FileName = "C:\\Windows\\System32\\cmd.exe";
            islem.StartInfo.Arguments = parametre1;
            islem.StartInfo.RedirectStandardOutput = true;
            islem.StartInfo.UseShellExecute = false;
            islem.Start();
            islem.WaitForExit();
            string output = islem.StandardOutput.ReadToEnd();
            textBox6.Text = output;
-------------
How can I do that?
Regards.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted answer
Try it like this:

string parametre1 = "/C mysqldump -u root -pc111 dbtest db_table_ci > deneme4.sql"; // now closing cmd window
Process islem = new Process();
islem.StartInfo.FileName = "C:\\Windows\\System32\\cmd.exe";
islem.StartInfo.Arguments = parametre1;
islem.StartInfo.RedirectStandardOutput = true;
islem.StartInfo.UseShellExecute = false;
islem.Start();
string output = islem.StandardOutput.ReadToEnd(); // reversed order of this and next line
islem.WaitForExit();
textBox6.Text = output;
0
Vulpes15y ago
'/C' is one of the switches you can apply to cmd.exe. It means run the following command and then exit.

If you're using output redirection in your command line (i.e. > deneme4.sql in this case), then it doesn't seem to work unless you use this switch. The command prompt has appeared before the redirection, which is performed by the cmd shell, can take place.

However, if you do use the switch then the prompt is suppressed and the redirection does take place before cmd.exe exits.

It's worth remembering if you do a lot of this kind of stuff.
0
yokzu15y ago
Thanks Vulpes it works great:)
But could you please explain that what is the meaning of "/C"? What it changes?
Thanks again.
0