Skip to content

Examples

Jump to bottom
mbto edited this page Jun 30, 2023 · 11 revisions
  • Generate a free license key in https://support.maxmind.com/hc/en-us/articles/4407111582235-Generate-a-License-Key
  • Copy/Paste .ini template bin/GeoLite2-City-CSV.mysql.default.ini with your profile name, example bin/GeoLite2-City-CSV.mysql.Your Project Name.ini or use default.
  • Open .ini template with Notepad and change [windows_loader] or [unix_loader] section (set MySQL host:port, user and password).
  • Executable script for Unix $ chmod +x maxmind-geoip2-csv2sql-converter, Windows maxmind-geoip2-csv2sql-converter.bat

Set JAVA_HOME environment, if empty, example:

set JAVA_HOME=C:\Program Files\Java\jdk-11.0.11\

Convert GeoLite2-Country IP4, IP6 to Microsoft SQL Server 2019

maxmind-geoip2-csv2sql-converter.bat -c "GeoLite2-Country-CSV.mssql 2019.default.ini" -k M8jFjv3vZWrOCaZN -i 4,6

Convert GeoLite2-City IP4, IP6 to Microsoft SQL Server 2019

maxmind-geoip2-csv2sql-converter.bat -c "GeoLite2-City-CSV.mssql 2019.default.ini" -k M8jFjv3vZWrOCaZN -i 4,6

Convert GeoLite2-Country IP4, IP6 to PostgreSQL

maxmind-geoip2-csv2sql-converter.bat -c GeoLite2-Country-CSV.postgresql.default.ini -k M8jFjv3vZWrOCaZN -i 4,6

Convert GeoLite2-City IP4, IP6 to PostgreSQL

maxmind-geoip2-csv2sql-converter.bat -c GeoLite2-City-CSV.postgresql.default.ini -k M8jFjv3vZWrOCaZN -i 4,6

Convert GeoLite2-City IP4, IP6 to MySQL

C:\GeoLite2\mm\bin>maxmind-geoip2-csv2sql-converter.bat -c GeoLite2-City-CSV.mysql.default.ini -k M8jFjv3vZWrOCaZN -i 4,6
MaxMind GeoIP2 csv2sql Converter v1.0
https://github.com/mbto/maxmind-geoip2-csv2sql-converter
Supported locales: en,ru,de,es,fr,ja,pt-BR,zh-CN, IP versions: v4,v6
Country emoji: 251 (Default: 250 country + 1 for unresolved)
Available processors: 4

Resolved config path 'C:\GeoLite2\mm\bin\GeoLite2-City-CSV.mysql.default.ini'
Resolving output directory path
Resolved output directory path 'C:\GeoLite2\mm\bin\converted'
Grabbing archive
Requesting https://download.maxmind.com/app/geoip_download?edition_id=GeoLite2-City-CSV&license_key=M8jFjv3vZWrOCaZN&suffix=zip
Extracted from headers: archive name 'GeoLite2-City-CSV_20210824.zip' @ 51 291 260 bytes (48,92 mb)
Downloading archive to 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-CSV_20210824.zip'
Resolved archive path 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-CSV_20210824.zip' in 0m 7s @ 51 291 260 bytes (48,92 mb)
Resolved scripts path 'C:\GeoLite2\mm\bin\converted'
Summary:
  Edition ID: GeoLite2-City-CSV
  DBMS name: mysql
  Profile name: default
Arguments of converting:
  IP versions: v4,v6
  Locales: en,ru,de,es,fr,ja,pt-BR,zh-CN
  Locations filter: no filter
  Max megabytes count per file: 64
  Max records per line: 100
  Values count per insert: no limit
Sources from 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-CSV_20210824.zip'
  'GeoLite2-City-Locations-en.csv'
  'GeoLite2-City-Locations-ru.csv'
  'GeoLite2-City-Locations-de.csv'
  'GeoLite2-City-Locations-es.csv'
  'GeoLite2-City-Locations-fr.csv'
  'GeoLite2-City-Locations-ja.csv'
  'GeoLite2-City-Locations-pt-BR.csv'
  'GeoLite2-City-Locations-zh-CN.csv'
  'GeoLite2-City-Blocks-IPv4.csv'
  'GeoLite2-City-Blocks-IPv6.csv'
