Notes

using System;
using System.Diagnostics;
using System.IO;
using Microsoft.Extensions.Configuration;
using MySql.Data.MySqlClient;

public class DatabaseBackupRepository
{
private readonly string _connectionString;

public DatabaseBackupRepository(IConfiguration configuration)
{
_connectionString = configuration.GetConnectionString("DefaultConnection");
}

public void BackupDatabase()
{
try
{
// Parse connection details
var builder = new MySqlConnectionStringBuilder(_connectionString);
string databaseName = builder.Database;
string username = builder.UserID;
string password = builder.Password;
string host = builder.Server;
uint port = builder.Port;

// Backup file name (stored in the application's working directory)
string backupFileName = $"{databaseName}_{DateTime.Now:yyyyMMddHHmmss}.sql";

// Define the mysqldump command arguments
string arguments = $"-u{username} -p{password} -h {host} -P {port} {databaseName}";

ProcessStartInfo processInfo = new ProcessStartInfo
{
FileName = "mysqldump",
Arguments = arguments,
RedirectStandardOutput = true,
RedirectStandardError = true,
UseShellExecute = false,
CreateNoWindow = true
};

using (Process process = new Process { StartInfo = processInfo })
{
process.Start();

// Capture the output and write it to the backup file
using (StreamWriter writer = new StreamWriter(backupFileName))
{
writer.Write(process.StandardOutput.ReadToEnd());
}

// Read any errors from the process
string errorOutput = process.StandardError.ReadToEnd();
process.WaitForExit();

if (process.ExitCode != 0)
{
throw new Exception($"Backup process failed with the following error: {errorOutput}");
}
}

Console.WriteLine($"Database backup completed successfully. File saved as: {backupFileName}");
}
catch (Exception ex)
{
Console.WriteLine($"Error occurred during database backup: {ex.Message}");
}
}
}