asp.netmysql数据库备份

-- 创建备份文件
SET @backup_file = CONCAT('/path/to/backup/', 'database_name_', NOW(), '.sql');

-- 执行备份
mysqldump --user=root --password=your_password database_name > @backup_file;

using System;
using System.Diagnostics;

public class DatabaseBackup
{
    public static void BackupDatabase(string dbName, string backupPath, string username, string password)
    {
        string backupCommand = $"mysqldump --user={username} --password={password} {dbName} > {backupPath}";

        Process process = new Process();
        process.StartInfo.FileName = "bash";
        process.StartInfo.Arguments = $"-c \"{backupCommand}\"";
        process.StartInfo.RedirectStandardOutput = true;
        process.StartInfo.UseShellExecute = false;
        process.Start();

        string output = process.StandardOutput.ReadToEnd();
        process.WaitForExit();

        if (process.ExitCode == 0)
        {
            Console.WriteLine("Backup completed successfully.");
        }
        else
        {
            Console.WriteLine("Backup failed.");
        }
    }
}