请问如何用C#调用mysqldump进行数据库备份？

Question

你把代码能在具体点吗 ？

Answer 1

以下是完整版：using System;
using System.Collections.Generic;
using System.Text;namespace ConsoleApplication6
{
    class Program
    {
        static void Main()
        {
            System.Diagnostics.ProcessStartInfo Info = new System.Diagnostics.ProcessStartInfo();
            Info.FileName = @"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump.exe";
            Info.Arguments = "-uroot -proot test>test-yyyy-mm-dd.sql";
            System.Diagnostics.Process proc;
            try
            {
                proc = System.Diagnostics.Process.Start(Info);
            }
            catch (System.ComponentModel.Win32Exception e)
            {
                Console.WriteLine("找不到指定程序文件。\r{0}", e);
                return;
            }
            Console.WriteLine("程序开始执行时间:{0}", proc.StartTime);
            proc.WaitForExit(6000);
            if (proc.HasExited == false)
            {
                Console.WriteLine("由主程序强行终止外部程序的运行！");
                proc.Kill();
            }
            else
            {
                Console.WriteLine("由程序正常退出！");
            }
            Console.WriteLine("程序的结束运行时间：{0}", proc.ExitTime);
            Console.WriteLine("程序在结束运行时的返回值：{0}", proc.ExitCode);
        }
    }
}