Backup MySQL Database using C#

Question

Is it possible to periodically backup my MySQL Database from my application (C#). I will create the application as a Windows Service or Console app and schedule using Windows Task Scheduler.

Habeeb · Accepted Answer · 2018-09-20 07:02:10Z

2

There is an awesome Library available to Backup and Restore MySQL database in C#.

The code is available on GitHub and can also be added as a Nuget package as well.

Use the below code to do a backup.

string connstr = "server=localhost;user=root;pwd=mypass;database=mydb;sslmode=none;convertdatetime=true;";
string backupfile = "C:\\backup.sql";

using (MySqlConnection conn = new MySqlConnection(connstr))
{
    using (MySqlCommand cmd = new MySqlCommand())
    {
        using (MySqlBackup mb = new MySqlBackup(cmd))
        {
            conn.Open();
            cmd.Connection = conn;

            mb.ExportToFile(backupfile);

            conn.Close();
        }
    }
}

Backup will be saved in C:\backup.sql

answered Sep 20, 2018 at 7:02

Habeeb

8,0751 gold badge33 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alessandro R Over a year ago

That's a nice way to accomplish the task.

Collectives™ on Stack Overflow

Backup MySQL Database using C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related