Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Limits with CSV import

dslater@ocln.org's profile image dslater@ocln.org posted 5 days ago in Import/Export Permalink

Hello - I'm new to the forum but I've been using HeidiSQL for about 3 years.

I'm running into a problem with a CSV import that has me stumped.

Each month I add approximately 180,000 rows from a CSV file to a table - it has been working fine since last week. No matter what I do with the current file, only 90,000 +/- rows are added.

One odd thing I noticed is that the status indicator at the bottom right of the window frame, seems to be calulating the % based on the ~90,000 records as opposed to the full 180,000.

Here is a the log from my last attempt: SHOW CREATE TABLE db_name.table_name;

/ 93,906 rows imported in 73.812 seconds. /

SHOW WARNINGS;

/ Warning (1265): Data truncated for column 'ISBN' at row 1 / / Warning (1265): Data truncated for column 'Key' at row 1 / / Warning (1265): Data truncated for column 'ISBN' at row 2 / / Warning (1265): Data truncated for column 'Key' at row 2 /

The warning message repeats for 32 rows - but I've always had similar warnings in the past.

The table currently has 3,482,099 (including the 98,000 from my most recent load attempt.)

Does anyone have any ideas as to what might be causing the problem?

Thanks

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.