1. Type “unzip GeoIPCountryCSV.zip”. Press Enter.
  2. At the Prompt Type “mysql -u root -p”. Press Enter.
  3. You should get output like this ”Enter your password:”. Enter your root Pass for Mysql. Press Enter.
  4. You should now have the “mysql>” prompt. Type ” use mailscanner; ”.
  5. The Last line should say ”Database changed” and it should return you to the ”mysql>” prompt.
  6. 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
  7. Query OK, 64627 rows affected (22.43 sec)
  8. Records: 64627 Deleted: 0 Skipped: 0 Warnings: 0
  9. You should be returned to the ”mysql>” Prompt. Type “\q”. To Exit back to the Shell.
  10. You should now have a populated geoip_country table in mailscanner.
mailwatch/tipandtricks/geoipupdate.txt · Last modified: 2012/01/11 16:36 by gman529
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 3.0 Unported
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki Get 
MailWatch for MailScanner at SourceForge.net. Fast, secure and Free Open Source software downloads