当前位置: 首页> 科技> 能源 > C#程序备份数据库

C#程序备份数据库

时间:2025/9/5 4:16:12来源:https://blog.csdn.net/weixin_57242877/article/details/139629328 浏览次数:0次

 

namespace BackUpSql
{public partial class Form1 : Form{public Form1(){InitializeComponent();}//开始备份private void button2_Click(object sender, EventArgs e){if (string.IsNullOrEmpty(textBox5.Text)){MessageBox.Show("请选择备份保存地址");return;}string host = textBox1.Text;string port = textBox2.Text;string user = textBox3.Text;string password = textBox4.Text;string database = textBox6.Text;string bakPath = textBox5.Text;if (string.IsNullOrEmpty(textBox1.Text)||string.IsNullOrEmpty(textBox2.Text)||string.IsNullOrEmpty(textBox3.Text)||string.IsNullOrEmpty(textBox4.Text)||string.IsNullOrEmpty(textBox6.Text)){MessageBox.Show("表单不能为空");return;}string cmdStr = "/c mysqldump -h" + host + " -P" + port + " -u" + user + " -p" + password + " " + database + " > " + bakPath;try{System.Diagnostics.Process.Start("cmd", cmdStr);}catch (Exception ex){MessageBox.Show(ex.Message);return;}}//选择文件private void button1_Click(object sender, EventArgs e){FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog();if (folderBrowserDialog.ShowDialog(this) == DialogResult.OK){string FolderName = folderBrowserDialog.SelectedPath;textBox5.Text = FolderName+"\\"+DateTime.Now.ToString("yyyyMMddHHmmss")+".sql";}}}
}

关键字:C#程序备份数据库

版权声明:

本网仅为发布的内容提供存储空间,不对发表、转载的内容提供任何形式的保证。凡本网注明“来源:XXX网络”的作品,均转载自其它媒体,著作权归作者所有,商业转载请联系作者获得授权,非商业转载请注明出处。

我们尊重并感谢每一位作者,均已注明文章来源和作者。如因作品内容、版权或其它问题,请及时与我们联系,联系邮箱:809451989@qq.com,投稿邮箱:809451989@qq.com

责任编辑: