src/hg/makeDb/doc/hgFixed.txt 1.16

Index: src/hg/makeDb/doc/hgFixed.txt
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/makeDb/doc/hgFixed.txt,v
retrieving revision 1.15
retrieving revision 1.16
diff -b -B -U 4 -r1.15 -r1.16
--- src/hg/makeDb/doc/hgFixed.txt	26 Apr 2007 16:08:06 -0000	1.15
+++ src/hg/makeDb/doc/hgFixed.txt	10 Feb 2009 00:57:58 -0000	1.16
@@ -322,8 +322,20 @@
    # Load the other table.
    hgsql hgFixed -e "echo delete from rebaseRefs"
    hgsql hgFixed -e "load data local infile 'rebaseRefs.txt' into table rebaseRefs"   
 
+# REBASE 902 (2009) (DONE 2009-02-09, Andy)
+   ssh hgwdev
+   mkdir /hive/data/outside/rebase
+   cd /hive/data/outside/rebase
+   tail -n+15 rebaseRefs.txt | sed '/^$/d; s/^\s\+\([[:digit:]]\+\)\.\s\+\</\1\t/' > tmp
+   mv tmp rebaseRefs.txt
+   hgCutters hgFixed rebase.gcg
+   hgsql hgFixed -e "delete from rebaseRefs"
+   hgsql hgFixed -e "load data local infile 'rebaseRefs.txt' into table rebaseRefs"   
+   mkdir rebase902
+   mv rebase.gcg rebaseRefs.txt rebase902/
+
 # GLADSTONE hESC Novartis microarray data.
    # 1. Download http://www.genmapp.org/temp/humansimpleESC.zip
    # 2. Manually convert using MS access on Bob's laptop to a tab-delimited text file.
    # 3. Add column names to that file manually.