Changeset 301

Show
Ignore:
Timestamp:
02/13/10 02:52:36 (2 years ago)
Author:
AlexanderPico
Message:

modified to distinguish derby productions from web service

Location:
trunk/dbbuilder/src/org/bridgedb/build/scripts
Files:
1 added
1 modified

Legend:

Unmodified
Added
Removed

  • trunk/dbbuilder/src/org/bridgedb/build/scripts/buildPathVisio.sh

    r292 r301  
    4444# --net_buffer_length=30K (used to limit size of extended-inserts)  
    4545# --skip-extended-insert (used to force line-by-line inserts) 
    46 mysqldump --compatible=db2 --no-create-info --skip-add-locks --skip-disable-keys --skip-quote-names --net_buffer_length=30K -u genmapp -pfun4genmapp ${Database} > ${Database}.db2.sql.data 
    47 ## Dump table creation statements separately for 2-step recontruction later (e.g., for bridgedb rest server) 
    48 mysqldump --no-data -u genmapp -pfun4genmapp ${Database} > ${Database}.db2.sql.tables 
    49 ## Dump table creation statements separately for 2-step recontruction later (e.g., for bridgedb rest server) 
    50 mysqldump --no-data -u genmapp -pfun4genmapp ${Database} > ${Database}.db2.sql.tables 
     46mysqldump --compatible=db2 --no-create-info --skip-add-locks --skip-disable-keys --skip-quote-names --net_buffer_length=30K -u genmapp -pfun4genmapp ${Database} > ${Database}.db2.sql.temp 
    5147 
    5248## Clean up dump file 
    5349# Replace in emacs using esc-% (! = all occurances) 
    5450# Replace in vi using :%s/old/new/g (use vi if file is too large for emacs) 
    55 cat ${Database}.db2.sql.data | sed "s/\/\*/--/g" | sed "s/\\\'/\'\'/g" > ${Database}.db2.sql 
     51cat ${Database}.db2.sql.temp | sed "s/\/\*/--/g" | sed "s/\\\'/\'\'/g" > ${Database}.db2.sql 
    5652         
    5753## Create & Fill Derby via ij tool  
    … …  
    6864zip -r -0 ${Database}.bridge database/ 
    6965mv database ${Database} 
     66 
     67## Beef up MySQL version of Derby databases for web service deployment 
     68mysql -u genmapp -pfun4genmapp < PathVisioMySQL_BEEF.sql 
     69mysqldump --skip-add-locks --skip-disable-keys --skip-quote-names --net_buffer_length=30K -u genmapp -pfun4genmapp ${Database} > ${Database}.sql.dump 
    7070 
    7171# report on products (check size > 1.9M)