Extracting archive
Extracting 'GeoLite2-City-Locations-de.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-de.csv'
Extracting 'GeoLite2-City-Locations-en.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-en.csv'
Extracting 'GeoLite2-City-Blocks-IPv6.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Blocks-IPv6.csv'
Extracting 'GeoLite2-City-Locations-ru.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-ru.csv'
Extracting 'GeoLite2-City-Locations-ja.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-ja.csv'
Extracting 'GeoLite2-City-Locations-es.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-es.csv'
Extracting 'GeoLite2-City-Blocks-IPv4.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Blocks-IPv4.csv'
Extracting 'GeoLite2-City-Locations-pt-BR.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-pt-BR.csv'
Extracting 'GeoLite2-City-Locations-zh-CN.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-zh-CN.csv'
Extracting 'GeoLite2-City-Locations-fr.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-fr.csv'
Extracted 10 entries in 0m 1s
[     main] Started 'location converter'
[     main] Started converting 'GeoLite2-City-Locations-en.csv'
[     main] Started converting 'GeoLite2-City-Locations-ru.csv'
[     main] Started converting 'GeoLite2-City-Locations-de.csv'
[     main] Started converting 'GeoLite2-City-Locations-es.csv'
[     main] Started converting 'GeoLite2-City-Locations-fr.csv'
[     main] Started converting 'GeoLite2-City-Locations-ja.csv'
[     main] Started converting 'GeoLite2-City-Locations-pt-BR.csv'
[     main] Started converting 'GeoLite2-City-Locations-zh-CN.csv'
[ Thread-0] Started 'location writer'
[ Thread-0] Started building 'country_000.sql'
[ Thread-0] Started building 'subdivision1_000.sql'
[ Thread-0] Started building 'timezone_000.sql'
[ Thread-0] Started building 'city_000.sql'
[ Thread-0] Started building 'subdivision2_000.sql'
[     main] Finished converting 'GeoLite2-City-Locations-en.csv'
[     main] Finished converting 'GeoLite2-City-Locations-ru.csv'
[     main] Finished converting 'GeoLite2-City-Locations-de.csv'
[     main] Finished converting 'GeoLite2-City-Locations-es.csv'
[     main] Finished converting 'GeoLite2-City-Locations-fr.csv'
[     main] Finished converting 'GeoLite2-City-Locations-ja.csv'
[     main] Finished converting 'GeoLite2-City-Locations-pt-BR.csv'
[     main] Finished converting 'GeoLite2-City-Locations-zh-CN.csv'
[     main] Waiting for terminate writer from 'location converter'
[ Thread-0] Finished building 'country_000.sql' @ 63 746 bytes (0,06 mb)
[ Thread-0] Finished building 'city_000.sql' @ 12 408 651 bytes (11,83 mb)
[ Thread-0] Finished building 'timezone_000.sql' @ 9 933 bytes (0,01 mb)
[ Thread-0] Finished building 'subdivision2_000.sql' @ 86 880 bytes (0,08 mb)
[ Thread-0] Finished building 'subdivision1_000.sql' @ 283 717 bytes (0,27 mb)
[ Thread-0] Finished 'location writer' in 0m 12s
[     main] Terminated writer from 'location converter'
[     main] Finished 'location converter' in 0m 12s
[-worker-1] Started 'ipv6 converter'
[-worker-3] Started 'ipv4 converter'
[-worker-1] Started converting 'GeoLite2-City-Blocks-IPv6.csv'
[-worker-3] Started converting 'GeoLite2-City-Blocks-IPv4.csv'
[ Thread-1] Started 'ipv4 writer'
[ Thread-2] Started 'ipv6 writer'
[ Thread-1] Started building 'ipv4_000.sql'
[ Thread-2] Started building 'ipv6_000.sql'
[ Thread-2] Finished building 'ipv6_000.sql' @ 67 006 751 bytes (63,90 mb)
[ Thread-2] Started building 'ipv6_001.sql'
[ Thread-1] Finished building 'ipv4_000.sql' @ 67 006 522 bytes (63,90 mb)
[ Thread-1] Started building 'ipv4_001.sql'
[ Thread-2] Finished building 'ipv6_001.sql' @ 67 006 556 bytes (63,90 mb)
[ Thread-2] Started building 'ipv6_002.sql'
[ Thread-1] Finished building 'ipv4_001.sql' @ 67 006 524 bytes (63,90 mb)
[ Thread-1] Started building 'ipv4_002.sql'
[ Thread-2] Finished building 'ipv6_002.sql' @ 67 006 676 bytes (63,90 mb)
[ Thread-2] Started building 'ipv6_003.sql'
[ Thread-1] Finished building 'ipv4_002.sql' @ 67 006 584 bytes (63,90 mb)
[ Thread-1] Started building 'ipv4_003.sql'
[ Thread-2] Finished building 'ipv6_003.sql' @ 67 006 474 bytes (63,90 mb)
[ Thread-2] Started building 'ipv6_004.sql'
[ Thread-1] Finished building 'ipv4_003.sql' @ 67 006 548 bytes (63,90 mb)
[ Thread-1] Started building 'ipv4_004.sql'
[ Thread-2] Finished building 'ipv6_004.sql' @ 67 006 713 bytes (63,90 mb)
[ Thread-2] Started building 'ipv6_005.sql'
[-worker-1] Finished converting 'GeoLite2-City-Blocks-IPv6.csv'
[-worker-1] Waiting for terminate writer from 'ipv6 converter'
[ Thread-2] Finished building 'ipv6_005.sql' @ 27 116 914 bytes (25,86 mb)
[ Thread-2] Finished 'ipv6 writer' in 0m 18s
[-worker-1] Terminated writer from 'ipv6 converter'
[-worker-1] Finished 'ipv6 converter' in 0m 18s
[ Thread-1] Finished building 'ipv4_004.sql' @ 67 006 581 bytes (63,90 mb)
[ Thread-1] Started building 'ipv4_005.sql'
[ Thread-1] Finished building 'ipv4_005.sql' @ 67 006 522 bytes (63,90 mb)
[ Thread-1] Started building 'ipv4_006.sql'
[ Thread-1] Finished building 'ipv4_006.sql' @ 67 006 499 bytes (63,90 mb)
[ Thread-1] Started building 'ipv4_007.sql'
[ Thread-1] Finished building 'ipv4_007.sql' @ 67 006 570 bytes (63,90 mb)
[ Thread-1] Started building 'ipv4_008.sql'
[-worker-3] Finished converting 'GeoLite2-City-Blocks-IPv4.csv'
[-worker-3] Waiting for terminate writer from 'ipv4 converter'
[ Thread-1] Finished building 'ipv4_008.sql' @ 20 289 651 bytes (19,35 mb)
[ Thread-1] Finished 'ipv4 writer' in 0m 32s
[-worker-3] Terminated writer from 'ipv4 converter'
[-worker-3] Finished 'ipv4 converter' in 0m 32s
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-de.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-en.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Blocks-IPv6.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-ru.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-ja.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-es.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Blocks-IPv4.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-pt-BR.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-zh-CN.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-City-Locations-fr.csv'
Generating scripts
'timezone_create' -> 'timezone_create.sql'
'country_create' -> 'country_create.sql'
'subdivision1_create' -> 'subdivision1_create.sql'
'subdivision2_create' -> 'subdivision2_create.sql'
'city_create' -> 'city_create.sql'
'ipv4_create' -> 'ipv4_create.sql'
'ipv6_create' -> 'ipv6_create.sql'
'timezone_indexes' -> 'timezone_indexes.sql'
'country_indexes' -> 'country_indexes.sql'
'subdivision1_indexes' -> 'subdivision1_indexes.sql'
'subdivision2_indexes' -> 'subdivision2_indexes.sql'
'city_indexes' -> 'city_indexes.sql'
'ipv4_indexes' -> 'ipv4_indexes.sql'
'ipv6_indexes' -> 'ipv6_indexes.sql'
'load_data' -> 'load_data.sql'
'windows_loader' -> 'loader.bat'
'unix_loader' -> 'loader.sh'
Finished generating scripts in 0m 0s
Started building 'maxmind-geoip2-csv2sql.zip' with 37 entries
Archiving 'timezone_create.sql' @ 262 bytes (0,00 mb)
Archiving 'country_create.sql' @ 1 846 bytes (0,00 mb)
Archiving 'subdivision1_create.sql' @ 955 bytes (0,00 mb)
Archiving 'subdivision2_create.sql' @ 954 bytes (0,00 mb)
Archiving 'city_create.sql' @ 1 159 bytes (0,00 mb)
Archiving 'ipv4_create.sql' @ 1 108 bytes (0,00 mb)
Archiving 'ipv6_create.sql' @ 1 130 bytes (0,00 mb)
Archiving 'city_000.sql' @ 12 408 651 bytes (11,83 mb)
Archiving 'country_000.sql' @ 63 746 bytes (0,06 mb)
Archiving 'ipv4_000.sql' @ 67 006 522 bytes (63,90 mb)
Archiving 'ipv4_001.sql' @ 67 006 524 bytes (63,90 mb)
Archiving 'ipv4_002.sql' @ 67 006 584 bytes (63,90 mb)
Archiving 'ipv4_003.sql' @ 67 006 548 bytes (63,90 mb)
Archiving 'ipv4_004.sql' @ 67 006 581 bytes (63,90 mb)
Archiving 'ipv4_005.sql' @ 67 006 522 bytes (63,90 mb)
Archiving 'ipv4_006.sql' @ 67 006 499 bytes (63,90 mb)
Archiving 'ipv4_007.sql' @ 67 006 570 bytes (63,90 mb)
Archiving 'ipv4_008.sql' @ 20 289 651 bytes (19,35 mb)
Archiving 'ipv6_000.sql' @ 67 006 751 bytes (63,90 mb)
Archiving 'ipv6_001.sql' @ 67 006 556 bytes (63,90 mb)
Archiving 'ipv6_002.sql' @ 67 006 676 bytes (63,90 mb)
Archiving 'ipv6_003.sql' @ 67 006 474 bytes (63,90 mb)
Archiving 'ipv6_004.sql' @ 67 006 713 bytes (63,90 mb)
Archiving 'ipv6_005.sql' @ 27 116 914 bytes (25,86 mb)
Archiving 'subdivision1_000.sql' @ 283 717 bytes (0,27 mb)
Archiving 'subdivision2_000.sql' @ 86 880 bytes (0,08 mb)
Archiving 'timezone_000.sql' @ 9 933 bytes (0,01 mb)
Archiving 'timezone_indexes.sql' @ 72 bytes (0,00 mb)
Archiving 'country_indexes.sql' @ 78 bytes (0,00 mb)
Archiving 'subdivision1_indexes.sql' @ 78 bytes (0,00 mb)
Archiving 'subdivision2_indexes.sql' @ 78 bytes (0,00 mb)
Archiving 'city_indexes.sql' @ 797 bytes (0,00 mb)
Archiving 'ipv4_indexes.sql' @ 1 300 bytes (0,00 mb)
Archiving 'ipv6_indexes.sql' @ 1 300 bytes (0,00 mb)
Archiving 'load_data.sql' @ 932 bytes (0,00 mb)
Archiving 'loader.bat' @ 247 bytes (0,00 mb)
Archiving 'loader.sh' @ 181 bytes (0,00 mb)
Finished building 'maxmind-geoip2-csv2sql.zip' in 0m 22s @ 159 435 203 bytes (152,05 mb)
Stats:
  city: 138254
  city includes which unknown: 250
  country: 252
  country includes which unknown: 2
  ipv4: 3572745
  ipv6: 1211269
  subdivision1: 3472
  subdivision2: 1120
  timezone: 409
