-
Type “unzip GeoIPCountryCSV.zip”. Press Enter.
At the Prompt Type “mysql -u root -p”. Press Enter.
You should get output like this ”Enter your password:”. Enter your root Pass for Mysql. Press Enter.
You should now have the “mysql>” prompt. Type ” use mailscanner; ”.
The Last line should say ”Database changed” and it should return you to the ”mysql>” prompt.
Then Type “LOAD DATA INFILE 'Location of the GeoIPCountryWhois.csv File' INTO TABLE geoip_country FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '”' LINES TERMINATED BY '\n';”. It should give you ouput like Lines 7&8
Query OK, 64627 rows affected (22.43 sec)
Records: 64627 Deleted: 0 Skipped: 0 Warnings: 0
You should be returned to the ”mysql>” Prompt. Type “\q”. To Exit back to the Shell.
You should now have a populated geoip_country table in mailscanner.
