MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET

r囧r小猫 2022-07-31 15:24 11阅读 0赞

原文：[http://www.codeproject.com/Articles/256466/MySqlBackup-NET][http_www.codeproject.com_Articles_256466_MySqlBackup-NET]

using MySql.Data.MySqlClient;

string constring = "server=localhost;user=root;pwd=qwerty;database=test;";
    string file = "C:\\backup.sql";
    using (MySqlConnection conn = new MySqlConnection(constring))
    {
        using (MySqlCommand cmd = new MySqlCommand())
        {
            using (MySqlBackup mb = new MySqlBackup(cmd))
            {
                cmd.Connection = conn;
                conn.Open();
                mb.ExportToFile(file);
                conn.Close();
            }
        }
    }

string constring = "server=localhost;user=root;pwd=qwerty;database=test;";
    string file = "C:\\backup.sql";
    using (MySqlConnection conn = new MySqlConnection(constring))
    {
        using (MySqlCommand cmd = new MySqlCommand())
        {
            using (MySqlBackup mb = new MySqlBackup(cmd))
            {
                cmd.Connection = conn;
                conn.Open();
                mb.ImportFromFile(file);
                conn.Close();
            }
        }
    }

string constring = "server=localhost;user=root;pwd=1234;database=test1;";
    string file = "Y:\\backup.sql";
    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 = false;
                mb.ExportToFile(file);
            }
        }
    }

string constring = "server=localhost;user=root;pwd=1234;database=test1;";
    string file = "Y:\\backup.sql";
    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.ImportFromFile(file);
            }
        }
    }

Sample code for Export. Below codes will export the content into MemoryStream, then transmit it directly for download.

using System.IO;
    
    string connstr = "server=localhost;user=root;pwd=1234;database=test;";
    MemoryStream ms = new MemoryStream();
    using (MySqlConnection conn = new MySqlConnection(connstr))
    {
        MySqlCommand cmd = new MySqlCommand();
        MySqlBackup mb = new MySqlBackup(cmd);
        cmd.Connection = conn;
        conn.Open();
        mb.ExportToMemoryStream(ms);
    }
    Response.ContentType = "text/plain";
    Response.AppendHeader("Content-Disposition", "attachment; filename=backup.sql");
    Response.BinaryWrite(ms.ToArray());
    Response.End();

string connstr = "server=localhost;user=root;pwd=1234;database=test;";
    byte[] ba = FileUpload1.FileBytes;
    MemoryStream ms = new MemoryStream(ba);
    using (MySqlConnection conn = new MySqlConnection(connstr))
    {
        MySqlCommand cmd = new MySqlCommand();
        MySqlBackup mb = new MySqlBackup(cmd);
        cmd.Connection = conn;
        conn.Open();
        mb.ExportToMemoryStream(ms);
    }
    Header.Controls.Add(new LiteralControl("<script type=\"text/javascript\">alert('ok');</script>"));

More guides and examples available at the project site's documentation:  
[https://mysqlbackupnet.codeplex.com/documentation][https_mysqlbackupnet.codeplex.com_documentation]\[[^][https_mysqlbackupnet.codeplex.com_documentation]\]

Below are some of the guides

*  [Example of Using in MemoryStream, Zip and ASP.NET][Example of Using in MemoryStream_ Zip and ASP.NET]
 *  [Using Progress Report With Export/Backup][Using Progress Report With Export_Backup]
 *  [Using Progress Report With Import/Restore][Using Progress Report With Import_Restore]
 *  [Conditional Rows Export for Each Table][]
 *  [Using Encryption][]
 *  [FAQ - Commonly Seen Errors][]

[http_www.codeproject.com_Articles_256466_MySqlBackup-NET]: http://www.codeproject.com/Articles/256466/MySqlBackup-NET
[https_mysqlbackupnet.codeplex.com_documentation]: https://mysqlbackupnet.codeplex.com/documentation
[Example of Using in MemoryStream_ Zip and ASP.NET]: https://mysqlbackupnet.codeplex.com/wikipage?title=Example%20of%20Using%20in%20MemoryStream%2c%20Zip%20and%20ASP.NET&referringTitle=Documentation
[Using Progress Report With Export_Backup]: https://mysqlbackupnet.codeplex.com/wikipage?title=Using%20Progress%20Report%20With%20Export%2fBackup&referringTitle=Documentation
[Using Progress Report With Import_Restore]: https://mysqlbackupnet.codeplex.com/wikipage?title=Using%20Progress%20Report%20With%20Import%2fRestore&referringTitle=Documentation
[Conditional Rows Export for Each Table]: https://mysqlbackupnet.codeplex.com/wikipage?title=Conditional%20Rows%20Export%20for%20Each%20Table&referringTitle=Documentation
[Using Encryption]: https://mysqlbackupnet.codeplex.com/wikipage?title=Using%20Encryption&referringTitle=Documentation
[FAQ - Commonly Seen Errors]: https://mysqlbackupnet.codeplex.com/wikipage?title=Frequently%20Asked%20Questions%20%28FAQ%29%20-%20Commonly%20Seen%20Error&referringTitle=Documentation