root/bin/publish_analytical_db @ 6474
| 1 | 6471 | aaronmk | #!/bin/sh
|
|---|---|---|---|
| 2 | # Publishes analytical DB to nimoy
|
||
| 3 | # Usage: self analytical_aggregate.csv
|
||
| 4 | |||
| 5 | 6474 | aaronmk | 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
|