mysql - SQL - LOAD DATA INFILE - UTF8 issue -

mysql - SQL - LOAD DATA INFILE - UTF8 issue -

i few big database exported .txt (its around 5gb each) found out can easy import

load info local infile '/path/pet.txt' table pet;

it works having problem utf-8 there, because texts displaying podb¦h z l dodateln¦ zpracovat column charset set utf-8 , in .txt file displayed ok, problem somewhere in import. thought how can import without problems?

i found : loading utf-8 encoded text mysql table

load info local infile '/path/pet.txt' table pet character set utf8;

mysql sql utf-8