コード例 #1
0
ファイル: DbBackup.cs プロジェクト: GodProgrammerMan/PipeLine
        /// <summary>
        /// 还原数据库
        /// </summary>
        /// <param name="path">指定还原文件***.sql的绝对路径</param>
        /// <param name="dbName">还原到指定数据库</param>
        /// <returns></returns>
        public static bool RestoreDb(string path, string dbName)
        {
            bool isSuccess = false;

            try
            {
                MutiDBOperate mutiDB = Appsettings.app <MutiDBOperate>("DBS")
                                       .Where(i => i.Enabled && i.ConnId == "WMBLOG_MYSQL").First();
                MySqlConnection myconn = new MySqlConnection(mutiDB.Connection);
                if (myconn.State == ConnectionState.Closed)
                {
                    myconn.Open();
                }
                try
                {
                    using (MySqlCommand cmmd = new MySqlCommand())
                    {
                        using (MySqlBackup backCmd = new MySqlBackup(cmmd))
                        {
                            cmmd.Connection     = myconn;
                            cmmd.CommandTimeout = 3600;
                            //backCmd.ImportInfo.TargetDatabase = dbName;//前提条件 当前 myconn 中的用户有建库等系列权限
                            //backCmd.ImportInfo.DatabaseDefaultCharSet = "utf8";
                            backCmd.ImportFromFile(path);
                            isSuccess = true;
                        }
                    }
                }
                catch (Exception ex)
                {
                    //Console.WriteLine($"BackupDB_备份数据库异常 sql:{cmdText}. {ex.Message}", "MYSQLIMPL");
                }
                finally
                {
                    if (myconn.State == ConnectionState.Open)
                    {
                        myconn.Close();
                        myconn.Dispose();
                    }
                }
            }
            catch (Exception)
            {
            }
            return(isSuccess);
        }
コード例 #2
0
ファイル: DbBackup.cs プロジェクト: GodProgrammerMan/PipeLine
        /// <summary>
        /// 备份数据库
        /// </summary>
        /// <param name="path">备份文件地址如D://abc.sql</param>
        /// <returns></returns>
        public static void BackupDb(object path)
        {
            bool isSuccess = false;

            try
            {
                MutiDBOperate mutiDB = Appsettings.app <MutiDBOperate>("DBS")
                                       .Where(i => i.Enabled && i.ConnId == "WMBLOG_MYSQL").First();
                MySqlConnection myconn = new MySqlConnection(mutiDB.Connection);
                if (myconn.State == ConnectionState.Closed)
                {
                    myconn.Open();
                }
                try
                {
                    using (MySqlCommand cmmd = new MySqlCommand())
                    {
                        using (MySqlBackup backCmd = new MySqlBackup(cmmd))
                        {
                            cmmd.Connection                 = myconn;
                            cmmd.CommandTimeout             = 60;
                            backCmd.ExportInfo.MaxSqlLength = 2048;//指定备份文件的大小
                            backCmd.ExportToFile(path.ToString());
                            isSuccess = true;
                        }
                    }
                }
                catch (Exception ex)
                {
                    //Console.WriteLine($"BackupDB_备份数据库异常 sql:{cmdText}. {ex.Message}", "MYSQLIMPL");
                }
                finally
                {
                    if (myconn.State == ConnectionState.Open)
                    {
                        myconn.Close();
                        myconn.Dispose();
                    }
                }
            }
            catch (Exception ex)
            {
                //Logger.Error($"BackupDB_备份数据库异常。ex.Message}", "MYSQLIMPL");
            }
            //return isSuccess;
        }