Changeset 368 for trunk/dbbuilder/src/org/bridgedb/download/ensembl_download.sh

Timestamp:

05/31/10 01:52:42 (2 years ago)

Author:

AlexanderPico

Message:

updated to work on plato cluster

Files:

• trunk/dbbuilder/src/org/bridgedb/download/ensembl_download.sh (modified) (5 diffs)

trunk/dbbuilder/src/org/bridgedb/download/ensembl_download.sh

@@ -37 +37 @@
 
   #create local mysql db
-  echo "create database if not exists genmapp_${mysql_go_name}" | ${mysql} -u genmapp -pfun4genmapp
+  echo "create database if not exists ${mysql_go_name}" | ${mysql} -u genmapp -pfun4genmapp
   #create schema
-  ${mysql} -u genmapp -pfun4genmapp genmapp_${mysql_go_name} < ./${mysql_go_name}.sql
+  ${mysql} -u genmapp -pfun4genmapp ${mysql_go_name} < ./${mysql_go_name}.sql
   #place in own scope due to "cd" command
   (
    cd ./${mysql_go_name}; for table_name in *.txt
    do
-    ${mysqlimport} -u genmapp -pfun4genmapp genmapp_${mysql_go_name} `pwd`/${table_name}
+    ${mysqlimport} -u genmapp -pfun4genmapp ${mysql_go_name} `pwd`/${table_name}
   done
  )
@@ -85 +85 @@
 
   #create local mysql db
-  echo "create database if not exists genmapp_${mysql_core_name}" | ${mysql} -u genmapp -pfun4genmapp
+  echo "create database if not exists ${mysql_core_name}" | ${mysql} -u genmapp -pfun4genmapp
   #create schema
-  ${mysql} -u genmapp -pfun4genmapp genmapp_${mysql_core_name} < ./${mysql_core_name}.sql
+  ${mysql} -u genmapp -pfun4genmapp ${mysql_core_name} < ./${mysql_core_name}.sql
   #place in own scope due to "cd" command
   (
@@ -93 +93 @@
    do
     #import data
-    ${mysqlimport} -u genmapp -pfun4genmapp genmapp_${mysql_core_name} `pwd`/${table_name}
+    ${mysqlimport} -u genmapp -pfun4genmapp ${mysql_core_name} `pwd`/${table_name}
   done
  )
@@ -132 +132 @@
 
   #create local mysql db
-  echo "create database if not exists genmapp_${mysql_efg_name}" | ${mysql} -u genmapp -pfun4genmapp
+  echo "create database if not exists ${mysql_efg_name}" | ${mysql} -u genmapp -pfun4genmapp
   #create schema
-  ${mysql} -u genmapp -pfun4genmapp genmapp_${mysql_efg_name} < ./${mysql_efg_name}.sql
+  ${mysql} -u genmapp -pfun4genmapp ${mysql_efg_name} < ./${mysql_efg_name}.sql
   #place in own scope due to "cd" command
   (
@@ -140 +140 @@
    do
     #import data
-    ${mysqlimport} -u genmapp -pfun4genmapp genmapp_${mysql_efg_name} `pwd`/${table_name}
+    ${mysqlimport} -u genmapp -pfun4genmapp ${mysql_efg_name} `pwd`/${table_name}
   done
  )