7c25764e7799be529d0d904a71082d30e7b46be8 chmalee Wed Jun 14 10:21:49 2017 -0700 Fixing typo in table name so hgVai works on gbib. Fixes gbib update errors, refs #19565 diff --git src/browserbox/root/updateBrowser.sh src/browserbox/root/updateBrowser.sh index 198dfea..32e6a54 100755 --- src/browserbox/root/updateBrowser.sh +++ src/browserbox/root/updateBrowser.sh @@ -353,31 +353,31 @@ # also create the directories for the cram files # cram also requires that the directories are writable by the apache user if [ ! -d /data/cramCache ]; then mkdir -p /data/cramCache/pending /data/cramCache/error chown -R www-data:www-data /data/cramCache fi # -- end July 2016 # July 2016: genbank tables are now in hgFixed. By touching a few files, we make sure that at least refseqStatus # is rsync'ed later, otherwise gbib is really slow, refs #17842 touch /data/mysql/hgFixed/refSeqStatus.MYI /data/mysql/hgFixed/refSeqStatus.MYD /data/mysql/hgFixed/refSeqStatus.frm touch /data/mysql/hgFixed/refLink.MYI /data/mysql/hgFixed/refLink.MYD /data/mysql/hgFixed/refLink.frm # Jan 2017: hgVai does not work if /data/mysql/hg19/wgEncodeRegTfbsClusteredInputsV3 is not present, so force this # table into the rsync, refs #18778 -touch /data/mysql/hg19/wgEncodeRegTfbsClusteredInputsV3.{frm,MRI,MYD} +touch /data/mysql/hg19/wgEncodeRegTfbsClusteredInputsV3.{frm,MYI,MYD} # Jun 2017: An Ubuntu security update in early 2017 deactivated LOAD DATA in Mysql # so we are switching it back on if grep -q secure-file-priv /etc/mysql/my.cnf; then true else echo Allowing LOAD DATA in MySQL and restart MySQL sed -i '/\[mysqld\]/a secure-file-priv = ""' /etc/mysql/my.cnf service mysql restart fi # we can now remove the old tables rm -f /data/mysql/hg19/refSeqStatus* if [ "$1" != "hgwdev" ] ; then