mysql --local-infile=1 -h localhost --port=3306 -u phillip --password=whatever -D home -e 'LOAD DATA LOCAL INFILE ''/home/phillip/docs/data.csv'' INTO TABLE people FIELDS TERMINATED BY '','' ESCAPED BY ''\\'' OPTIONALLY ENCLOSED BY ''"'' LINES TERMINATED BY ''\n'' (title, first_name, last_name, address1, address2, address3, city, state, country, zip, main_phone, alt_phone, mobile_phone, fax, pager, main_email, alt_email, url )'
ERROR at line 1: Unknown command '\'.
I am trying to use this command to do LOAD DATA INFILE in the case of a MySQL database instance where --local-infile is set to 0. I am getting the ERROR regarding the backslashes, but I don't know how to properly escape them to ensure they'll go away.
Can someone please help? I've been adding backslashes ad infinitum to no avail.
Thanx
Phil
