Maxmind proxy
`accuracy_radius` smallint unsigned NOT NULL `is_satellite_provider` tinyint(1) NOT NULL, `is_anonymous_proxy` tinyint(1) NOT NULL, `represented_country_geoname_id` int unsigned NOT NULL, `registered_country_geoname_id` int unsigned NOT NULL, All the code below is based off of that data structure at the time of this writing which might have changed since then. List of all IP address data columns and their datatypes is described at GeoIP2 City and Country CSV Databases page on their website.
We first create two tables inside our database: "ip_blocks" and "ip_locations". Next step is preparing to import all that data into our database. The database we're interested is their GeoLite2 City in its CSV Format that can be downloaded from here.Äownload it and unzip it and you should get a directory named GeoLite2-City-CSV_20160503 or something similar to that with a bunch of CSV files in it.
One of the most popular products available that provides such functionality is the GeoIP2 by MaxMind. So to do that, we need to get ahold of some "ip-to-location" database and do all that querying from our own computer/server. You do any type of mass-querying for large number of IP addresses. There are plenty of websites online that will show you the precise geographic location of any IP address, but very few will let Many times in determining the usefulness of some proxy server, you need to know where that proxy server is located at.
#MAXMIND PROXY INSTALL#
Install GeoLite2 into your mySQL Database