Complete in 1m 17s

Convert GeoLite2-Country IP4, IP6 to MySQL

C:\GeoLite2\mm\bin>maxmind-geoip2-csv2sql-converter.bat -c GeoLite2-Country-CSV.mysql.default.ini -k M8jFjv3vZWrOCaZN -i 4,6
MaxMind GeoIP2 csv2sql Converter v1.0
https://github.com/mbto/maxmind-geoip2-csv2sql-converter
Supported locales: en,ru,de,es,fr,ja,pt-BR,zh-CN, IP versions: v4,v6
Country emoji: 251 (Default: 250 country + 1 for unresolved)
Available processors: 4

Resolved config path 'C:\GeoLite2\mm\bin\GeoLite2-Country-CSV.mysql.default.ini'
Resolving output directory path
Resolved output directory path 'C:\GeoLite2\mm\bin\converted'
Grabbing archive
Requesting https://download.maxmind.com/app/geoip_download?edition_id=GeoLite2-Country-CSV&license_key=M8jFjv3vZWrOCaZN&suffix=zip
Extracted from headers: archive name 'GeoLite2-Country-CSV_20210824.zip' @ 3 479 806 bytes (3,32 mb)
Downloading archive to 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-CSV_20210824.zip'
Resolved archive path 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-CSV_20210824.zip' in 0m 2s @ 3 479 806 bytes (3,32 mb)
Resolved scripts path 'C:\GeoLite2\mm\bin\converted'
Summary:
  Edition ID: GeoLite2-Country-CSV
  DBMS name: mysql
  Profile name: default
