Changeset 8380 for trunk/MagicSoft/Mars/datacenter/scripts

Timestamp:

03/20/07 17:21:03 (18 years ago)

Author:

hoehne

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/scripts

Files:

• budb (modified) (1 diff)
• dbchk (modified) (1 diff)
• dunotseqruns (modified) (1 diff)
• findnewstars (modified) (1 diff)
• findnotseqruns (modified) (1 diff)
• sourcefile (modified) (4 diffs)

trunk/MagicSoft/Mars/datacenter/scripts/budb

@@ -28 +28 @@
 echo "writing all databases to file..." >> $logfile 2>&1
 set +C
-mysqldump --host=hercules --all-databases -u dump | bzip2 -9 -c > $file$datum$end 2>> $logfile
+mysqldump --host=vela --all-databases -u dump | bzip2 -9 -c > $file$datum$end 2>> $logfile
 
 

trunk/MagicSoft/Mars/datacenter/scripts/dbchk

@@ -9 +9 @@
 stardir=/magic/data/star
 # access to the sql database
-alias mymysql='mysql -s -u MAGIC -h hercules --password=d99swMT!'
+alias mymysql='mysql -s -u MAGIC -h vela --password=d99swMT!'
 # database name
 db=MyMagic

trunk/MagicSoft/Mars/datacenter/scripts/dunotseqruns

@@ -4 +4 @@
 query="select concat('/magic/data/rawfiles', Date_Format(adddate(fRunStart, interval 12 HOUR), '/%Y/%m/%d/'),'*', fRunNumber, '*.raw.gz')  from RunData where fSequenceFirst='0' and fRunStart > '2004-08-20'"
 
-files=`mysql -u MAGIC --host=hercules --password=d99swMT! MyMagic -s -e " $query"`
+files=`mysql -u MAGIC --host=vela --password=d99swMT! MyMagic -s -e " $query"`
 
 sum=0

trunk/MagicSoft/Mars/datacenter/scripts/findnewstars

@@ -67 +67 @@
 done
 
-alias mymysql='mysql -u MAGIC --password=d99swMT! --host=hercules MyMagic -s -e'
+alias mymysql='mysql -u MAGIC --password=d99swMT! --host=vela MyMagic -s -e'
 
 query="SELECT fSequenceFirst FROM SequenceProcessStatus WHERE NOT ISNULL(fStar) "

trunk/MagicSoft/Mars/datacenter/scripts/findnotseqruns

@@ -106 +106 @@
 done
 
-alias mymysql='mysql -u MAGIC --password=d99swMT! --host=hercules MyMagic -s -e'
+alias mymysql='mysql -u MAGIC --password=d99swMT! --host=vela MyMagic -s -e'
 
 if [ "$dat" = "" ] && [ "$cal" = "" ] && [ "$ped" = "" ] && ! [ "$all" = "yes" ]

trunk/MagicSoft/Mars/datacenter/scripts/sourcefile

@@ -310 +310 @@
    query=$query" order by $primary desc "
 #   echo " QUERY: "$query
-   if ! process=`mysql -s -u $us --password=$pw --host=hercules $db -e " $query "`
+   if ! process=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
    then
       echo "ERROR could not query processes from db -> exit"
@@ -356 +356 @@
    query=$query" limit 0, 1 "
 #   echo " QUERY: "$query
-   if ! process=`mysql -s -u $us --password=$pw --host=hercules $db -e " $query "`
+   if ! process=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
    then
       echo "ERROR could not query process from db -> exit"
@@ -392 +392 @@
 #   echo " QUERY: "$query
    numproc=0
-   if ! numproc=`mysql -s -u $us --password=$pw --host=hercules $db -e " $query "`
+   if ! numproc=`mysql -s -u $us --password=$pw --host=vela $db -e " $query "`
    then
       echo "ERROR could not query number of todo proceses from db -> continue"
@@ -430 +430 @@
    query=$query" where $primary='$var2'"
    echo " QUERY: "$query
-   if ! mysql -s -u $us --password=$pw --host=hercules $db -e " $query "
+   if ! mysql -s -u $us --password=$pw --host=vela $db -e " $query "
    then
       echo "ERROR could not insert status into db -> exit"