usda-data-dump Code
Take note of plain and c formats for postgressql (pg_restore)
Brought to you by:
kengimel
Menu
▾
▴
Tree [cc7879] master / History
| File | Date | Author | Commit |
|---|---|---|---|
| docs | 2015-09-23 |
Ikenna Okpala
|
[029b6f] Documentation updates |
| README.md | 2015-09-23 |
Ikenna Okpala
|
[cc7879] Cosmetic changesWq |
| nutrition_sr24_plain.dump | 2015-09-23 |
Ikenna Okpala
|
[36e079] Updates |
| nutrition_sr26_custom.dump | 2015-09-23 |
Ikenna Okpala
|
[c4a9b2] rename custom dump |
| nutrition_sr26_plain.dump | 2015-09-23 |
Ikenna Okpala
|
[36e079] Updates |
Read Me
USDA
Take note of plain and c formats for postgressql (pg_restore)
Examples
Export
C Format
pg_dump --format=custom db_name > nutrition_sr<number>_c.dump
Plain Format
pg_dump --format=plain db_name > nutrition_sr<number>_plain.dump
Import / Restore
Plain Format
heroku pg:backups restore 'https://raw.githubusercontent.com/globalfoodbook/USDA-DATA/master/nutrition_sr26_plain.dump' DATABASE_URL --app APP --confirm APP
C Format
heroku pg:backups restore 'https://raw.githubusercontent.com/globalfoodbook/USDA-DATA/master/nutrition_sr26_c.dump' DATABASE_URL --app APP --confirm APP
Import ElephantSQL
NB: Plain Format Used http://elephantsql.com
psql postgres://<username>:<password>@pellefant.db.elephantsql.com:5432/<db_name> < nutrition_sr<number>_plain.dump
Links
USDA Nutrition Database: http://www.ars.usda.gov/Services/docs.htm?docid=8964
Importing and Exporting Heroku Postgres Databases with PG Backups
Updates for nutrition label: healthy food recipes