title: How to fix missing rows/data when exporting tables from DBeaver to MySQL database?
body: <p>I want to import a large csv file into MySQL and I use DBeaver to do so (faster). However data/records are missing when I finish exporting the table from DBeaver to MySQL database.</p>
  
  <p>What could be the reason for the missing data and how can I fix it?</p>
  
  <p>This is on macOS Mojave. I've imported the csv file to DBeaver (add connection) and ran the count(*) codes - there are 48744 records.</p>
  
  <p>However, when I exported the table to MySQL database and ran it again in MySQL - there are only 9021 records.</p>
  
  <p>SQL codes: "=select count(*) from table name"</p>
  
  <p>I expect the MySQL reads the same amount of records as that in DBeaver, but it only reads less than 20% of total records.</p>
  
  <p>Error messages during table export from DBeaver to MySQL database:</p>
  
  <p>"Error occurred during data load
  Reason:
  SQL Error [1406] [22001]: Data truncation: Data too long for column 'NAME_EDUCATION_TYPE' at row 1"</p>
  
  <p>The column type are all VARCHAR(20). I don't know where to change the data type to fit in more characters.</p>
  
  <p>Update 10/16:
  Here's the create table codes. The csv columns match the content.</p>
  
  <p>CREATE TABLE TEST.application_test(</p>
  
  <pre><code>SK_ID_CURR VARCHAR(20),
  
  NAME_CONTRACT_TYPE VARCHAR(20),
  
  CODE_GENDER VARCHAR(20),
  ...
  
  AMT_REQ_CREDIT_BUREAU_QRT VARCHAR(20),
  
  AMT_REQ_CREDIT_BUREAU_YEAR VARCHAR(20))
  </code></pre>