...
3 - Execute the script below :to import the database
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); |
...