-
Download the sql file
wget http://downloads.mysql.com/docs/world.sql.gz
-
Uncompress the file
The file we downloaded is compressed, so we'll need to de-compress it
gunzip world.sql.gz
-
Import it into mysql
mysql -u root -p < world.sql
-
(optionally) clean up
Since we imported the file into mysql, the data should be in our database, so we don't need the
world.sql
file anymorerm world.sql
Created
March 20, 2018 21:12
-
-
Save zgulde/e79152cfb7fc3eef69576c63eabc13e1 to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment