MySQL Query issues...

Ok, here is my query:

LOAD DATA INFILE '/home/ofhcom/ip-to-country.csv' INTO
TABLE `country_list` FIELDS TERMINATED BY ',' ENCLOSED BY '"'
ESCAPED BY '\' LINES TERMINATED BY '\r\n'

It's from a tutorial on this site for mass banning country IPs. I need this for a recent project I started and I'm getting alot of spam abuse from China. Anwyay, when I execute the query, it gives the following error:

ERROR: Unclosed quote @ 158
STR: '
SQL: LOAD DATA INFILE '/home/ofhcom/ip-to-country.csv' INTO
TABLE `country_list` FIELDS TERMINATED BY ',' ENCLOSED BY '"'
ESCAPED BY '\' LINES TERMINATED BY '\r\n'

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\r\n'' at line 3




Any ideas? I'm running MySQL 4.1.11-standard...

 

 

 

 

Top