src/hg/utils/mysql/dev40ToDev50.csh 1.2
1.2 2009/09/04 17:17:16 hiram
fix example
Index: src/hg/utils/mysql/dev40ToDev50.csh
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/utils/mysql/dev40ToDev50.csh,v
retrieving revision 1.1
retrieving revision 1.2
diff -b -B -U 1000000 -r1.1 -r1.2
--- src/hg/utils/mysql/dev40ToDev50.csh 4 Sep 2009 17:15:23 -0000 1.1
+++ src/hg/utils/mysql/dev40ToDev50.csh 4 Sep 2009 17:17:16 -0000 1.2
@@ -1,50 +1,50 @@
#!/bin/csh -fe
# $Id$
if ( $#argv < 2 || $#argv > 3 ) then
echo "usage: dev40ToDev50.csh [option] <db> <tableName>"
echo "option:"
echo "-replace - in the case where <tableName> already exists"
echo " to cause a drop and reload of the table."
- echo "e.g.: dev40ToDev50.csh -replace hg19 trackDb"
+ echo "e.g.: dev40ToDev50.csh -replace hg18 grp"
exit 255
endif
set DUMP40 = /cluster/bin/scripts/dumpDev40.csh
set LOAD50 = /cluster/bin/scripts/loadDev50.csh
set REPLACE = ""
set TMP = $$
if ( $#argv == 2 ) then
set DB = $1
set TBL = $2
else
set REPLACE = "-replace"
if ( "$argv[1]" == "-replace" ) then
set DB = $2
set TBL = $3
else if ( "$argv[2]" == "-replace" ) then
set DB = $1
set TBL = $3
else if ( "$argv[3]" == "-replace" ) then
set DB = $1
set TBL = $2
else
echo "ERROR: 3 arguments given, not one of which is '-replace'"
echo "usage: dev40ToDev50.csh [option] <db> <tableName>"
exit 255
endif
endif
mkdir /data/tmp/devToDev.${TMP}
cd /data/tmp/devToDev.${TMP}
${DUMP40} ${DB} ${TBL}
${LOAD50} ${REPLACE} ${DB} ${TBL}.sql ${TBL}.txt.gz
rm -f ${TBL}.sql ${TBL}.txt.gz
cd /tmp
rmdir /data/tmp/devToDev.${TMP}