Devart Forums

Code: Select all

using System;
using Devart.Data;
using Devart.Data.MySql;
using System.IO;
using System.Text.RegularExpressions;

namespace ConsoleApp_dump
{
    class Program
    {
        static void Main(string[] args)
        {
            string cs = "User Id=user;Password=1111;Host=mysql.local;Database=world;";
            string dumpFile = "dupm.sql";
            string partsFiles = "dupm.sql.";
            int maxPartSize = 50000;


            MySqlConnection conn = new MySqlConnection(cs);
            conn.Open();
            MySqlDump dump = new MySqlDump(conn);
            dump.UseExtSyntax = true;
            dump.CommitBatchSize = 2000;
            
            dump.Backup(dumpFile);
            
            int bytesWrite = 0;
            int partsCount = 0;
            StreamWriter sw =  new StreamWriter(partsFiles + partsCount, false);

            using (StreamReader reader = new StreamReader(dumpFile))
            {
                string sql = "";
                string line;
                while ((line = reader.ReadLine()) != null)
                {
                    sql += line + "\n";
                    if (Regex.IsMatch(sql, @";\n$"))
                    {
                        if (bytesWrite + sql.Length > maxPartSize)
                        {
                            sw.Close();
                            partsCount++;
                            sw = new StreamWriter(partsFiles + partsCount, false);
                            bytesWrite = 0;
                        }                        
                        sw.WriteLine(sql);
                        bytesWrite += sql.Length;
                        sql = "";
                    }
                }
            }
            sw.Close();
        }
    }
}