Page History

...

BULK INSERT [dualshield_database_name].[dbo].[ip2location_db3]
    FROM 'FILE-PATH-TO\IP2LOCATION-LITE-DB5.CSV'
    WITH
    (
        FORMATFILE = 'FILE-PATH-TO\DB5.FMT'
    )
GO

Image Added

* replace "dualshield_database_name" with the name of the DualShield database. By default, it is "DualShield"

* 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 about 30 minutes to import the data.

Note:

* For dualshield version < 8.0, the name of the table in the database is called "ip2location_db3", although the import file is called "db5.csv"Please note that it can take about 30 minutes to import the data.