I've gotten quite a few requests to offer a fully populated database of IP Address Locations, etc. The following have been generously mirrored for us:

hostip_current.sql.gz
hostip_current.sql.bz2

The jury is still out on whether this is the best way to do it. However, we have just begun mirroring using rsync so we can offer daily updates to the database. Plus, there are now several formats to choose from in the rsync area (MySQL, BDB, CSV). Note: we are actively looking for rsync mirrors so please shoot us an email if you're interested!

rsync://hostip.info/hostip - Main Mirror
rsync://hostip.moria.org/hostip - US, Texas
rsync://wildwolf.fr/hostip - France
rsync://rsync.slrclub.com/hostip - Korea

Below are a few of our super-helpful mirrors that have done the rsync for you:

Wayne State University: (http | ftp)

Please don't use this as a leech service. If you plan on doing daily updates - leave the copy around so rsync can do it's job and only transfer the changed bytes. Let it do what it's good at :) What this means: run the command below and keep the files around and just sync them for updates instead of deleting them all after each run...

rsync -avz --progress [pick from an rsync URL above] ./

This all is quite a bit of effort, and is aimed towards the programmer and those that want to integrate the public IP database into their application (or study it). For casual use, please use the API which requires no installation on your part. All we ask is a link to the site so others can see what www.hostip.info is all about.

The instructions below will get you started with a local virgin DB and populate it with the changes data posted on the site at the link below. This method involves only downloading about 1 MBytes worth of data, and constructing the database from that.

You'll need a PHP interpreter that includes the 'ftp' and 'mysql' modules (on Redhat Linux systems, this is /usr/bin/php) and a MySQL database (actually others will do just as well, I happen to use MySQL). Disclaimer: the below instructions work for me on a Redhat Linux 9 box. Your mileage may vary, but if it does, then please let me know.

The process is fairly simple assuming you've used MySQL before. You'll need to set up the database to allow your user access to create tables, or you can log in as root (not recommended :-).

The updates are generated once per month, on a random day in the month. If you want to grab monthly updates, please do so on the 9th day of the month. This is a randomly allocated day, and will help spread the load on the server throughout the month. The updates are constructed such that you can safely re-apply an old update, to facilitate auto-downloading.

Please remember that this is a free service, and if everyone connects to the server on the 1st of the month and blindly downloads the latest update whether it's changed or not, I'll be forced to close it down. Please use the day above. The internet was born in a spirit of sharing. Don't spoil it.

Get a copy of your favorite SVN utilities and do a checkout on the SVN repository (the trunk is listed here, you can retrieve a branch too if you'd feel more comfortable):

svn co svn://hostip.info/hostip/api/trunk hostip
	

Yes it's true, there's not much in there right now - and since we're working on migrating this whole database to a new structure we're not spending all that much time developing an 'api' per se, except for the Online IP Address Lookup API since that should remain relatively constant.