Backup Load MySQL

  1. Home
  2. MySQL
  3. Backup Load
  4. To specify a file format explicitly, use a FIELDS clause to describe the characteristics of fields within a line
LOAD DATA LOCAL INFILE 'mytbl.txt' INTO TABLE mytbl
FIELDS TERMINATED BY ':'
LINES TERMINATED BY '\r';