...
* 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 a long time, more than 1 hour if the server machine does not have powerful resources, to import the data.hours to import the data depending on the performance of the machine, as there are nearly 5 millions of records to be imported.
You can monitor the progress by checking MySQL's CPU usage in the Task Manager
4 - After the ip2location data has been imported successfully, execute the script below to process the data
Code Block | ||
---|---|---|
| ||
Update ip2location_db3_ipv6 set ip_from = LPAD(ip_from, 39,'0'),ip_to = LPAD(ip_to, 39,'0'); |
Again, this process will take some time depending on the machine power.