title: Issue with MySqlBulkLoader from C# app
body: <p>I am writing an app to export some data from MSSQL to a MySQL server on a nightly basis. I use a simple query to grab all the data for the previous day and have then tried a few different approaches for getting it to MySQL. The fastest approach is using MySqlBulkLoader but for some reason it isn't moving all the data. After I do the insert, I am comparing the records in the text file that was generated to the number of records that are in MySQL and the counts are off from 1 in some cases all the way up to 10.</p>
  
  <p>If I do the same approach for getting the data to the text file but loop through each row of the text file rather than bulk upload and do insert statements, all the records get imported.</p>
  
  <p>Here is the bulk upload code I am currently using. I recently added the FieldQuotationCharacter to see if that would help and it didn't (when I added that, I made the text generation script enclose fields in quotes).</p>
  
  <pre><code>uploader.TableName = "testtable";
  uploader.FieldTerminator = "\t";
  uploader.LineTerminator = "\r\n";
  uploader.NumberOfLinesToSkip = 0;
  uploader.FileName = updateFile; //this is a variable pointing to the current file
  uploader.Timeout = 120;
  uploader.FieldQuotationCharacter = '"';
  int totalExported = uploader.Load();
  </code></pre>
  
  <p>Any ideas?</p>