public void ExportarLinhasTableDados(ExportToFile exportToFile, string table)
{
var mySqlConnection = BackupMySqlConnection.CriarConexao();
var sql = string.Format("SELECT * FROM `{0}`;", table);
try
{
if (mySqlConnection.State != ConnectionState.Open)
{
mySqlConnection.Open();
}
using (var command = new MySqlCommand(sql, mySqlConnection))
{
var rdr = command.ExecuteReader();
var totalBytes = default(int);
if (!rdr.HasRows)
{
return;
}
_exportToFile.ExportWriteLine();
_exportToFile.ExportWriteLine(string.Format("LOCK TABLES `{0}` WRITE;", table));
_exportToFile.ExportWriteLine();
exportToFile.ExportWriteLine();
exportToFile.ExportWriteLine(string.Format("/*!40000 ALTER TABLE `{0}` DISABLE KEYS */;", table));
exportToFile.ExportWriteLine();
exportToFile.ExportWriteLine();
ExcluirIndex(table);
exportToFile.ExportWriteLine();
while (rdr.Read())
{
try
{
var sqlDataRow = GetValueString(rdr, table);
exportToFile.ExportWriteLine(sqlDataRow);
totalBytes += sqlDataRow.Length;
if (totalBytes < VariaveisGeral.LimiteCommit)
{
continue;
}
exportToFile.ExportWriteCommit();
totalBytes = 0;
}
catch (Exception e)
{
Console.Write("tabela ==> " + table);
Console.WriteLine(e);
}
}
exportToFile.ExportWriteLine();
exportToFile.ExportWriteLine(string.Format("/*!40000 ALTER TABLE `{0}` ENABLE KEYS */;", table));
exportToFile.ExportWriteLine();
IncluirIndex(table);
_exportToFile.ExportWriteLine();
_exportToFile.ExportWriteLine("UNLOCK TABLES;");
_exportToFile.ExportWriteLine();
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
