LOAD DATA
INFILE 'person.db'
BADFILE 'person.bad'
DISCARDFILE 'person.dsc'
REPLACE
INTO TABLE persontable
FIELDS TERMINATED BY ';'
 (name, age, occup)