root/bin/publish_analytical_db @ 6486
| 1 |
#!/bin/sh
|
|---|---|
| 2 |
# Publishes analytical DB to nimoy
|
| 3 |
# Usage: self analytical_aggregate.csv
|
| 4 |
|
| 5 |
mysql --password --database=bien_web <<EOF |
| 6 |
LOAD DATA LOCAL INFILE '$1' |
| 7 |
INTO TABLE analytical_aggregate
|
| 8 |
FIELDS TERMINATED BY ','
|
| 9 |
OPTIONALLY ENCLOSED BY '"'
|
| 10 |
ESCAPED BY '"'
|
| 11 |
IGNORE 1 LINES
|
| 12 |
;
|
| 13 |
EOF
|