Sunday, October 29, 2017

Notes about loading data files for "Learning MySQL"

I previously downloaded the data files via wget.  I don't remember if I had to install wget first.  If I did, it was something like:

sudo apt-get install wget
mkdir Download
cd Download
wget http://url

Now install unzip:

sudo apt-get install unzip
unzip Data.zip -d Data

Now we can load up the data files -- change into directory with data files:

cd ~/download/Data/Data/SQL_files_with_foreign_key_references

Drop into mysql monitor

mysql -u root -p

Now load up the data files:

source Flight.sql
source University.sql
source music.sql




No comments:

Post a Comment

Note: Only a member of this blog may post a comment.