Forums

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

Have you tried without the -e argument and then run the query interactively?

yes, neither case worked. In the end I exported a SQL file and then used source to import

Cool. Glad you found a solution.