Hey there, I'm trying to import data from a csv file using LOAD and after the bash starts mysql and I run the LOAD DATA command, I get this error. Here's my command:
mysql -u mykl -p -h mysql.server mykl\$eval --local_infile=1 -e "LO AD DATA LOCAL INFILE '/home/mykl/EvalCats.txt' REPLACE INTO TABLE eval_category FIELDS TERMINATED BY ',' ENCLO SED BY '\"' ESCAPED BY '\"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;"
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
Thanks, Mykl