Load CSV file into MySQL from MySQL terminal and solve “Invalid utf8mb4 character string” issue

mysql> load data local infile '/fullpath_to_csv/file.csv' into table sample_table character set latin1 fields terminated by ',' enclosed by '"' lines terminated by '\n' ignore 1 rows;

• latin1 is needed for utf8mb4 issues