Page History

...

1 - Log into MySQL console

You have to use mysql command with --local-info=1 to login, e.g.

mysql --local-infile=1 -uroot -p dualshield

Image AddedImage Removed

2 - Change to "DualShield" database:

use DualShield;

Image RemovedImage Added

3 - Enable Set local_infile variable

set global local_infile=true;

Image Added

4 - Execute the script below to import the database

...

* replace "FILE-PATH-TO" with the actual file path where the downloaded file is saved, e.g. "c:\downloadstemp"

Image RemovedImage Added

* 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.

You can monitor the progress by checking MySQL's CPU usage in the Task Manager

Image RemovedImage Added

5 - After the ip2location data has been imported successfully, execute the script below to process the data

Update ip2location_ipv6 set ip_from = LPAD(ip_from, 39,'0'),ip_to = LPAD(ip_to, 39,'0');

Image RemovedImage Added

Again, this process will take some time depending on the machine power.

Image RemovedImage Added

Note:

* For dualshield version < 8.0, the name of the table in the database is called "ip2location_db3_ipv6"

...