Notes

// DatabaseBackupRepository.cs
using System;
using System.Diagnostics;
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;

// Backup file path
string backupFolder = @"D:MySqlBackups";
string backupFileName = $"{databaseName}_{DateTime.Now:yyyyMMddHHmmss}.sql";
string backupFilePath = System.IO.Path.Combine(backupFolder, backupFileName);

// Ensure backup directory exists
if (!System.IO.Directory.Exists(backupFolder))
{
System.IO.Directory.CreateDirectory(backupFolder);
}

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

// Start the mysqldump process
ProcessStartInfo processInfo = new ProcessStartInfo
{
FileName = "cmd.exe",
RedirectStandardInput = true,
RedirectStandardOutput = true,
CreateNoWindow = true,
UseShellExecute = false
};

using (Process process = new Process { StartInfo = processInfo })
{
process.Start();
using (var writer = process.StandardInput)
{
if (writer.BaseStream.CanWrite)
{
writer.WriteLine($"mysqldump {command}");
}
}
process.WaitForExit();
}

Console.WriteLine("Database backup completed successfully.");
}
catch (Exception ex)
{
Console.WriteLine($"Error occurred while backing up the database: {ex.Message}");
}
}
}
////////////
// DatabaseBackupController.cs
using Microsoft.AspNetCore.Mvc;

[Route("api/[controller]")]
[ApiController]
public class DatabaseBackupController : ControllerBase
{
private readonly DatabaseBackupRepository _backupRepository;

public DatabaseBackupController(DatabaseBackupRepository backupRepository)
{
_backupRepository = backupRepository;
}

[HttpPost("backup")]
public IActionResult BackupDatabase()
{
_backupRepository.BackupDatabase();
return Ok("Database backup initiated.");
}
}

/////////builder.Services.AddScoped<DatabaseBackupRepository>();

/////
// BackupService.cs
using System.Net.Http;
using System.Threading.Tasks;
using Microsoft.Extensions.Configuration;

public class BackupService
{
private readonly HttpClient _httpClient;
private readonly string _apiUrl;

public BackupService(HttpClient httpClient, IConfiguration configuration)
{
_httpClient = httpClient;
_apiUrl = configuration.GetSection("ApiSettings:BackupApiUrl").Value;
}

public async Task<string> BackupDatabaseAsync()
{
var response = await _httpClient.PostAsync($"{_apiUrl}/api/DatabaseBackup/backup", null);
response.EnsureSuccessStatusCode();
return await response.Content.ReadAsStringAsync();
}
}
/////////
// WebBackupController.cs
using Microsoft.AspNetCore.Mvc;
using System.Threading.Tasks;

public class WebBackupController : Controller
{
private readonly BackupService _backupService;

public WebBackupController(BackupService backupService)
{
_backupService = backupService;
}

[HttpPost("start-backup")]
public async Task<IActionResult> StartBackup()
{
var result = await _backupService.BackupDatabaseAsync();
return Ok(result);
}
}