string constring = "server=192.168.0.1;port=3306;user=root; pwd=123456; database=test1;allow zero datetime = true;";

            string file = "C:\\backup.sql";

            System.IO.MemoryStream ms = new System.IO.MemoryStream();//导出到内存的方式

            using (MySqlConnection conn = new MySqlConnection(constring))

            {

                using (MySqlCommand cmd = new MySqlCommand())

                {

                    using (MySqlBackup mb = new MySqlBackup(cmd))

                    {

                        cmd.Connection = conn;

                        conn.Open();

                        //mb.ExportInfo.AddCreateDatabase = true;//是否需要创建数据库

                        //mb.ExportInfo.ExportTableStructure = true;//导出表结构

                        //mb.ExportInfo.ExportRows = true;//导出数据

                        mb.ExportInfo.ExportViews = false;//视图不导

                        mb.Command.CommandTimeout = ;

                        mb.ExportToFile(file);//导出到文件的方式

                        //mb.ExportToMemoryStream(ms);//导出到内存的方式

                        conn.Close();

                    }

                }

            }

            constring = "server=192.168.0.2;port=3306;user=root; pwd=123456; database=test1;allow zero datetime = true;";

            using (MySqlConnection conn = new MySqlConnection(constring))

            {

                using (MySqlCommand cmd = new MySqlCommand())

                {

                    using (MySqlBackup mb = new MySqlBackup(cmd))

                    {

                        cmd.Connection = conn;

                        conn.Open();

                        //mb.ImportInfo.TargetDatabase = "test2";

                        //mb.ImportInfo.DatabaseDefaultCharSet = "utf8";

                        mb.Command.CommandTimeout = ;

                        mb.ImportFromFile(file);//导出到文件的方式

                        //mb.ImportFromMemoryStream(ms);//导出到内存的方式

                        conn.Close();

                    }

                }

            }