private void button12_Click(object sender, EventArgs e)
{
SaveFileDialog sFileDialog1 = new SaveFileDialog();
sFileDialog1.InitialDirectory = "c:\\";
sFileDialog1.Filter = "Archivos de sql (*.sql)|*.sql";
sFileDialog1.FilterIndex = 1;
sFileDialog1.RestoreDirectory = true;
if (sFileDialog1.ShowDialog() == DialogResult.OK)
{
try
{
//se guarda el respaldo
try
{
string constr = "server=localhost;User Id=root;Persist Security Info=True;database=gym";
string file = sFileDialog1.FileName;
MySqlBackup mb = new MySqlBackup(constr);
mb.ExportInfo.FileName = file;
mb.ExportInfo.ExportViews = false;
if (System.IO.File.Exists(file))
System.IO.File.Delete(file);
mb.Export();
}
catch (Exception ex)
{
MessageBox.Show("Ocurrio un error " + ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show("Error del Sistema: " + ex.Message);
}
}
MessageBox.Show("Información guardada con exito");
}
