SQL import MaxMind GeoIP CSV into MySQL

import_maxmind_csv.sql

USE users_info;

CREATE TABLE IF NOT EXISTS `geoips` (
  `id`      INT(1) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `ipstart`   VARCHAR(50) COLLATE UTF8_GENERAL_CI NOT NULL, 
  `ipend`   VARCHAR(50) COLLATE UTF8_GENERAL_CI NOT NULL,
  `locid_start`   INT(1) UNSIGNED ZEROFILL NOT NULL,
  `locid_end`   INT(1) UNSIGNED ZEROFILL NOT NULL, 
  `country_code`  VARCHAR(4) COLLATE UTF8_GENERAL_CI NOT NULL, 
  `country`   VARCHAR(100) COLLATE UTF8_GENERAL_CI NOT NULL,

  PRIMARY KEY( `id`,`ipstart`,`ipend`, `locid_end`, `country` )

) DEFAULT CHARSET=UTF8 COLLATE=UTF8_GENERAL_CI AUTO_INCREMENT=1 ;


LOAD DATA INFILE '/Users/tylerpearson/Dropbox/scripts/user-import/GeoIPCountryWhois.csv' INTO TABLE `geoips` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n'(
 `ipstart` , `ipend` , `locid_start` , `locid_end` , `country_code` , `country`
 );