[DetoNater]

Quote:

Originally Posted by Konstantinos Extract the .zip and go to pma. Select database, SQL tab and execute: pawn Код: LOAD DATA LOCAL INFILE '/path_to_file/GeoIPCountryWhois.csv' INTO TABLE list_ipv4 FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' (@ip_from_string,@ip_to_string,range_start,range_end,country_code,@country_name); It took about 8 seconds to insert 144,865 rows.

the one which we have prepared and i have it in .sql extension()...... or the default maxmind's which is downloaded without modifying as .csv