private void btnExaminar_Click(object sender, EventArgs e)
{
backupsave.FileName = "aoidb";
backupsave.DefaultExt = ".bak";
backupsave.OverwritePrompt = true;
backupsave.Title = "Hacer una Copia de Seguridad";
this.txt_nom.Text = backupsave.FileName;
if (backupsave.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
this.txt_path.Text = backupsave.FileName;
}
}
private void btnBackup_Click(object sender, EventArgs e)
{
String conexion_cadena = "server=localhost; username=root; password=root; database=aoidb";
MySqlConnection conexion
= new MySqlConnection
(conexion_cadena
);
try
{
conexion.Open();
MySqlCommand cmd
= new MySqlCommand
("BACKUP DATABASE " + this.txt_nom.Text + " TO DISK = N' " + backupsave
.FileName.ToString() + " ' WITH NOFORMAT, INIT, NAME = N 'aoidb-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 ", conexion
);
cmd.ExecuteNonQuery();
MessageBox.Show("Se ha creado un BackUp de La base de datos satisfactoriamente",
"Copia de seguridad de base de datos",
MessageBoxButtons.OK, MessageBoxIcon.Information);
conexion.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
"Error al copiar la base de datos",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}