- Download and extract the Yelp dataset JSON files into the same folder as this repository.
- Start your MySQL server.
- Create and activate a new database called
yelp
:CREATE DATABASE yelp; USE yelp;
. - Modify
models.py
with the username and password to connect to your database. - Run the import scripts:
python json_to_mysql.py reset # clears tables
python json_to_mysql.py business
python json_to_mysql.py user
python json_to_mysql.py review