using ?System;
using ?System.Collections.Generic;
using ?System.Text;
using ?System.Diagnostics;

???? public ? class ?Cmd
????{
???????? /// ? <summary>
???????? /// ?執行Cmd命令
???????? /// ? </summary>
???????? /// ? <param?name="workingDirectory"> 要啟動的進程的目錄 </param>
???????? /// ? <param?name="command"> 要執行的命令 </param>
???????? public ? static ? void ?StartCmd(String?workingDirectory,?String?command)
????????{
????????????Process?p? = ? new ?Process();
????????????p.StartInfo.FileName? = ? " cmd.exe " ;
????????????p.StartInfo.WorkingDirectory? = ?workingDirectory;
????????????p.StartInfo.UseShellExecute? = ? false ;
????????????p.StartInfo.RedirectStandardInput? = ? true ;
????????????p.StartInfo.RedirectStandardOutput? = ? true ;
????????????p.StartInfo.RedirectStandardError? = ? true ;
????????????p.StartInfo.CreateNoWindow? = ? true ;
????????????p.Start();
????????????p.StandardInput.WriteLine(command);
????????????p.StandardInput.WriteLine( " exit " );
????????}
????}

using ?System;
using ?System.Collections.Generic;
using ?System.ComponentModel;
using ?System.Data;
using ?System.Drawing;
using ?System.Text;
using ?System.Windows.Forms;
using ?System.IO;
using ?System.Diagnostics;
using ?System.Configuration;

using ?MDRClient.DataAccess;

namespace ?MDRClient
{
???? public ? partial ? class ?DataBackup?:?Form
????{
???????? public ?DataBackup()
????????{
????????????InitializeComponent();
????????}

???????? private ? void ?btnBackup_Click( object ?sender,?EventArgs?e)
????????{
???????????? try
????????????{
???????????????? // String?command?=?"mysqldump?--quick?--host=localhost?--default-character-set=gb2312?--lock-tables?--verbose??--force?--port=端口號?--user=用戶名?--password=密碼?數據庫名?-r?備份到的地址";

???????????????? // 構建執行的命令
????????????????StringBuilder?sbcommand? = ? new ?StringBuilder();

????????????????StringBuilder?sbfileName? = ? new ?StringBuilder();
????????????????sbfileName.AppendFormat( " {0} " ,?DateTime.Now.ToString()).Replace( " - " ,? "" ).Replace( " : " ,? "" ).Replace( " ? " ,? "" );
????????????????String?fileName? = ?sbfileName.ToString();

????????????????SaveFileDialog?saveFileDialog? = ? new ?SaveFileDialog();
????????????????saveFileDialog.AddExtension? = ? false ;
????????????????saveFileDialog.CheckFileExists? = ? false ;
????????????????saveFileDialog.CheckPathExists? = ? false ;
????????????????saveFileDialog.FileName? = ?fileName;

???????????????? if ?(saveFileDialog.ShowDialog()? == ?DialogResult.OK)
????????????????{
????????????????????String?directory? = ?saveFileDialog.FileName;

????????????????????sbcommand.AppendFormat( " mysqldump?--quick?--host=localhost?--default-character-set=gbk?--lock-tables?--verbose??--force?--port=端口號?--user=用戶名?--password=密碼?數據庫名?-r?\ " { 0 }\ "" ,?directory);
????????????????????String?command? = ?sbcommand.ToString();

???????????????????? // 獲取mysqldump.exe所在路徑
????????????????????String?appDirecroty? = ?System.Windows.Forms.Application.StartupPath? + ? " \\ " ;
????????????????????Cmd.StartCmd(appDirecroty,?command);
????????????????????MessageBox.Show( @" 數據庫已成功備份到? " ? + ?directory? + ? " ?文件中 " ,? " 提示 " ,?MessageBoxButtons.OK,?MessageBoxIcon.Information);
????????????????}

????????????}
???????????? catch ?(Exception?ex)
????????????{
????????????????MessageBox.Show( " 數據庫備份失敗！ " );
????????????????
????????????}
????????}
????????
????}
}

using ?System;
using ?System.Collections.Generic;
using ?System.ComponentModel;
using ?System.Data;
using ?System.Drawing;
using ?System.Text;
using ?System.Windows.Forms;
using ?System.IO;
using ?System.Diagnostics;
using ?System.Configuration;

using ?MDRClient.DataAccess;

namespace ?MDRClient
{
???? public ? partial ? class ?DataRestore?:?Form
????{
???????? public ?DataRestore()
????????{
????????????InitializeComponent();
????????}

???????? private ? void ?btnRestore_Click( object ?sender,?EventArgs?e)
????????{

???????????? // string?s?=?"mysql?--port=端口號?--user=用戶名?--password=密碼?數據庫名<還原文件所在路徑";

???????????? try
????????????{
????????????????StringBuilder?sbcommand? = ? new ?StringBuilder();

????????????????OpenFileDialog?openFileDialog? = ? new ?OpenFileDialog();

???????????????? if ?(openFileDialog.ShowDialog()? == ?DialogResult.OK)
????????????????{
????????????????????String?directory? = ?openFileDialog.FileName;

???????????????????? // 在文件路徑后面加上""避免空格出現異常
????????????????????sbcommand.AppendFormat( " mysql?--host=localhost?--default-character-set=gbk?--port=端口號?--user=用戶名?--password=密碼?數據庫<\ " { 0 }\ "" ,?directory);
????????????????????String?command? = ?sbcommand.ToString();

???????????????????? // 獲取mysql.exe所在路徑
????????????????????String?appDirecroty? = ?System.Windows.Forms.Application.StartupPath? + ? " \\ " ;

????????????????????DialogResult?result? = ?MessageBox.Show( " 您是否真的想覆蓋以前的數據庫嗎？那么以前的數據庫數據將丟失！！！ " ,? " 警告 " ,?MessageBoxButtons.YesNo,?MessageBoxIcon.Warning);
???????????????????? if ?(result? == ?DialogResult.Yes)
????????????????????{
????????????????????????Cmd.StartCmd(appDirecroty,?command);
????????????????????????MessageBox.Show( " 數據庫還原成功！ " );
????????????????????}
????????????????}
????????????????
????????????}
???????????? catch ?(Exception?ex)
????????????{
????????????????MessageBox.Show( " 數據庫還原失敗！ " );
????????????}

????????}
????????
????}
}