0

Today I tried importing 44.555 row from excel files to MySql database using heidiSQL, but why only 1.662 imported to database

two last row in excel

All row result in mysql only 6 x 1.662

What is the maximum number of rows that Mysql can handle?

import window heiSQL

finaly , all 44.554 rows imported to database, open csv file with notepad, save as with encoding utf8 then csv ready to import..

ariowishnu
  • 35
  • 1
  • 8
  • MySQL's max row count is not 44K rows, assuming you don't have massive information in each row. Please post your exact error message. – Tim Biegeleisen Apr 21 '18 at 09:17
  • Please add your `import` code. – DEarTh Apr 21 '18 at 09:18
  • there is no error message when importing the csv files, import was succesed, but when i check with query SELECT in database, the result row have diffrent number with original in csv files. – ariowishnu Apr 21 '18 at 09:21
  • @jitendra : i dont import with code , im using heidiSQL with csv files – ariowishnu Apr 21 '18 at 09:23
  • If you have a PRIMARY or a UNIQUE KEY on the table and you use `INSERT IGNORE` or `REPLACE` in HeidiSQL, then some rows can be ignored or replaced. Please post a screenshot of your import window. – Paul Spiegel Apr 21 '18 at 09:26
  • in bottom panel log command HeidiSQL it said : LOAD DATA LOW_PRIORITY LOCAL INFILE 'F:\\Toegoemlyo\\Documents\\upload_db\\jaminan.csv' INTO TABLE `test`.`migrasi` CHARACTER SET utf8 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (`no_label`, `nama_debitur`, `rek_loan`, `jaminan`, `mbu`, `tgl_terima`); /* SQL Error (1300): Invalid utf8 character string: '' */ , what is that mean ?? – ariowishnu Apr 21 '18 at 09:27
  • @paul Spiegel : screenshot posted – ariowishnu Apr 21 '18 at 09:33
  • 1
    Invalid utf8 character string : https://stackoverflow.com/questions/43408012/mysql-invalid-utf8-character-string-when-importing-csv-table – DEarTh Apr 21 '18 at 09:52

0 Answers0