If you have direct access to the server/command line, you can use the binary format. This offers better performance, but you will need to alter your PHP configuration to install the GeoIP extension or Pecl package. This then gives you access to some handy PHP functions: http://www.php.net/manual/en/ref.geoip.php
If you don't have access to the server config, you can download the CSV versions and import this into a MySQL DB. You will then have direct access to the data and you can write the relevant queries to produce the results required by your app. If you're using PHP MyAdmin MySQL panel, you can just download the CSV gz or zip and upload/import directly. You will need to create the tables first. Remember to create indexes on the relevant columns.
GeoLite City contains two tables, IP block/City and City Locations (lat/lng). GeoLite Country contains only IP blocks and country names.
If you don't need IP data, the World Cities Database may be more suitable: http://www.maxmind.com/en/worldcities
If you're only concerned with the second file of the geoIP city data, the following SQL will create a table with the necessary columns:
DROP TABLE IF EXISTS location;
CREATE TABLE location(
locId int(10) unsigned NOT NULL,
country char(2) NOT NULL,
region char(2) NOT NULL,
postalCode char(5) NOT NULL,
PRIMARY KEY (locId)
Presuming you mean under the PHPMyAdmin, I have found a query window I can open and can from there upload files, if this is not what you meant, could you please explain further how I would find out if I have direct access to the server/command line? Best Regards, Tim
Unless you have a dedicated or virtual server from 1&1 you probably don't have command line access. Stick with the CSVs. Yes use PHPMyAdmin. The following guide (taken from the Maxmind resources page) details what you need to do: bartomedia.blogspot.co.uk/2007/11/
The first part of this tutorial returns "MySQL said: #1044 - Access denied for user 'dbo458117895'@'%' to database 'geoip'"
If you're with 1&1, you've probably already created the database in your control panel. So just skip the first part. If you connect to the DB using PHPMyAdmin, you're already "using" the DB, whatever it may be called (not necessarily "geoip").
Skipping this step seems to get myself back on track with the tutorial. I'll continue but not set this as the answer just yet in case I need further assistance.