IP2LOCATION MySQL csv import

LOAD DATA INFILE 'c:/temp/IP2LOCATION-LITE-DB1.CSV'
REPLACE INTO TABLE ip2location_db1 CHARACTER SET latin1 FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 0 LINES;

LOAD DATA INFILE 'c:/temp/IP2LOCATION-LITE-DB5.CSV'
REPLACE INTO TABLE ip2location_db5 CHARACTER SET latin1 FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 0 LINES;

LOAD DATA INFILE 'c:/temp/IP2LOCATION-LITE-ASN.CSV'
REPLACE INTO TABLE ip2location_asn CHARACTER SET latin1 FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 0 LINES
(ip_from,ip_to,cidr,@asn,`as`)
SET asn=if(@asn='-',0,@asn);


LOAD DATA INFILE 'c:/temp/IP2PROXY-LITE-PX1.csv'
REPLACE INTO TABLE ip2proxy_px1 CHARACTER SET latin1 FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 0 LINES;

LOAD DATA INFILE 'c:/temp/IP2PROXY-LITE-PX8.csv'
REPLACE INTO TABLE ip2proxy_px8 CHARACTER SET latin1 FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 0 LINES;

/*
CREATE TABLE IF NOT EXISTS `ip2location_asn` (
    `ip_from` INT(10) UNSIGNED NOT NULL,
    `ip_to` INT(10) UNSIGNED NOT NULL,
    `cidr` VARCHAR(18) NOT NULL,
    `asn` INT(10) UNSIGNED NULL DEFAULT NULL,
    `as` VARCHAR(256) NOT NULL, PRIMARY KEY (`ip_from`, `ip_to`), INDEX `idx_ip_from` (`ip_from`), INDEX `idx_ip_to` (`ip_to`)
);
CREATE TABLE IF NOT EXISTS `ip2location_db1` (
    `ip_from` INT(10) UNSIGNED NULL DEFAULT NULL,
    `ip_to` INT(10) UNSIGNED NULL DEFAULT NULL,
    `country_code` CHAR(2) NULL DEFAULT NULL,
    `country_name` VARCHAR(64) NULL DEFAULT NULL, INDEX `idx_ip_from` (`ip_from`), INDEX `idx_ip_to` (`ip_to`), INDEX `idx_ip_from_to` (`ip_from`, `ip_to`), INDEX `country_code` (`country_code`)
);
CREATE TABLE IF NOT EXISTS `ip2location_db5` (
    `ip_from` INT(10) UNSIGNED NULL DEFAULT NULL,
    `ip_to` INT(10) UNSIGNED NULL DEFAULT NULL,
    `country_code` CHAR(2) NULL DEFAULT NULL,
    `country_name` VARCHAR(64) NULL DEFAULT NULL,
    `region_name` VARCHAR(128) NULL DEFAULT NULL,
    `city_name` VARCHAR(128) NULL DEFAULT NULL,
    `latitude` DOUBLE NULL DEFAULT NULL,
    `longitude` DOUBLE NULL DEFAULT NULL, INDEX `idx_ip_from` (`ip_from`), INDEX `idx_ip_to` (`ip_to`), INDEX `idx_ip_from_to` (`ip_from`, `ip_to`), INDEX `country_code` (`country_code`)
);
CREATE TABLE IF NOT EXISTS `ip2proxy_px1` (
    `ip_from` INT(10) UNSIGNED NOT NULL,
    `ip_to` INT(10) UNSIGNED NOT NULL,
    `country_code` CHAR(2) NULL DEFAULT NULL,
    `country_name` VARCHAR(64) NULL DEFAULT NULL, PRIMARY KEY (`ip_from`, `ip_to`)
);
CREATE TABLE IF NOT EXISTS `ip2proxy_px8` (
    `ip_from` INT(10) UNSIGNED NOT NULL,
    `ip_to` INT(10) UNSIGNED NOT NULL,
    `proxy_type` VARCHAR(3) NULL DEFAULT NULL,
    `country_code` CHAR(2) NULL DEFAULT NULL,
    `country_name` VARCHAR(64) NULL DEFAULT NULL,
    `region_name` VARCHAR(128) NULL DEFAULT NULL,
    `city_name` VARCHAR(128) NULL DEFAULT NULL,
    `isp` VARCHAR(256) NULL DEFAULT NULL,
    `domain` VARCHAR(128) NULL DEFAULT NULL,
    `usage_type` VARCHAR(11) NULL DEFAULT NULL,
    `asn` INT(10) NULL DEFAULT NULL,
    `as` VARCHAR(256) NULL DEFAULT NULL,
    `last_seen` INT(10) UNSIGNED NULL DEFAULT NULL, PRIMARY KEY (`ip_from`, `ip_to`), INDEX `country_code` (`country_code`)
);

*/

/*
https://lite.ip2location.com/file-download
curl -LRko #1.zip "https://www.ip2location.com/download/?token=HK5RUXQvI3V2n9Qc2iwCZUCf28LXqZ87KeYEcPaUT5WhfNth60U5UwkWF6U553dP&file={DB1LITE,DB5LITE,DBASNLITE,PX1LITE,PX8LITE}"

7z e -aoa DB*LITE.zip PX*LITE.zip DBASNLITE.zip *.csv

*/