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
/ 93,906 rows imported in 73.812 seconds. /
/ 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?