HeidiSQL export and import csv issue

[calasoren]

Hi Everyone,

I am hoping someone can assist with this, I am trying to export the merchantlist to a file *currently I have been attempting an Export grid rows with delimited text* Example of first 2 lines below

merchantid;slot;item;faction_required;level_requir ed;alt_currency_cost;classes_required;probability
27;1;50011;-100;0;0;65535;100

After this I add my addition lines with the same format and attempt to do an import CSV file back to the table with a replace (duplicates). I have attempted many adjustments to the settings between the export and import with no luck. Below is an error that I am seeing.

LOAD DATA LOW_PRIORITY LOCAL INFILE 'C:\\Users\\Andrew\\Desktop\\Merchantlistlatest.cs v' REPLACE INTO TABLE `peq`.`merchantlist` FIELDS TERMINATED BY ' ;' ESCAPED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (`merchantid`, `slot`, `item`, `faction_required`, `level_required`, `alt_currency_cost`, `classes_required`, `probability`);
/* SQL Error (1265): Data truncated for column 'merchantid' at row 1 */


I apologize for the question but I am very new to trying to read the error being produced and cant seem to come up with the possible issue. Is anyone able to recognize the issue or do you have a better method of me adding larger amounts of database table entries quickly?

Thanks so much for your assistance