Revision 6472
Added by Aaron Marcuse-Kubitza almost 12 years ago
| 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 --execute="LOAD DATA INFILE '$1' \ |
|
| 5 |
mysql --password --database=bien_web --execute="LOAD DATA LOCAL INFILE '$1' \
|
|
| 6 | 6 |
INTO TABLE analytical_aggregate;" |
Also available in: Unified diff
publish_analytical_db: Use LOAD DATA LOCAL INFILE instead of LOAD DATA INFILE to avoid needing FILE permissions on bien_web