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
|