Back up mysql db

Question

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.

Vulpes · 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;

Vulpes · Answer

'/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.

yokzu · Answer

Thanks Vulpes it works great:) But could you please explain that what is the meaning of /C? What it changes? Thanks again.