Backup Load MySQL

  1. Home
  2. MySQL
  3. Backup Load
  4. 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';