SMFHacks.com

I was able to import this data, thank you.

Now I have a question why there are only 127 countries, stopping after "K". For example, both Russia and Ukraine are missing from the list.

Please advise.

-- Dumping data for table `smf_geoip_countries`
--

/*!40000 ALTER TABLE `smf_geoip_countries` DISABLE KEYS */;
INSERT INTO `smf_geoip_countries` (`ci`,`cc`,`cn`) VALUES
 (1,'A1','Anonymous Proxy'),
 (2,'A2','Satellite Provider'),
 (3,'O1','Other Country'),
 (4,'AD','Andorra'),
 (5,'AE','United Arab Emirates'),
 (6,'AF','Afghanistan'),
 (7,'AG','Antigua and Barbuda'),
 (8,'AI','Anguilla'),
 (9,'AL','Albania'),
 (10,'AM','Armenia'),
 (11,'AN','Netherlands Antilles'),
 (12,'AO','Angola'),
 (13,'AP','Asia/Pacific Region'),
 (14,'AQ','Antarctica'),
 (15,'AR','Argentina'),
 (16,'AS','American Samoa'),
 (17,'AT','Austria'),
 (18,'AU','Australia'),
 (19,'AW','Aruba'),
 (20,'AX','Aland Islands'),
 (21,'AZ','Azerbaijan'),
 (22,'BA','Bosnia and Herzegovina'),
 (23,'BB','Barbados'),
 (24,'BD','Bangladesh'),
 (25,'BE','Belgium'),
 (26,'BF','Burkina Faso'),
 (27,'BG','Bulgaria'),
 (28,'BH','Bahrain'),
 (29,'BI','Burundi'),
 (30,'BJ','Benin'),
 (31,'BL','Saint Bartelemey'),
 (32,'BM','Bermuda'),
 (33,'BN','Brunei Darussalam'),
 (34,'BO','Bolivia'),
 (35,'BR','Brazil'),
 (36,'BS','Bahamas'),
 (37,'BT','Bhutan'),
 (38,'BV','Bouvet Island'),
 (39,'BW','Botswana'),
 (40,'BY','Belarus'),
 (41,'BZ','Belize'),
 (42,'CA','Canada'),
 (43,'CC','Cocos (Keeling) Islands'),
 (44,'CD','Congo ( Republic of)'),
 (45,'CF','Central African Republic'),
 (46,'CG','Congo'),
 (47,'CH','Switzerland'),
 (48,'CI','Cote d\'Ivoire'),
 (49,'CK','Cook Islands'),
 (50,'CL','Chile'),
 (51,'CM','Cameroon'),
 (52,'CN','China'),
 (53,'CO','Colombia'),
 (54,'CR','Costa Rica'),
 (55,'CU','Cuba'),
 (56,'CV','Cape Verde'),
 (57,'CX','Christmas Island'),
 (58,'CY','Cyprus'),
 (59,'CZ','Czech Republic'),
 (60,'DE','Germany'),
 (61,'DJ','Djibouti'),
 (62,'DK','Denmark'),
 (63,'DM','Dominica'),
 (64,'DO','Dominican Republic'),
 (65,'DZ','Algeria'),
 (66,'EC','Ecuador'),
 (67,'EE','Estonia'),
 (68,'EG','Egypt'),
 (69,'EH','Western Sahara'),
 (70,'ER','Eritrea'),
 (71,'ES','Spain'),
 (72,'ET','Ethiopia'),
 (73,'EU','Europe'),
 (74,'FI','Finland'),
 (75,'FJ','Fiji'),
 (76,'FK','Falkland Islands (Malvinas)'),
 (77,'FM','Micronesia'),
 (78,'FO','Faroe Islands'),
 (79,'FR','France'),
 (80,'FX','France Metropolitan'),
 (81,'GA','Gabon'),
 (82,'GB','United Kingdom'),
 (83,'GD','Grenada'),
 (84,'GE','Georgia'),
 (85,'GF','French Guiana'),
 (86,'GG','Guernsey'),
 (87,'GH','Ghana'),
 (88,'GI','Gibraltar'),
 (89,'GL','Greenland'),
 (90,'GM','Gambia'),
 (91,'GN','Guinea'),
 (92,'GP','Guadeloupe'),
 (93,'GQ','Equatorial Guinea'),
 (94,'GR','Greece'),
 (95,'GS','South Georgia / South Sandwich Islands'),
 (96,'GT','Guatemala'),
 (97,'GU','Guam'),
 (98,'GW','Guinea-Bissau'),
 (99,'GY','Guyana'),
 (100,'HK','Hong Kong'),
 (101,'HM','Heard Island and McDonald Islands'),
 (102,'HN','Honduras'),
 (103,'HR','Croatia'),
 (104,'HT','Haiti'),
 (105,'HU','Hungary'),
 (106,'ID','Indonesia'),
 (107,'IE','Ireland'),
 (108,'IL','Israel'),
 (109,'IM','Isle of Man'),
 (110,'IN','India'),
 (111,'IO','British Indian Ocean Territory'),
 (112,'IQ','Iraq'),
 (113,'IR','Iran'),
 (114,'IS','Iceland'),
 (115,'IT','Italy'),
 (116,'JE','Jersey'),
 (117,'JM','Jamaica'),
 (118,'JO','Jordan'),
 (119,'JP','Japan'),
 (120,'KE','Kenya'),
 (121,'KG','Kyrgyzstan'),
 (122,'KH','Cambodia'),
 (123,'KI','Kiribati'),
 (124,'KM','Comoros'),
 (125,'KN','Saint Kitts and Nevis'),
 (126,'KP','Korea (People\'s Republic)'),
 (127,'KR','Korea  (Republic of)');
/*!40000 ALTER TABLE `smf_geoip_countries` ENABLE KEYS */;

Your GeoIP Location mod installed fine but the "Install the GeoIP Database" process only partially finished:

smf_geoip_blocks = Empty, but I assume it contains data only once IP blocks occur
smf_geoip_countries = Populated with 126 countries
smf_geoip_ip = Empty
smf_geoip_ip_temp = Empty
smf_geoip_regions = Populated with 4056 regions (cities)

I'm seeing:

Database Choice  Country & CityCountry OnlyManual This will install the MaxMind GeoCityLite database on your forum. This option provides the greatest geographic information (City/State/Region/Country) for a given IP address. You have the zip extension installed so this option should install without a problem.

And this:

The Database is not installed
Last Update Status: Database Import Error

This is my own dedicated server with lots of memory and cpu, and I control the configuration so can make any necessary tweaks.

Might someone be able to assist? I'll be happy to pay a reasonable consulting fee to a qualified and trustworthy consultant.