/// <summary>
/// Handles the Click event of the SelectBackupDumpFileButton control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param>
private void SelectBackupDumpFileButton_Click(object sender, RoutedEventArgs e)
{
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
dlg.InitialDirectory = ConfigurationXmlHandler.GetBackupLocation();
dlg.DefaultExt = ".dump";
dlg.Filter = "Backup Dump Files (*.dump)|*.dump|SQL Dump Files (*.sql)|*.sql";
Boolean?hasSelected = dlg.ShowDialog();
if (hasSelected == true)
{
TextRestoreFile.Text = dlg.FileName;
}
}
/// <summary>
/// Creates the backup location.
/// </summary>
/// <param name="hostName">Name of the host.</param>
/// <param name="databaseName">Name of the database.</param>
/// <param name="backupLocation">The backup location.</param>
/// <returns></returns>
private bool CreateBackupLocation(string hostName, string databaseName, out string backupLocation)
{
bool error = false;
backupLocation = ConfigurationXmlHandler.GetBackupLocation() + hostName + @"\" + databaseName + @"\";
if (!Directory.Exists(backupLocation))
{
try
{
Directory.CreateDirectory(Path.GetDirectoryName(backupLocation));
}
catch (Exception ex)
{
error = true;
new LogHandler().LogMessage(LogHandler.MessageType.ERROR, "Cannot create directory " + backupLocation + Environment.NewLine + ex.ToString());
}
}
return(!error);
}
/// <summary>
/// Deletes the old backup files.
/// </summary>
private void DeleteOldBackupFiles()
{
logHandler = new LogHandler();
int days = ConfigurationXmlHandler.GetDeleteBackupsOlderThanDays();
string backupLocation = ConfigurationXmlHandler.GetBackupLocation();
if (days > 0)
{
try
{
ProcessDeleteFiles(backupLocation, days + 1); //Add 1 to number of days, since it has to delete files older than the specified number of days
logHandler.LogMessage(LogHandler.MessageType.INFO, string.Format("Cleaned up backup files older than {0} days", days));
}
catch (Exception ex)
{
logHandler.LogMessage(LogHandler.MessageType.ERROR, string.Format("Error while cleaning up files older than {0} days: {1}", days, ex.ToString()));
}
}
}
/**
* Synchronise with the values from the Configuration file.
*/
private void SyncFromConfiguration()
{
this.backupLocation = ConfigurationXmlHandler.GetBackupLocation();
this.deleteBackupAfterDays = ConfigurationXmlHandler.GetDeleteBackupsOlderThanDays();
}
public void RetrieveBackupLocationTest()
{
string backupLocation = ConfigurationXmlHandler.GetBackupLocation();
Assert.AreEqual(@"C:\ProgramData\MySQLBackup\Backup\", backupLocation);
}