PHP

country

CREATE TABLE `ip2location_geonameid`(
	`country_code` CHAR(2),
	`region_name` VARCHAR(128),
	`city_name` VARCHAR(128),
	`geonameid` INT(10),
	INDEX `idx_country_code` (`country_code`),
	INDEX `idx_region_name` (`region_name`),
	INDEX `idx_city_name` (`city_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

LOAD DATA LOCAL
INFILE 'IP2LOCATION-GEONAMEID.CSV' INTO TABLE `ip2location_geonameid`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '
' IGNORE 1 LINES;