Introduction
A customer has a preference import a Geo Location database from another supplier other than IP2Location
The table the customer wishes to import is from https://db-ip.com/
This is fine to do however they do not include the country name in their csv file, plus they have an extra column called 'Continent_code' that is not included in the 'lp2loaction_db3' table that is already created on the dualshield database.
Therefore extra steps are to create a separate table to import a list of country codes, which we later load into ip2location_db3 table as we upload the data from the CSV file provided by https://db-ip.com/
The other requirement is that the ip address in the csv will need to be converted to integer format to match the datatype already specified on the ip2location_db3 table.
If your DualShield is using a MySQL database, follow the steps below to import "IP2LOCATION-LITE-DB5.CSV"
...