72cb6aba88d4830eb0638ae27ab1fee6eb2c1d68 pauline Tue Jun 12 15:25:47 2012 -0700 Commented out check of san diego remote mysql as jorge says it is not working. diff --git src/utils/qa/checkGenomeMysql src/utils/qa/checkGenomeMysql index 0723652..e6b749d 100755 --- src/utils/qa/checkGenomeMysql +++ src/utils/qa/checkGenomeMysql @@ -35,19 +35,20 @@ fi tableList=$(mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A -Ne "show tables" $db) # for each table in list do a select * limit 5. # Want to limit output or else the query would take forever. However, # can't do limit 1 since the first row of every table is stored in # the metadata and thus, mysql will not actually touch the table # if you do a select statement with a limit 1. Thus, we do a limit 5. # Throw away result of select statement and allow MySQL errors to be reported. # Also, genome-mysql is actually two hosts. Check both. for table in $tableList do mysql --user=genome --host=public-mysql1.cse.ucsc.edu -A -Ne "select * from $table limit 5" \ $db > /dev/null - mysql --user=genome --host=hgfs-sd.cse.ucsc.edu -A -Ne "select * from $table limit 5" \ - $db > /dev/null + +#PUT THIS BACK IF SD MACHINES COME BACK mysql --user=genome --host=hgfs-sd.cse.ucsc.edu -A -Ne "select * from $table limit 5" \ +# $db > /dev/null done exit 0