Как делать dump базы данных средствами c# в mysql

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21

using System.Diagnostics;

public static void DumpDatabase()
{
    string backupDir = @"C:ackups";
    string dbName = "my_database";
    string userName = "my_user";
    string password = "my_password";
    string dumpFileName = "my_database_dump.sql";

    Process process = new Process();
    process.StartInfo.FileName = "mysqldump";
    process.StartInfo.Arguments = $"--user={userName} --password={password} --databases {dbName} > {backupDir}/{dumpFileName}";
    process.StartInfo.UseShellExecute = false;
    process.StartInfo.RedirectStandardOutput = true;

    process.Start();
    process.WaitForExit();

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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

using System;
using System.IO;
using MySql.Data.MySqlClient;

public static void DumpDatabase()
{
    string backupDir = @"C:ackups";
    string dbName = "my_database";
    string userName = "my_user";
    string password = "my_password";
    string dumpFileName = "my_database_dump.sql";

    string connectionString = $"Server=localhost;Database={dbName};Uid={userName};Pwd={password};";

    using (MySqlConnection conn = new MySqlConnection(connectionString))
    {
        conn.Open();
        
        string dumpFilePath = Path.Combine(backupDir, dumpFileName);
        
        using (MySqlCommand cmd = new MySqlCommand())
        {
            using (StreamWriter writer = new StreamWriter(dumpFilePath))
            {
                cmd.Connection = conn;
                cmd.CommandText = $"SELECT * INTO OUTFILE '{dumpFilePath}' FROM your_table_name";
                cmd.ExecuteNonQuery();
            }
        }
    }
}