Skip to content

Instantly share code, notes, and snippets.

@zgulde
Created March 20, 2018 21:12
Show Gist options
  • Save zgulde/e79152cfb7fc3eef69576c63eabc13e1 to your computer and use it in GitHub Desktop.
Save zgulde/e79152cfb7fc3eef69576c63eabc13e1 to your computer and use it in GitHub Desktop.

Bonus DB Setup

  1. Download the sql file

    wget http://downloads.mysql.com/docs/world.sql.gz
    
  2. Uncompress the file

    The file we downloaded is compressed, so we'll need to de-compress it

    gunzip world.sql.gz
    
  3. Import it into mysql

    mysql -u root -p < world.sql
    
  4. (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 anymore

    rm world.sql
    
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment