title: Import CSV file into the MySQL database
body: <p>I have records into <code>.CSV</code> file and I want to import them into <code>MySQL</code> database.</p>
  
  <p>Whenever I import the <code>.CSV</code> I get the message <code>Import has been successfully finished...</code> but only 79 out of 114 records are be inserted into the database.</p>
  
  <p>When I try to import the <code>.CSV</code> file with 411 records, just 282 are be inserted. The CSV file which got 411 records includes two categories of records <code>Active and Sold</code> whereby 114 records are Active.</p>
  
  <p>Has someone gotten this type of problem? If so what should be done?</p>