asp.net备份还原mysql数据库 功能已经测试成功

 

 protected void Page_Load(object sender, EventArgs e)
    {
        UILogic.ClearCache();
        VPUserInfo userinfo = UILogic.getSession() as VPUserInfo;
        if (userinfo == null)
        {
            //Response.Write("<mce:script type="text/javascript"><!--
top.location.href='~/../login.aspx'
// --></mce:script>");
        }
        else
        {
            //if (!Page.IsPostBack)
            //{
                System.IO.Directory.CreateDirectory("C://Program Files//MySQL//MySQL Server 5.0//data//vpdata");//在服务器mysql中创建vpdata数据库
            //}
        }
    }

    protected void Backup_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            //string filename = DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", "");

            string filePath = "D://web//App_Data";
            string fileName = filePath + "//vpdata.sql";//备份的文件名称和路径
            //判断目录是否存在
            if (!System.IO.File.Exists(fileName))
            {
                System.IO.Directory.CreateDirectory(filePath);
            }

            //构建执行的命令
            String command = string.Format("mysqldump --quick --host=localhost --default-character-set=latin1 --lock-all-tables --port=3306 --user=root --password=123456 --databases vpdata -R >D://web//App_Data//{0}.sql", "vpdata");

            //获取mysqldump.exe所在路径
            String appDirecroty = @"C:/Program Files/MySQL/MySQL Server 5.0/bin/";

            StartCmd(appDirecroty, command);
            ScriptManager.RegisterClientScriptBlock(Backup, GetType(), "yes", "alert('数据库已成功备份到D://web//App_Data//Vpdata文件中')", true);
        }
        catch (Exception ex)
        {
            ScriptManager.RegisterClientScriptBlock(Backup, GetType(), "no", "alert('数据库备份失败！')", true);
        }
    }
    protected void Restore_Click(object sender, ImageClickEventArgs e)
    {
        try
        {


            //构建执行的命令
            String command = string.Format("mysql --host=192.168.1.10 --default-character-set=latin1 --port=3306 --user=root --password=123456 vpdata <D://web//App_Data//{0}.sql", "vpdata");

            //获取mysql.exe所在路径
            String appDirecroty = @"C:/Program Files/MySQL/MySQL Server 5.0/bin/";

            StartCmd(appDirecroty, command);
            ScriptManager.RegisterClientScriptBlock(Restore, GetType(), "yes", "alert('服务器数据库还原成功！')", true);
        }
        catch (Exception ex)
        {
            ScriptManager.RegisterClientScriptBlock(Restore, GetType(), "no", "alert('数据库还原失败！')", true);
        }
    }

    /// <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");
    }

protected void Page_Load(object sender, EventArgs e) { UILogic.ClearCache(); VPUserInfo userinfo = UILogic.getSession() as VPUserInfo; if (userinfo == null) { //Response.Write("<mce:script type="text/javascript"><!-- top.location.href='~/../login.aspx' // --></mce:script>"); } else { //if (!Page.IsPostBack) //{ System.IO.Directory.CreateDirectory("C://Program Files//MySQL//MySQL Server 5.0//data//vpdata");//在服务器mysql中创建vpdata数据库 //} } } protected void Backup_Click(object sender, ImageClickEventArgs e) { try { //string filename = DateTime.Now.ToString().Replace("-", "").Replace(":", "").Replace(" ", ""); string filePath = "D://web//App_Data"; string fileName = filePath + "//vpdata.sql";//备份的文件名称和路径 //判断目录是否存在 if (!System.IO.File.Exists(fileName)) { System.IO.Directory.CreateDirectory(filePath); } //构建执行的命令 String command = string.Format("mysqldump --quick --host=localhost --default-character-set=latin1 --lock-all-tables --port=3306 --user=root --password=123456 --databases vpdata -R >D://web//App_Data//{0}.sql", "vpdata"); //获取mysqldump.exe所在路径 String appDirecroty = @"C:/Program Files/MySQL/MySQL Server 5.0/bin/"; StartCmd(appDirecroty, command); ScriptManager.RegisterClientScriptBlock(Backup, GetType(), "yes", "alert('数据库已成功备份到D://web//App_Data//Vpdata文件中')", true); } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(Backup, GetType(), "no", "alert('数据库备份失败！')", true); } } protected void Restore_Click(object sender, ImageClickEventArgs e) { try { //构建执行的命令 String command = string.Format("mysql --host=192.168.1.10 --default-character-set=latin1 --port=3306 --user=root --password=123456 vpdata <D://web//App_Data//{0}.sql", "vpdata"); //获取mysql.exe所在路径 String appDirecroty = @"C:/Program Files/MySQL/MySQL Server 5.0/bin/"; StartCmd(appDirecroty, command); ScriptManager.RegisterClientScriptBlock(Restore, GetType(), "yes", "alert('服务器数据库还原成功！')", true); } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(Restore, GetType(), "no", "alert('数据库还原失败！')", true); } } /// <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"); }