...
Code Block | ||
---|---|---|
| ||
mysql > LOAD DATA LOCAL INFILE 'FILE-PATH-TO\\IP2LOCATION-LITE-DB3.CSV' INTO TABLE ip2location_db3
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 0 LINES (ip_from,ip_to,country_code,country_name,region_name,city_name); |
* replace "FILE-PATH-TO" with the actual file path where the downloaded file is saved, e.g. "cC:\\downloadsTemp"
Please note that it can take about 30 minutes to import the data.
...