Project

General

Profile

« Previous | Next » 

Revision 6491

Added by Aaron Marcuse-Kubitza almost 12 years ago

publish_analytical_db: Load to bien3_adb instead of bien_web

View differences:

bin/publish_analytical_db
2 2 
# Publishes analytical DB to nimoy
3 3 
# Usage: self analytical_aggregate.csv
4 4 

  		




  5
  
  
    
mysql --password --database=bien_web <<EOF


  		




  
  5
  
    
mysql --password --database=bien3_adb <<EOF


  		




  6
  6
  
    
LOAD DATA LOCAL INFILE '$1'


  		




  7
  7
  
    
INTO TABLE analytical_aggregate


  		




  8
  8
  
    
FIELDS TERMINATED BY ','


  		












Also available in:  Unified diff