ce360469d3a8fbd4b54ffa823dbba24f79198a2f galt Thu Jun 23 17:20:23 2016 -0700 Adding a backup dump of hgFixed geoIp data tables. diff --git src/hg/geoIp/README src/hg/geoIp/README index 3a96a9f..e7a1e7c 100644 --- src/hg/geoIp/README +++ src/hg/geoIp/README @@ -179,21 +179,31 @@ like we did with the middle-east countries, overriding their default continent mappings in countryToNode. Not sure yet if I am going to do this again. It was what I did last time. The idea was to keep a backup of these important tables. That way perhaps hgFixed could be used when generating other sets of testing tables for redirect. TODO at the end: rename tables to real: gbNodeReal geoIpNodeReal + Make an extra backup of just the git untracked files just in case: mkdir /hive/data/outside/geoIp/ gitu | xargs -I X cp X /hive/data/outside/geoIp/ +Make a backup of the data too: + +mkdir /hive/data/outside/geoIp/geoIpTableDumps +mkdir /hive/data/outside/geoIp/geoIpTableDumps/2016-06-23 +# sadly we need to temporarily make it write-able by all so mysqld can write dump there. +chmod 777 /hive/data/outside/geoIp/geoIpTableDumps/2016-06-23 +hgsqldump hgFixed -T 2016-06-23 continent continentToNode country countryToContinent countryToNode gbNode geoIpCountry geoIpNode +chmod 775 /hive/data/outside/geoIp/geoIpTableDumps/2016-06-23 +