C#中怎么用dos命令定点备份数据库呢？另外按钮手动备份数据库是不是要写那些连接字符串？

Question

D:\wamp\bin\mysql\mysql5.1.36\bin\mysqldump.exe --opt -R -u root -pvaodesql_2011 k801>"D:/wamp/vaode_mysql_backup/k801_mysql_backup当前年月日分秒.sql; 需求如下：0,6,12,18，定点备份数据库，执行dos命令！

Answer 1

//摘录：《程序员秘书》－－源代码－－进程－－后台执行DOS命令
private   void   button1_Click(object   sender,   EventArgs   e)
{
        Process   myProcess   =   new   Process();
        myProcess.StartInfo.FileName   =   "cmd.exe ";//DOS控制平台
        myProcess.StartInfo.UseShellExecute   =   false;
        myProcess.StartInfo.CreateNoWindow   =   true;
        myProcess.StartInfo.RedirectStandardInput   =   true;
        myProcess.StartInfo.RedirectStandardOutput   =   true;
        myProcess.StartInfo.RedirectStandardError   =   true;
        myProcess.Start();
        StreamWriter   sIn   =   myProcess.StandardInput;//标准输入流
        sIn.AutoFlush   =   true;
        StreamReader   sOut   =   myProcess.StandardOutput;//标准输入流
        StreamReader   sErr   =   myProcess.StandardError;//标准错误流
        sIn.Write( "ver "   +   System.Environment.NewLine);//DOS控制平台上的命令
        sIn.Write( "dir "   +   System.Environment.NewLine);//DOS控制平台上的命令
        sIn.Write( "exit "   +   System.Environment.NewLine);
        string   s   =   sOut.ReadToEnd();//读取执行DOS命令后输出信息
        string   er   =   sErr.ReadToEnd();//读取执行DOS命令后错误信息
        richTextBox1.AppendText(s);
        richTextBox1.AppendText(er);
        if   (myProcess.HasExited   ==   false)
        {
                myProcess.Kill();
        }
        sIn.Close();
        sOut.Close();
        sErr.Close();
        myProcess.Close();
}