If your DualShield is using a MySQL database, follow the steps below to import "IP2LOCATION-LITE-DB5.CSV"
1 - Log into MySQL console
2 - Change to "DualShield" database:
mysql > use DualShield;
3 - Create a new Table called "Country_List"
mysql > CREATE TABLE country_List( country_code VARCHAR(255), country_name VARCHAR(255) );
3 - Execute the script below to import the database
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,latitude,longitude);
* replace "FILE-PATH-TO" with the actual file path where the downloaded file is saved, e.g. "C:\\Temp"
Please note that it can take about 30 minutes to import the data.