Index: trunk/DataCheck/Tools/get_data.sh
===================================================================
--- trunk/DataCheck/Tools/get_data.sh	(revision 19029)
+++ trunk/DataCheck/Tools/get_data.sh	(revision 19030)
@@ -220,6 +220,6 @@
    fi
    #echo "$queryint"
-   mysql --defaults-file=$sqlpw -u root  $dbname -s -e "$queryint" >> $fileint
-   #mysql --defaults-file=$sqlpw -u root  $dbname -e "$queryint" 
+   mysql --defaults-file=$sqlpw -u factread --host=$host $dbname -s -e "$queryint" >> $fileint
+   #mysql --defaults-file=$sqlpw -u factread --host=$host $dbname -e "$queryint" 
    
    
@@ -237,6 +237,6 @@
    fi
    #echo "$queryext"
-   mysql --defaults-file=$sqlpw -u root  $dbname -s -e "$queryext" >> $fileext
-   #mysql --defaults-file=$sqlpw -u root  $dbname -e "$queryext"
+   mysql --defaults-file=$sqlpw -u factread --host=$host $dbname -s -e "$queryext" >> $fileext
+   #mysql --defaults-file=$sqlpw -u factread --host=$host $dbname -e "$queryext"
 }
 
@@ -244,4 +244,7 @@
 # db
 sqlpw=/home/$USER/.mysql.pw # file with mysql credentials
+host=lp-fact
+#host=10.0.100.21
+#host=localhost
 dbname=factdata # name of database
 # defaults for zd and threshold
@@ -270,6 +273,6 @@
 # choose analysis 
 #table="AnalysisResultsAllQLA" # N/A
-#table="AnalysisResultsRunLP" # QLA 
-table="AnalysisResultsRunISDC"  # ISDC
+table="AnalysisResultsRunLP" # QLA 
+#table="AnalysisResultsRunISDC"  # ISDC
 # time range
 nightmin=20111115
@@ -282,19 +285,10 @@
 # example (adapt to your needs)
 
-# crab
-source=5
-name="Crab_nightly"
-bin=-1
-get_results
-name="Crab_20min"
-bin=20
-get_results
-name="Crab_period"
-bin=0
-get_results
-name="Crab_season"
-bin=-365
-nightmin=20110716
-nightmax=20180716
+# 501 MAGIC 
+source=2
+name="Mrk501_2014JulAug"
+bin=-1
+nightmin=20140714
+nightmax=20140805
 get_results