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.