# Create tables: mysql -d ebi < //create_tables_without_select_from_original.sql # load export file into created table: load data local infile '//ebi_es_op_or_ebi_1021.csv' into table ebi_es_op_or_ebi_1021 character set utf8 fields terminated by ';' enclosed by '"' ignore 1 lines; # do the same for ebi_es_op_or_ebi_1021_innodb