I ran below SQL query against my MySQL database:
load data local infile '/tmp/ad_packs.csv' into table ad_packs fields terminated by ',' enclosed by '"' lines terminated by '\n' (company_name,pack_size,remaining,ad_pack_purchase_officer,advertising_contact_officer,updated_ad_pack,email,phone,website,note,organisation_id,categories,modified)
This seems to insert only one row and I already checked the csv and it has heading so it only inserts the first row which is the header.
Is there a reason why?
Are you sure sure your lines are terminated by