Difficulty with System.Diagnost ics.Process and MySqlDump

[dwcscreenwriterextremesupreme]

I am trying to automate a mysqldump backup through C# and for some
reason the System.Diagnost ics.Process is just not working as expected
for me.

What I want is for the following code to start a mysqldump, wait there
until it finishes, and then continue the loop.

foreach (DataRow dataRow in backupdt.Rows)
{
System.Diagnost ics.Process proc = new
System.Diagnost ics.Process();
proc.EnableRais ingEvents=false ;
backupFilename = "c:\\data\\ " +
dataRow["EntBkpSrvN ame"].ToString() + "." +
dataRow["EntBkpDbNa me"].ToString() + "." +
DateTime.Now.Ye ar.ToString() + DateTime.Now.Mo nth.ToString() +
DateTime.Now.Da y.ToString();
dumpString = " -h" + dataRow["EntBkpSrvI P"].ToString() + " -
uusername -ppassword " + dataRow["EntBkpDbNa me"].ToString() + " " +
backupFilename + ".sql";
proc.StartInfo. FileName = "mysqldump.exe" ;
proc.StartInfo. Arguments = dumpString;
proc.Start();
proc.WaitForExi t();
}
Can someone tell me what I'm doing wrong?

Thanks.

[Nicholas Paldino [.NET/C# MVP]]

Without knowing what is going wrong (you say it is not working as
expected for you, but what exactly is wrong) it's impossible to say.

Can you clarify?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

<dw************ *************** @gmail.comwrote in message
news:11******** ************@b4 0g2000prd.googl egroups.com...

>I am trying to automate a mysqldump backup through C# and for some
reason the System.Diagnost ics.Process is just not working as expected
for me.

What I want is for the following code to start a mysqldump, wait there
until it finishes, and then continue the loop.

foreach (DataRow dataRow in backupdt.Rows)
{
System.Diagnost ics.Process proc = new
System.Diagnost ics.Process();
proc.EnableRais ingEvents=false ;
backupFilename = "c:\\data\\ " +
dataRow["EntBkpSrvN ame"].ToString() + "." +
dataRow["EntBkpDbNa me"].ToString() + "." +
DateTime.Now.Ye ar.ToString() + DateTime.Now.Mo nth.ToString() +
DateTime.Now.Da y.ToString();
dumpString = " -h" + dataRow["EntBkpSrvI P"].ToString() + " -
uusername -ppassword " + dataRow["EntBkpDbNa me"].ToString() + " " +
backupFilename + ".sql";
proc.StartInfo. FileName = "mysqldump.exe" ;
proc.StartInfo. Arguments = dumpString;
proc.Start();
proc.WaitForExi t();
}
Can someone tell me what I'm doing wrong?

Thanks.