mysql表还原初始状态_C# MySQL数据库的备份 还原 初始化

主要功能：

1，数据库的初始化

2，数据库的备份|还原

代码如下：

//执行创建数据库操作

this.GetExecute(G_Con, "create database if not exists NEWDB");this.sqlAddress = "-h" + IP + "-u" + User + "-p" + Password + "NEWDB";//数据库的备份

private void btn_Dump_Click(objectsender, EventArgs e)

{using (SaveFileDialog sfd = newSaveFileDialog())

{

sfd.Filter= "数据库文件|*.sql";

sfd.FilterIndex= 0;

sfd.RestoreDirectory= true;

sfd.FileName= "BackUp" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".sql";if (sfd.ShowDialog() ==System.Windows.Forms.DialogResult.OK)

{string filePath =sfd.FileName;string cmd = "mysqldump" + sqlAddress + "> \"" + filePath + "\"";string result