title: Incomplete data from Online MySqlDatabase to DataTable
body: <p>I am trying to save an online MySql database to a local Sqlite database. What I do is, try to get whole data from MySql to a datatable then from the datatable save it to the Sqlite. So, I tried to make sure that I get all the data from the MySql first counting the datatable through "Console.printLine". </p>
  
  <p>The problem is, when I count the data in the PhpMyAdmin of the MySql, using <code>SELECT COUNT(REFENCE)</code> I get a count of 83,335 rows but in my Console.WriteLine, using the increment +1, I only get up to 3,857 rows which made me to believe that what I am getting is incomplete. Can you show me where I am wrong. If you have better way of copying then Online MySql "table" data to Sqlite table that would be great. Thank you.</p>
  
  <pre><code>private void buttonX1_Click(object sender, EventArgs e)
  {
      const string sql1 =
            @"SELECT reference, DATE(trx_date) as 'date', chassis_nmbr, status, remarks, 
              approved_by, DATE(date_approved), branch_code FROM jobcomp_hdr;";
      var table = new DataTable("onlineData");
      using (var conn = new DwoAccess().ConnectToMySql())
      {
          using (var cmd = new MySqlCommand(sql1, conn))
          {
              try
              {
                   cmd.CommandTimeout = 60;
                   var adapt = new MySqlDataAdapter(cmd);
                   conn.Open();
                   adapt.Fill(table);
               }
               catch (Exception ex)
               {
                   //ignore
               }
           }
       }
       var x=0;
       foreach (DataRow row in table.Rows)
       {
            Console.WriteLine(row["reference"].ToString());
            x += 1;
       }
       Console.WriteLine(x.ToString());
  }
  </code></pre>