SQL Backup

https://mysqlbackupnet.codeplex.com/


using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace WpfApplication1
{
  /// <summary>
  /// Interaction logic for MainWindow.xaml
  /// </summary>
  public partial class MainWindow : Window
  {
    public MainWindow()
    {
      InitializeComponent();
    }

    private void Button_Click(object sender, RoutedEventArgs e)
    {
      try
      {
        string constring = "server=MYSQLDEV;port=3306;database=DEMO_RETAIL;uid=trial01;password=Nopass12;CharSet=utf8;Connection Timeout=50;Allow User Variables=True;allow zero datetime=yes;";
        string file = "C:\\Ashok\\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();
            }
          }
        }
        MessageBox.Show("done");
      }
      catch (Exception ex)
      {
        MessageBox.Show(ex.Message);
      }
    }
  }
}