Mega Code Archive

 

Categories / MySQL / Backup Load

 

If you are using a Linux system, replace the rn in the LINES TERMINATED BY syntax command with just n

LOAD DATA INFILE '/mysql/data/DataFile.txt' INTO TABLE cust_num_names FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';