c# 备份 mysql_C# 备份与还原mysql

#region 数据备份与恢复。。

/// <summary>

/// 数据备份

/// </summary>

private void DataBeiFen()

{

try

{

saveFileDialog1.InitialDirectory = "BackData" + "\\";//默认路径

saveFileDialog1.FilterIndex = 1; //默认值为第一个

saveFileDialog1.RestoreDirectory = true; //重新定位保存路径

saveFileDialog1.Filter = "备份文件 (*.bak)|*.bak|所有文件 (*.*)|*.*";//筛选器，定义文件类型

if (saveFileDialog1.ShowDialog() == DialogResult.OK)

{

if (!File.Exists(saveFileDialog1.FileName.ToString())) //判断是否有重名

{

string sqlStr = "BACKUP DATABASE PersonManager TO DISK = '" + saveFileDialog1.FileName.ToString() + "'";

DbOpeate.ExecSqlStr(sqlStr);

MessageBox.Show("数据备份成功！","提示对话框");

}

else</