MySQL example data sources

Check out my much larger list of MySQL examples and other public sources at GitHub Data.

This is a collated list of FREE data sources and steps to load this data into a MySQL database.

mysql.com example databases

Data: https://dev.mysql.com/doc/index-other.html
Data Model: example with sample SQL.

World Database

# Get the data
wget https://downloads.mysql.com/docs/world-db.tar.gz
ls -lh world-db.tar.gz
tar xvfz world-db.tar.gz
du -sh world-db

# Load the data
docker run -i --rm mysql mysql -h${CLUSTER_ENDPOINT} -u${MYSQL_USER} -p${MYSQL_PASSWD} < data/world-db/world.sql

# Perform a simple SQL validation
docker run -i --rm mysql mysql -h${CLUSTER_ENDPOINT} -u${MYSQL_USER} -p${MYSQL_PASSWD} world-db -e "SELECT COUNT(*) FROM city; SELECT COUNT(*) FROM country;"

Sakila Database

Data: https://dev.mysql.com/doc/index-other.html
Documentation: Manual
Data Model: tables, tables & columns

# Get the data
wget https://downloads.mysql.com/docs/sakila-db.tar.gz
ls -lh sakila-db.tar.gz
tar xvfz sakila-db.tar.gz
du -sh sakila.db

# load the schema & data
docker run -i --rm mysql mysql -h${CLUSTER_ENDPOINT} -u${MYSQL_USER} -p${MYSQL_PASSWD} -f < data/sakila-db/sakila-schema.sql
docker run -i --rm mysql mysql -h${CLUSTER_ENDPOINT} -u${MYSQL_USER} -p${MYSQL_PASSWD} < data/sakila-db/sakila-data.sql

Employee Database

Data: https://dev.mysql.com/doc/index-other.html

Menagerie Database

Data: https://dev.mysql.com/doc/index-other.html

Airport Database

Data: https://dev.mysql.com/doc/index-other.html
Documentation: Manual

The Data Charmer

Employee test database

Data: https://github.com/datacharmer/test_db

NYC City Bike

About
Data

US Department of Transportation

US Department of Transportation Data Sources

MySQL Tutorial

Overview: https://www.mysqltutorial.org/mysql-sample-database.aspx
Data Model: Data Model

Zip Codes

https://zipcodedownload.com/free-zipcode-database
Zips with lat/long