16d9c22e94d9e76761aa2c93215b03aa91ec3ad9
brianlee
  Tue Mar 5 12:29:51 2019 -0800
adding hubPublic to backup table in backupCentral.csh script

diff --git src/utils/qa/backupCentral.csh src/utils/qa/backupCentral.csh
index b649ff4..66331fb 100755
--- src/utils/qa/backupCentral.csh
+++ src/utils/qa/backupCentral.csh
@@ -1,25 +1,26 @@
 #!/bin/tcsh
 source `which qaConfig.csh`
 
 ###############################################
 # 
 #  04-09-07
 #  Robert Kuhn
 #
 #  Grab hgcentral* tables from dev, beta, rr and store as files.
 # 
+# Edit version in kent/src/utils/qa/backupCentral.csh
 ###############################################
 
 set directory="" 
 set today=""
 set dirPath=""
 set urlPath=""
 set lastYr=""
 set devString=""
 set betaString=""
 set rrString=""
  
 if ($#argv == 0 || $#argv > 1) then
   # no command line args
   echo
   echo "  grab hgcentral* tables from dev, beta, rr and store as files."
@@ -50,24 +51,24 @@
 set devString="hgcentraltest"
 set betaString="-h $sqlbeta hgcentralbeta"
 set rrString="-h $sqlrr hgcentral" 
 
 # set contents field size limit to 10 million
 set sizeLimit=10000000
 foreach table ( namedSessionDb )
   hgsql   $devString -N -e "select * from namedSessionDb where length(contents) < $sizeLimit" \
     | sort >> $dirPath/$today/hgwdev.$table
   hgsql  $betaString -N -e "select * from namedSessionDb where length(contents) < $sizeLimit" \
     | sort >> $dirPath/$today/hgwbeta.$table
   hgsql    $rrString -N -e "select * from namedSessionDb where length(contents) < $sizeLimit" \
     | sort >> $dirPath/$today/rr.$table
 end
 
-foreach table ( blatServers clade dbDb defaultDb genomeClade liftOverChain targetDb )
+foreach table ( blatServers clade dbDb defaultDb genomeClade hubPublic liftOverChain targetDb )
   hgsql  $devString -N -e "SELECT * FROM $table" | sort >> $dirPath/$today/hgwdev.$table
   hgsql $betaString -N -e "SELECT * FROM $table" | sort >> $dirPath/$today/hgwbeta.$table
   hgsql   $rrString -N -e "SELECT * FROM $table" | sort >> $dirPath/$today/rr.$table
 end
 
 
 echo $urlPath
 chmod 650 $dirPath/$today/*.namedSessionDb