关于c#:cmysql数据库备份还原

1:援用dll

MySql.Data.dll, MySqlbackup.dll

2：建一个数据连贯动态类

public static class mysql{public static string constr = "database=test;Password=明码;user ID=root;server=ip地址";public static MySqlConnection conn = new MySqlConnection(constr);}

3：建winform窗体

备份代码

DialogResult result = MessageBox.Show("备份门路默认在以后程序下", "提醒", MessageBoxButtons.YesNo, MessageBoxIcon.Question);if (result == DialogResult.Yes){string time1 = System.DateTime.Now.ToString("d").Replace("/", "-");string file = ".//mysql/" + time1 + "_test.sql";using (MySqlCommand cmd = new MySqlCommand()){using (MySqlBackup mb = new MySqlBackup(cmd)){cmd.Connection = mysql.conn;mysql.conn.Open();mb.ExportToFile(file);mysql.conn.Close();MessageBox.Show("已备份");}}}else{return;}

还原代码

string file = textBox1.Text;if (file == ""){MessageBox.Show("不能为空");return;}DialogResult result = MessageBox.Show("确定还原吗？", "还原", MessageBoxButtons.YesNo, MessageBoxIcon.Question);if (result == DialogResult.Yes){try{using (MySqlCommand cmd = new MySqlCommand()){using (MySqlBackup mb = new MySqlBackup(cmd)){cmd.Connection = mysql.conn;mysql. conn.Open();mb.ImportFromFile(file);mysql. conn.Close();MessageBox.Show("已还原");}}}catch (Exception ex){MessageBox.Show(ex.Message);}}else{return;}