Skip to content

USDA National Nutrition Database for Standard Reference MySQL Loader

Notifications You must be signed in to change notification settings

nmani/usda_loader

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

USDA National Nutrition Database for Standard Reference http://www.ars.usda.gov/services/docs.htm?docid=8964

Background: Importer for USDA nutrient database into a MySQL database via the ASCII files provided.

The following command to generate schema.sql: mdb-schema srXX.mdb mysql > schema.sql. Feel free to edit schema.sql accordingly to your needs

This project used Erik Garrison's USDA-SR22-importer for inspiration: https://github.com/ekg/USDA-SR22-importer

Run: docker-compose up after cloning

Output: db_dump.sql to import into your MySQL server via mysql -h[host] -P[port] -u[user] -p[root_password] [db_name] < db_dump.sql

About

USDA National Nutrition Database for Standard Reference MySQL Loader

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages