root/bin/publish_analytical_db @ 6474
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
|