374fb19b44fccdcec68620cfc5c6d93b553fd2ae
galt
  Fri Jul 17 17:05:43 2020 -0700
updated geoIp data and tables which were 1 year old. Jonathan found VPN in LA was mapping to europe. refs #25906

diff --git src/hg/geoIp/load-tables src/hg/geoIp/load-tables
index 947bab9..054157a 100755
--- src/hg/geoIp/load-tables
+++ src/hg/geoIp/load-tables
@@ -1,11 +1,11 @@
 #!/bin/tcsh
 # we want to use autoSql to make the .sql 
 # which is handy for initializing empty tables
 # but we do not need the .c and .h files at this time.
 foreach f ( *.as )
     echo $f
-    hgsql hgFixed -e "drop table $f:r"
-    hgsql hgFixed < $f:r.sql
-    hgsql hgFixed -e "load data local infile '$f:r.tab' into table $f:r"
-    hgsql hgFixed -e "select count(*) from $f:r"
+    hgsql geoIp -e "drop table $f:r"
+    hgsql geoIp < $f:r.sql
+    hgsql geoIp -e "load data local infile '$f:r.tab' into table $f:r"
+    hgsql geoIp -e "select count(*) from $f:r"
 end