SMFHacks.com

SMFHacks.com => Site Discussion => Topic started by: kirkvan on June 24, 2017, 05:04:00 pm

Title: Importing GeoIP into MySQL
Post by: kirkvan on June 24, 2017, 05:04:00 pm
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.
Title: Re: Importing GeoIP into MySQL
Post by: SMFHacks on June 24, 2017, 05:47:48 pm
Did it error or timeout? Generally large databases I like to import via the serverside or another database tool then smf itself.
Title: Re: Importing GeoIP into MySQL
Post by: kirkvan on June 25, 2017, 10:30:20 am
Thanks for your reply. It was an error, not a timeout.

Can you point me to a step-by-step procedure to import the data server side?

Again, I'd be happy to pay a trusted provider -- like you or someone on your team -- a reasonable fee to handle this for me. There are a handful of countries I need to ban from registration.
Title: Re: Importing GeoIP into MySQL
Post by: SMFHacks on June 25, 2017, 03:18:16 pm
Here is a full database dump that you can use
http://www.smfhacks.com/geoipdb.zip
Title: Re: Importing GeoIP into MySQL
Post by: kirkvan on June 26, 2017, 09:41:45 am
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 */;
Title: Re: Importing GeoIP into MySQL
Post by: SMFHacks on June 26, 2017, 10:40:43 am
run this sql
Code: [Select]
DROP TABLE IF EXISTS `smf_geoip_countries`;
CREATE TABLE `smf_geoip_countries` (
  `ci` int(4) NOT NULL AUTO_INCREMENT,
  `cc` char(2) NOT NULL,
  `cn` varchar(255) NOT NULL,
  PRIMARY KEY (`ci`),
  KEY `cc` (`cc`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;
/*
  smf_geoip_countries
  -------------------
  Exporting all rows
*/
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (1, 'A1', 'Anonymous Proxy
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (2, 'A2', 'Satellite Provider
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (3, 'O1', 'Other Country
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (4, 'AD', 'Andorra
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (5, 'AE', 'United Arab Emirates
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (6, 'AF', 'Afghanistan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (7, 'AG', 'Antigua and Barbuda
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (8, 'AI', 'Anguilla
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (9, 'AL', 'Albania
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (10, 'AM', 'Armenia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (11, 'AN', 'Netherlands Antilles
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (12, 'AO', 'Angola
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (13, 'AP', 'Asia/Pacific Region
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (14, 'AQ', 'Antarctica
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (15, 'AR', 'Argentina
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (16, 'AS', 'American Samoa
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (17, 'AT', 'Austria
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (18, 'AU', 'Australia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (19, 'AW', 'Aruba
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (20, 'AX', 'Aland Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (21, 'AZ', 'Azerbaijan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (22, 'BA', 'Bosnia and Herzegovina
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (23, 'BB', 'Barbados
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (24, 'BD', 'Bangladesh
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (25, 'BE', 'Belgium
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (26, 'BF', 'Burkina Faso
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (27, 'BG', 'Bulgaria
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (28, 'BH', 'Bahrain
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (29, 'BI', 'Burundi
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (30, 'BJ', 'Benin
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (31, 'BL', 'Saint Bartelemey
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (32, 'BM', 'Bermuda
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (33, 'BN', 'Brunei Darussalam
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (34, 'BO', 'Bolivia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (35, 'BR', 'Brazil
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (36, 'BS', 'Bahamas
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (37, 'BT', 'Bhutan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (38, 'BV', 'Bouvet Island
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (39, 'BW', 'Botswana
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (40, 'BY', 'Belarus
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (41, 'BZ', 'Belize
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (42, 'CA', 'Canada
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (43, 'CC', 'Cocos (Keeling) Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (44, 'CD', 'Congo ( Republic of)
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (45, 'CF', 'Central African Republic
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (46, 'CG', 'Congo
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (47, 'CH', 'Switzerland
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (48, 'CI', 'Cote d''Ivoire
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (49, 'CK', 'Cook Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (50, 'CL', 'Chile
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (51, 'CM', 'Cameroon
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (52, 'CN', 'China
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (53, 'CO', 'Colombia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (54, 'CR', 'Costa Rica
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (55, 'CU', 'Cuba
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (56, 'CV', 'Cape Verde
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (57, 'CX', 'Christmas Island
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (58, 'CY', 'Cyprus
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (59, 'CZ', 'Czech Republic
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (60, 'DE', 'Germany
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (61, 'DJ', 'Djibouti
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (62, 'DK', 'Denmark
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (63, 'DM', 'Dominica
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (64, 'DO', 'Dominican Republic
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (65, 'DZ', 'Algeria
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (66, 'EC', 'Ecuador
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (67, 'EE', 'Estonia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (68, 'EG', 'Egypt
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (69, 'EH', 'Western Sahara
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (70, 'ER', 'Eritrea
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (71, 'ES', 'Spain
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (72, 'ET', 'Ethiopia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (73, 'EU', 'Europe
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (74, 'FI', 'Finland
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (75, 'FJ', 'Fiji
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (76, 'FK', 'Falkland Islands (Malvinas)
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (77, 'FM', 'Micronesia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (78, 'FO', 'Faroe Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (79, 'FR', 'France
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (80, 'FX', 'France Metropolitan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (81, 'GA', 'Gabon
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (82, 'GB', 'United Kingdom
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (83, 'GD', 'Grenada
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (84, 'GE', 'Georgia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (85, 'GF', 'French Guiana
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (86, 'GG', 'Guernsey
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (87, 'GH', 'Ghana
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (88, 'GI', 'Gibraltar
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (89, 'GL', 'Greenland
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (90, 'GM', 'Gambia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (91, 'GN', 'Guinea
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (92, 'GP', 'Guadeloupe
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (93, 'GQ', 'Equatorial Guinea
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (94, 'GR', 'Greece
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (95, 'GS', 'South Georgia / South Sandwich Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (96, 'GT', 'Guatemala
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (97, 'GU', 'Guam
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (98, 'GW', 'Guinea-Bissau
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (99, 'GY', 'Guyana
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (100, 'HK', 'Hong Kong
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (101, 'HM', 'Heard Island and McDonald Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (102, 'HN', 'Honduras
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (103, 'HR', 'Croatia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (104, 'HT', 'Haiti
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (105, 'HU', 'Hungary
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (106, 'ID', 'Indonesia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (107, 'IE', 'Ireland
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (108, 'IL', 'Israel
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (109, 'IM', 'Isle of Man
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (110, 'IN', 'India
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (111, 'IO', 'British Indian Ocean Territory
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (112, 'IQ', 'Iraq
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (113, 'IR', 'Iran
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (114, 'IS', 'Iceland
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (115, 'IT', 'Italy
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (116, 'JE', 'Jersey
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (117, 'JM', 'Jamaica
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (118, 'JO', 'Jordan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (119, 'JP', 'Japan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (120, 'KE', 'Kenya
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (121, 'KG', 'Kyrgyzstan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (122, 'KH', 'Cambodia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (123, 'KI', 'Kiribati
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (124, 'KM', 'Comoros
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (125, 'KN', 'Saint Kitts and Nevis
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (126, 'KP', 'Korea (Peoples Republic)
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (127, 'KR', 'Korea  (Republic of)
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (128, 'KW', 'Kuwait
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (129, 'KY', 'Cayman Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (130, 'KZ', 'Kazakhstan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (131, 'LA', 'Lao Peoples Democratic Republic
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (132, 'LB', 'Lebanon
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (133, 'LC', 'Saint Lucia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (134, 'LI', 'Liechtenstein
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (135, 'LK', 'Sri Lanka
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (136, 'LR', 'Liberia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (137, 'LS', 'Lesotho
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (138, 'LT', 'Lithuania
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (139, 'LU', 'Luxembourg
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (140, 'LV', 'Latvia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (141, 'LY', 'Libyan Arab Jamahiriya
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (142, 'MA', 'Morocco
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (143, 'MC', 'Monaco
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (144, 'MD', 'Moldova
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (145, 'ME', 'Montenegro
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (146, 'MF', 'Saint Martin
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (147, 'MG', 'Madagascar
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (148, 'MH', 'Marshall Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (149, 'MK', 'Macedonia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (150, 'ML', 'Mali
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (151, 'MM', 'Myanmar
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (152, 'MN', 'Mongolia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (153, 'MO', 'Macao
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (154, 'MP', 'Northern Mariana Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (155, 'MQ', 'Martinique
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (156, 'MR', 'Mauritania
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (157, 'MS', 'Montserrat
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (158, 'MT', 'Malta
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (159, 'MU', 'Mauritius
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (160, 'MV', 'Maldives
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (161, 'MW', 'Malawi
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (162, 'MX', 'Mexico
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (163, 'MY', 'Malaysia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (164, 'MZ', 'Mozambique
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (165, 'NA', 'Namibia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (166, 'NC', 'New Caledonia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (167, 'NE', 'Niger
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (168, 'NF', 'Norfolk Island
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (169, 'NG', 'Nigeria
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (170, 'NI', 'Nicaragua
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (171, 'NL', 'Netherlands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (172, 'NO', 'Norway
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (173, 'NP', 'Nepal
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (174, 'NR', 'Nauru
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (175, 'NU', 'Niue
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (176, 'NZ', 'New Zealand
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (177, 'OM', 'Oman
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (178, 'PA', 'Panama
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (179, 'PE', 'Peru
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (180, 'PF', 'French Polynesia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (181, 'PG', 'Papua New Guinea
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (182, 'PH', 'Philippines
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (183, 'PK', 'Pakistan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (184, 'PL', 'Poland
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (185, 'PM', 'Saint Pierre and Miquelon
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (186, 'PN', 'Pitcairn
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (187, 'PR', 'Puerto Rico
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (188, 'PS', 'Palestinian Territory
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (189, 'PT', 'Portugal
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (190, 'PW', 'Palau
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (191, 'PY', 'Paraguay
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (192, 'QA', 'Qatar
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (193, 'RE', 'Reunion
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (194, 'RO', 'Romania
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (195, 'RS', 'Serbia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (196, 'RU', 'Russian Federation
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (197, 'RW', 'Rwanda
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (198, 'SA', 'Saudi Arabia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (199, 'SB', 'Solomon Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (200, 'SC', 'Seychelles
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (201, 'SD', 'Sudan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (202, 'SE', 'Sweden
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (203, 'SG', 'Singapore
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (204, 'SH', 'Saint Helena
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (205, 'SI', 'Slovenia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (206, 'SJ', 'Svalbard and Jan Mayen
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (207, 'SK', 'Slovakia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (208, 'SL', 'Sierra Leone
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (209, 'SM', 'San Marino
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (210, 'SN', 'Senegal
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (211, 'SO', 'Somalia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (212, 'SR', 'Suriname
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (213, 'ST', 'Sao Tome and Principe
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (214, 'SV', 'El Salvador
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (215, 'SY', 'Syrian Arab Republic
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (216, 'SZ', 'Swaziland
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (217, 'TC', 'Turks and Caicos Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (218, 'TD', 'Chad
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (219, 'TF', 'French Southern Territories
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (220, 'TG', 'Togo
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (221, 'TH', 'Thailand
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (222, 'TJ', 'Tajikistan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (223, 'TK', 'Tokelau
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (224, 'TL', 'Timor-Leste
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (225, 'TM', 'Turkmenistan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (226, 'TN', 'Tunisia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (227, 'TO', 'Tonga
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (228, 'TR', 'Turkey
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (229, 'TT', 'Trinidad and Tobago
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (230, 'TV', 'Tuvalu
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (231, 'TW', 'Taiwan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (232, 'TZ', 'Tanzania
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (233, 'UA', 'Ukraine
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (234, 'UG', 'Uganda
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (235, 'UM', 'United States Minor Outlying Islands
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (236, 'US', 'United States
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (237, 'UY', 'Uruguay
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (238, 'UZ', 'Uzbekistan
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (239, 'VA', 'Holy See (Vatican City State)
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (240, 'VC', 'Saint Vincent and the Grenadines
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (241, 'VE', 'Venezuela
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (242, 'VG', 'Virgin Islands British
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (243, 'VI', 'Virgin Islands U.S.
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (244, 'VN', 'Vietnam
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (245, 'VU', 'Vanuatu
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (246, 'WF', 'Wallis and Futuna
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (247, 'WS', 'Samoa
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (248, 'YE', 'Yemen
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (249, 'YT', 'Mayotte
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (250, 'ZA', 'South Africa
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (251, 'ZM', 'Zambia
');
INSERT INTO smf_geoip_countries (ci, cc, cn) VALUES (252, 'ZW', 'Zimbabwe');
/* 252 row(s) exported */

Title: Re: Importing GeoIP into MySQL
Post by: kirkvan on June 26, 2017, 10:42:01 am
Thanks for all your help.