You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

If your DualShield is using a MySQL database, follow the steps below to import "IP2LOCATION-LITE-DB3.CSV"

1 - Log into MySQL console

2 - Change to "DualShield" database

mysql > use DualShield;

3 - Load data

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. "c:\downloads"



  • No labels