adfd7617b6dad6537fd1fbab1b5f44710fabdf64 galt Mon Jun 13 16:43:56 2016 -0700 oops, need newer version of geoIpToCountry.c because we do NOT want dotted-quad format. Simple integers are fast and work well in the database. diff --git src/hg/geoIp/README src/hg/geoIp/README index 9ef8396..fa3a9cc 100644 --- src/hg/geoIp/README +++ src/hg/geoIp/README @@ -1,19 +1,21 @@ http://software77.net/geo-ip/ wget 'http://software77.net/geo-ip/?DL=1' -O IpToCountry.csv.gz gunzip IpToCountry.csv.gz +make +geoIpToCountry IpToCountry.csv > geoIpCountry.tab This was developed on hgFixed, and is still used and updated there. But we copy the two required-by-cgi tables gbNode and geoIpNode to hgcentral (hgcentraltest on hgwdev) for final release. The others shall remain in hgwdev.hgFixed db, as we need to periodically update them. This could be done even just once a year. The update script will only work on hgwdev. Then these two tables will be pushed to hgcentral on hgwbeta and RR. These helpful mysql functions make it convenient to store the IP addresses as 4-byte unsigned 32-bit numbers