...
* replace "FILE-PATH-TO" with the actual file path where the downloaded file is saved, e.g. "c:\downloads"
* Please note that it can take hours to import the data depending on the performance of the machine, as there are nearly 5 millions of records to be imported.
Process Data
After the data has been successfully imported, execute the script below
Code Block | ||
---|---|---|
| ||
update ip2location_db3_ipv6 set ip_from = (SUBSTRING(REPLICATE('0', 39), 1, 39 - LEN(ip_from)) + ip_from), ip_to = (SUBSTRING(REPLICATE('0', 39), 1, 39 - LEN(ip_to)) + ip_to); |
Again, this process wil take some time depending on the machine power.