[Whitetiger]

it is the GeoLite free databases

Quote:

Originally Posted by Richie I get: Country, ISP, City = unknown. When i check my IP @ maxmind site all info shows, why?

pm me your ip and ill see if i can get it to work

EDIT: if people really want use in mysql ill post the last mysql version i have, but i can't promise that it will even work, you're welcome to edit it

What you need:

- SQL db tables: http://pastebin.com/9H2Pj1zS
- MaxMind Country database, City database, and GeoASN In .CSV format (its all on there site)
- mysql database

when importing the files you should do them like this:



with the corresponding tables

GeoIPASNum2.csv -> geo_isp
GeoIPCountryWhois.csv -> ip_country
GeoLiteCity-Blocks.csv -> ip_city
GeoLiteCity-Location.csv -> ip_city_locations

Download (mysql FS usage example)
Download (mysql FS usage example, pastebin)

I highly recommend you dont use mysql!

edit 2: there was a problem with the original .inc, please update it will save you time in the long run