File Sources:
The base of all ist the maxmind geocity database. you can download it from http://www.maxmind.com/app/geolitecity . I always use the csv file.
If you want to use an auto download script, use this link
http://geolite.maxmind.com/download/geoip/database/GeoLiteCity_CSV/GeoLiteCity_20091001.zip
The filename of the zip file is based on simple date function GeoLiteCity_YearMonthRelease.zip
Import to database:
The next step is to import the data to an database. im my case i use mysql.
you have to create 2 tables with the folowing structure:
Table blocks:
startIpNum (bigint(16))
endIpnum (bigint(16))
locId (bigint(12))
Table location:
locId (bigint(12))
country (varcahr(60))
country_code (varchar(2))
region (varchar(80))
region_code (varchar(80))
city (varchar(60))
postalCode (varchar(10))
latitude float
longitude float
metroCode (varchar(3))
areaCode (varchar(3))
when the tables are ready, import the csv files in the database. The best way to do that is to use an client like sqlyog
or the mysql gui tolls (freeware). http://dev.mysql.com/downloads/gui-tools/5.0.html
