importuoju duomenis is tekstinio failo i mysql 5 tokia komanda
>mysqlimport --host=192.168.1.4 -p --fields-terminated-by="\t" --lines-terminated-by="\r\n" 
> --columns=name,description,category,subcategory,price --ignore-lines=1 --local
 --replace --user=root testdb "item.txt"
Enter password: *********
mysqlimport: Error: Cannot delete or update a parent row: a foreign key 
constraint fails (`testdb/location`, CONSTRAINT `item_id_refs_name_374a2a88` 
FOREIGN KEY
(`item_id`) REFERENCES `item` (`name`)), when using table: item

Ka mysqlimport yra toks durnas, kad bando updatinti key?
sql sakinyje as isvis nerasyciau "set name='abc' where name='abc'", o sitas 
daiktas matomai bando tai daryti.
Ar yra koks budas priversti mysqlimport tokiu nesamoniu nedaryti