Importing the latest MaxMind GeoLite2 database into MySQL

php mysql geoip maxmind
xeo picture xeo · Oct 21, 2013 · Viewed 13.2k times · Source

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?

Answer

user19370 picture user19370 · Feb 17, 2014

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

Related questions

How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
Import file size limit in PHPMyAdmin

I have changed all the php.ini parameters I know: upload_max_filesize, post_max_size. Why am I still seeing 2MB? Im using Zend Server CE, on a Ubuntu VirtualBox over a Windows 7 host.

Read More
PDOException “could not find driver”

I have just installed Debian Lenny with Apache, MySQL, and PHP and I am receiving a PDOException could not find driver. This is the specific line of code it is referring to: $dbh = new PDO('mysql:host=' . DB_HOST . …

Read More