src/utils/qa/weeklybld/buildHgCentralSql.csh 1.21

Index: src/utils/qa/weeklybld/buildHgCentralSql.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/utils/qa/weeklybld/buildHgCentralSql.csh,v
retrieving revision 1.20
retrieving revision 1.21
diff -b -B -U 1000000 -r1.20 -r1.21
--- src/utils/qa/weeklybld/buildHgCentralSql.csh	17 Nov 2009 20:59:32 -0000	1.20
+++ src/utils/qa/weeklybld/buildHgCentralSql.csh	14 May 2010 02:29:20 -0000	1.21
@@ -1,78 +1,76 @@
 #!/bin/tcsh
 cd $WEEKLYBLD
 
 if ( "$HOST" != "hgwdev" ) then
 	echo "error: you must run this script on hgwdev!"
 	exit 1
 endif
 
 hgsqldump --all -d -c -h genome-centdb hgcentral \
 sessionDb userDb | sed -e "s/genome-centdb/localhost/" > \
 /tmp/hgcentraltemp.sql
 
 # --skip-extended-insert 
 #   to make it dump rows as separate insert statements
 hgsqldump --all --skip-extended-insert -c -h genome-centdb hgcentral \
 defaultDb blatServers dbDb dbDbArch gdbPdb liftOverChain clade genomeClade targetDb | \
 sed -e "s/genome-centdb/localhost/" >> /tmp/hgcentraltemp.sql
 
 
 # get rid of some mysql5 trash in the output we don't want.
 # also need to break data values at rows so the diff and cvs 
 # which are line-oriented work better.
 grep -v "Dump completed on" /tmp/hgcentraltemp.sql | \
 sed -e "s/AUTO_INCREMENT=[0-9]* //" > \
 /tmp/hgcentral.sql
 
 echo
 echo "*** Diffing old new ***"
 diff /usr/local/apache/htdocs/admin/hgcentral.sql /tmp/hgcentral.sql
 if ( ! $status ) then
 	echo
 	echo "No differences."
 	echo
 	exit 0
 endif 
 
 if ( "$1" != "real" ) then
 	echo
 	echo "Not real.   To make real changes, put real as cmdline parm."
 	echo
 	exit 0
 endif 
 
 rm /usr/local/apache/htdocs/admin/hgcentral.sql
 cp -p /tmp/hgcentral.sql /usr/local/apache/htdocs/admin/hgcentral.sql
 rm hiding/hgcent/hgcentral.sql
 cp -p /tmp/hgcentral.sql hiding/hgcent/hgcentral.sql
 cd hiding/hgcent
 set temp = '"'"v${BRANCHNN}"'"'
 cvs -d hgwdev:/projects/compbio/cvsroot commit -m $temp  hgcentral.sql
 if ( $status ) then
 	echo "error during cvs commit of hgcentral.sql."
 	exit 1
 endif
 
 # push to hgdownload
 ssh -n qateam@hgdownload "rm /mirrordata/apache/htdocs/admin/hgcentral.sql"
 scp -p /usr/local/apache/htdocs/admin/hgcentral.sql qateam@hgdownload:/mirrordata/apache/htdocs/admin/
 
-
-# OLD WAY NOT NEEDED
-#echo
-#echo "Push request:"
-#echo "Please push from dev --> hgdownload "
-#echo "  /usr/local/apache/htdocs/admin/hgcentral.sql"
-#echo
-#echo "reason: (describe here)"
-
 echo
-echo "NOTE:  If this is an update of hgcentral that is not part of a new"
-echo "build, also ask for the relevant tables to be pushed to hgdownload"
-echo "for mirror site access. For example:"
-echo "  Please also push the hgcentral/blatServers table"
-echo "  from hgnfs1 --> hgdownload."
+echo "A new hgcentral.sql file should now be present at:"
+echo "  http://hgdownload.cse.ucsc.edu/admin/"
+echo
+echo "If it is not, you can request a push of the file:"
+echo "  /usr/local/apache/htdocs/admin/hgcentral.sql"
+echo "  from hgwdev --> hgdownload "
+echo
+echo "NOTE:  Some mirrors like to get hgcentral tables via ftp or rsync"
+echo "from hgdownload.cse.ucsc.edu/mysql/hgcentral/ instead of from the"
+echo "hgcentral.sql file. To make a table in hgcentral available there"
+echo "right now, ask for it to be pushed from hgnfs1 --> hgdownload. (Or"
+echo "just wait for the automatic weekly rsync.)"
 echo
 
 exit 0