C#批量导出Mysql数据

1.引言
导出所有历史数据大概3-4K张表，几十个G。
2.全部代码

//输出地址
private static string outPut = ConfigurationManager.AppSettings["OutPutPath"].ToString();
//连接字符串
private static string connStr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
//数据库名称
private static string dbName = ConfigurationManager.AppSettings["DbName"].ToString();
static void Main(string[] args)
{string path = outPut + "\\" + DateTime.Now.ToString("yyyy-MM-dd");if (Directory.Exists(path)){Directory.Delete(path, true);}Directory.CreateDirectory(path);using (MySqlConnection connection = new MySqlConnection(connStr)){connection.Open();MySqlDataAdapter adapter = new MySqlDataAdapter($"select table_name from information_schema.tables where table_schema='{dbName}'", connection);DataTable dataTable = new DataTable();adapter.Fill(dataTable);if (dataTable.Rows.Count > 0){foreach (DataRow row in dataTable.Rows){string str2 = row[0].ToString();Console.WriteLine($"正在导出{str2}表");using (MySqlCommand command = new MySqlCommand($"select * from {str2}", connection)){command.CommandTimeout = 600;using (MySqlDataReader reader = command.ExecuteReader()){using (FileStream stream = new FileStream($"{path}\\{str2}.txt", FileMode.Create)){using (StreamWriter writer = new StreamWriter(stream, Encoding.UTF8)){if (reader.HasRows){while (reader.Read()){int fieldCount = reader.FieldCount;string stringLine = GetStringLine(reader, fieldCount);writer.WriteLine(stringLine);}}}}}}Console.WriteLine($"导出{str2}表完成");}}Console.WriteLine("全部导出完成");}
}
private static string GetStringLine(MySqlDataReader ritem, int cnum)
{StringBuilder builder = new StringBuilder();for (int i = 0; i < cnum; i++){builder.Append(ritem[i].ToString() + "\t");}return builder.ToString();
}