private void btnBackup_Click(object sender, EventArgs e)
{
//Sin Usarse porque estan por separados los módulos de respaldo y restauración.
DateTime Hoy = DateTime.Now; //antes DateTime Hoy = DateTime.today;
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "SQL Script|*.sql";
saveFileDialog1.Title = "Save as Script File";
DBM.CLS.Utilities config = new CLS.Utilities();
saveFileDialog1.FileName = config.GetMySQL_DatabaseName() + " Date " + Hoy.ToString("dd-MM-yyyy HH.mm") + ".sql";
CLS.Utilities objConx = new CLS.Utilities();
string ConnectionString = objConx.GetConnectionString();
ConnectionString += ";charset=utf8;convertzerodatetime=true;";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
dumpFile = saveFileDialog1.FileName;
// Reset variables
curTable = 0;
totalTables = 0;
cancel = false;
// Initialize MySqlConnection and MySqlCommand components
conn = new MySqlConnection(ConnectionString);
cmd = new MySqlCommand();
cmd.Connection = conn;
conn.Open();
// Start the Timer here
timer2.Start();
mb.ExportInfo.IntervalForProgressReport = (int)nmImInterval.Value;
mb.Command = cmd;
bwExport.RunWorkerAsync();
}
}
private void ConnectionSettings_Load(object sender, EventArgs e)
{
CLS.Utilities objCnx = new CLS.Utilities();
txtServer.Text = objCnx.GetMySQL_ServerName();
txtPort.Text = objCnx.GetMySQL_Port().ToString();
txtBD.Text = objCnx.GetMySQL_DatabaseName();
txtUser.Text = objCnx.GetMySQL_UserName();
txtPass.Text = objCnx.GetMySQL_Password();
}
