GitHub - ekg/USDA-SR22-importer: assists in importing the USDA's SR22 nutritional database from MS Access to MySQL

ekg / USDA-SR22-importer Public

Notifications You must be signed in to change notification settings
Fork 5
Star 10

assists in importing the USDA's SR22 nutritional database from MS Access to MySQL

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
Makefile		Makefile
README		README
createdb.sh		createdb.sh
sr22.sql		sr22.sql
tables		tables

Repository files navigation

These files are useful in creating a MySQL database from the SR22 nutrition
information produced by the USDA.

You must first create a new user and database, make sure that these are
referred to in createdb.sh.

Then make sure you have a recent copy of mdb-tools.  These tools are used to
convert the sr22 data from access format into SQL.

Edit create_db.sh to reflect your local MySQL installation, user, password, and
database.

Then:

    make sr22

This should insert all the data into your mysql database!