Arguments of converting:
  IP versions: v4,v6
  Locales: en,ru,de,es,fr,ja,pt-BR,zh-CN
  Locations filter: no filter
  Max megabytes count per file: 64
  Max records per line: 100
  Values count per insert: no limit
Sources from 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-CSV_20210824.zip'
  'GeoLite2-Country-Locations-en.csv'
  'GeoLite2-Country-Locations-ru.csv'
  'GeoLite2-Country-Locations-de.csv'
  'GeoLite2-Country-Locations-es.csv'
  'GeoLite2-Country-Locations-fr.csv'
  'GeoLite2-Country-Locations-ja.csv'
  'GeoLite2-Country-Locations-pt-BR.csv'
  'GeoLite2-Country-Locations-zh-CN.csv'
  'GeoLite2-Country-Blocks-IPv4.csv'
  'GeoLite2-Country-Blocks-IPv6.csv'
Extracting archive
Extracting 'GeoLite2-Country-Blocks-IPv4.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Blocks-IPv4.csv'
Extracting 'GeoLite2-Country-Locations-es.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-es.csv'
Extracting 'GeoLite2-Country-Locations-en.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-en.csv'
Extracting 'GeoLite2-Country-Locations-de.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-de.csv'
Extracting 'GeoLite2-Country-Locations-pt-BR.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-pt-BR.csv'
Extracting 'GeoLite2-Country-Locations-fr.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-fr.csv'
Extracting 'GeoLite2-Country-Locations-ru.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-ru.csv'
Extracting 'GeoLite2-Country-Locations-zh-CN.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-zh-CN.csv'
Extracting 'GeoLite2-Country-Locations-ja.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-ja.csv'
Extracting 'GeoLite2-Country-Blocks-IPv6.csv' -> 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Blocks-IPv6.csv'
Extracted 10 entries in 0m 0s
[     main] Started 'location converter'
[     main] Started converting 'GeoLite2-Country-Locations-en.csv'
[     main] Started converting 'GeoLite2-Country-Locations-ru.csv'
[     main] Started converting 'GeoLite2-Country-Locations-de.csv'
[     main] Started converting 'GeoLite2-Country-Locations-es.csv'
[     main] Started converting 'GeoLite2-Country-Locations-fr.csv'
[     main] Started converting 'GeoLite2-Country-Locations-ja.csv'
[     main] Started converting 'GeoLite2-Country-Locations-pt-BR.csv'
[     main] Started converting 'GeoLite2-Country-Locations-zh-CN.csv'
[ Thread-0] Started 'location writer'
[ Thread-0] Started building 'country_000.sql'
[     main] Finished converting 'GeoLite2-Country-Locations-en.csv'
[     main] Finished converting 'GeoLite2-Country-Locations-ru.csv'
[     main] Finished converting 'GeoLite2-Country-Locations-de.csv'
[     main] Finished converting 'GeoLite2-Country-Locations-es.csv'
[     main] Finished converting 'GeoLite2-Country-Locations-fr.csv'
[     main] Finished converting 'GeoLite2-Country-Locations-ja.csv'
[     main] Finished converting 'GeoLite2-Country-Locations-pt-BR.csv'
[     main] Finished converting 'GeoLite2-Country-Locations-zh-CN.csv'
[     main] Waiting for terminate writer from 'location converter'
[ Thread-0] Finished building 'country_000.sql' @ 65 333 bytes (0,06 mb)
[ Thread-0] Finished 'location writer' in 0m 0s
[     main] Terminated writer from 'location converter'
[     main] Finished 'location converter' in 0m 0s
[-worker-1] Started 'ipv4 converter'
[-worker-3] Started 'ipv6 converter'
[-worker-3] Started converting 'GeoLite2-Country-Blocks-IPv6.csv'
[-worker-1] Started converting 'GeoLite2-Country-Blocks-IPv4.csv'
[ Thread-1] Started 'ipv4 writer'
[ Thread-2] Started 'ipv6 writer'
[ Thread-1] Started building 'ipv4_000.sql'
[ Thread-2] Started building 'ipv6_000.sql'
[-worker-1] Finished converting 'GeoLite2-Country-Blocks-IPv4.csv'
[-worker-1] Waiting for terminate writer from 'ipv4 converter'
[ Thread-1] Finished building 'ipv4_000.sql' @ 44 561 550 bytes (42,50 mb)
[ Thread-1] Finished 'ipv4 writer' in 0m 2s
[-worker-1] Terminated writer from 'ipv4 converter'
[-worker-1] Finished 'ipv4 converter' in 0m 2s
[ Thread-2] Finished building 'ipv6_000.sql' @ 67 006 524 bytes (63,90 mb)
[ Thread-2] Started building 'ipv6_001.sql'
[ Thread-2] Finished building 'ipv6_001.sql' @ 67 006 702 bytes (63,90 mb)
[ Thread-2] Started building 'ipv6_002.sql'
[-worker-3] Finished converting 'GeoLite2-Country-Blocks-IPv6.csv'
[-worker-3] Waiting for terminate writer from 'ipv6 converter'
[ Thread-2] Finished building 'ipv6_002.sql' @ 23 473 662 bytes (22,39 mb)
[ Thread-2] Finished 'ipv6 writer' in 0m 7s
[-worker-3] Terminated writer from 'ipv6 converter'
[-worker-3] Finished 'ipv6 converter' in 0m 7s
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Blocks-IPv4.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-es.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-en.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-de.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-pt-BR.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-fr.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-ru.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-zh-CN.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Locations-ja.csv'
Deleted 'C:\GeoLite2\mm\bin\converted\GeoLite2-Country-Blocks-IPv6.csv'
Generating scripts
'country_create' -> 'country_create.sql'
'ipv4_create' -> 'ipv4_create.sql'
'ipv6_create' -> 'ipv6_create.sql'
'country_indexes' -> 'country_indexes.sql'
'ipv4_indexes' -> 'ipv4_indexes.sql'
'ipv6_indexes' -> 'ipv6_indexes.sql'
'load_data' -> 'load_data.sql'
'windows_loader' -> 'loader.bat'
'unix_loader' -> 'loader.sh'
Finished generating scripts in 0m 0s
Started building 'maxmind-geoip2-csv2sql.zip' with 14 entries
Archiving 'country_create.sql' @ 1 910 bytes (0,00 mb)
Archiving 'ipv4_create.sql' @ 893 bytes (0,00 mb)
Archiving 'ipv6_create.sql' @ 915 bytes (0,00 mb)
Archiving 'country_000.sql' @ 65 333 bytes (0,06 mb)
Archiving 'ipv4_000.sql' @ 44 561 550 bytes (42,50 mb)
Archiving 'ipv6_000.sql' @ 67 006 524 bytes (63,90 mb)
Archiving 'ipv6_001.sql' @ 67 006 702 bytes (63,90 mb)
Archiving 'ipv6_002.sql' @ 23 473 662 bytes (22,39 mb)
Archiving 'country_indexes.sql' @ 78 bytes (0,00 mb)
Archiving 'ipv4_indexes.sql' @ 1 312 bytes (0,00 mb)
Archiving 'ipv6_indexes.sql' @ 1 312 bytes (0,00 mb)
Archiving 'load_data.sql' @ 485 bytes (0,00 mb)
Archiving 'loader.bat' @ 247 bytes (0,00 mb)
Archiving 'loader.sh' @ 181 bytes (0,00 mb)
Finished building 'maxmind-geoip2-csv2sql.zip' in 0m 3s @ 30 329 110 bytes (28,92 mb)
Stats:
  country: 252
  country includes which unknown: 2
  ipv4: 348474
  ipv6: 579592
Complete in 0m 13s
  • After converting, the scripts bin/converted/loader.bat and bin/converted/loader.sh will be available.
  • For unix: Execute chmod +x loader.sh
  • Execute loader.bat or loader.sh for importing schemas.
C:\GeoLite2\mm\bin\converted>loader.bat
Active code page: 65001
mysql: [Warning] Using a password on the command line interface can be insecure.
Done

Screenshot_2 Screenshot_1 Screenshot_1 Screenshot_2 Screenshot_1 (2) Screenshot_3 Screenshot_1

Clone this wiki locally