Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43260
Total Topics: 7518
Most Online Today: 297
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 278
Total: 279

Author Topic: Importing GeoIP into MySQL  (Read 6181 times)

0 Members and 1 Guest are viewing this topic.

Offline kirkvan

  • Member
  • *
  • Posts: 4
    • View Profile
Importing GeoIP into MySQL
« 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.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Importing GeoIP into MySQL
« Reply #1 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.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline kirkvan

  • Member
  • *
  • Posts: 4
    • View Profile
Re: Importing GeoIP into MySQL
« Reply #2 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.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Importing GeoIP into MySQL
« Reply #3 on: June 25, 2017, 03:18:16 pm »
Here is a full database dump that you can use
http://www.smfhacks.com/geoipdb.zip
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline kirkvan

  • Member
  • *
  • Posts: 4
    • View Profile
Re: Importing GeoIP into MySQL
« Reply #4 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 */;

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16436
    • View Profile
Re: Importing GeoIP into MySQL
« Reply #5 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 */

Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline kirkvan

  • Member
  • *
  • Posts: 4
    • View Profile
Re: Importing GeoIP into MySQL
« Reply #6 on: June 26, 2017, 10:42:01 am »
Thanks for all your help.

 

Related Topics

  Subject / Started by Replies Last post
1 Replies
3738 Views
Last post December 09, 2007, 10:14:16 pm
by SMFHacks
1 Replies
4043 Views
Last post January 31, 2008, 05:28:27 pm
by SMFHacks
3 Replies
4728 Views
Last post May 05, 2009, 07:24:06 pm
by SMFHacks
0 Replies
3485 Views
Last post March 03, 2016, 06:27:48 pm
by SMFHacks
12 Replies
5318 Views
Last post February 10, 2017, 08:56:57 am
by GeorG

+- Recent Topics

No thumbnails on new uploads by Tonyvic
Today at 06:26:18 am

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Gallery icon as last added image by fvlog19
February 01, 2024, 01:04:56 pm

Powered by EzPortal