Backup Load MySQL

  1. Home
  2. MySQL
  3. Backup Load
  4. To export the passwd table in CSV format with CRLF-terminated lines, use this statement
SELECT * FROM passwd INTO OUTFILE '/tmp/passwd.txt'
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';