Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Importing the latest MaxMind GeoLite2 database into MySQL

MaxMind is now offering a GeoLite2 DB as described on their site.

The trouble is that they no longer offer CSV download, only a binary MMDB binary database format.

I can't find anything online about how to unmangle the MMDB format and install it into my local MySQL database.

When I open the MMDB file in Notepad+, it's just a binary mess.

How can I use this MMDB file to populatte my local MySQL database?

like image 416
xeo Avatar asked Oct 21 '13 16:10

xeo


1 Answers

MaxMind is now offering a GeoLite2 DB as described on their site.

The trouble is that they no longer offer CSV download, only a binary MMDB binary database format.

They do, now:

Geolite2_city and Geolite2_country free CSV data bases

like image 55
user19370 Avatar answered Sep 28 '22 10:09

user19370