How to do it...

  1. Download the zipped file:
shell> wget 'https://codeload.github.com/datacharmer/test_db/zip/master' -O master.zip
  1. Unzip the file:
shell> unzip master.zip
  1. Load the data:
shell> cd test_db-mastershell> mysql -u root -p < employees.sqlmysql: [Warning] Using a password on the command line interface can be insecure.INFOCREATING DATABASE STRUCTUREINFOstorage engine: InnoDBINFOLOADING departmentsINFOLOADING employeesINFOLOADING dept_empINFOLOADING dept_managerINFOLOADING titlesINFOLOADING salariesdata_load_time_diffNULL
  1. Verify the data:
shell> mysql -u root -p  employees -Amysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection ...

Get MySQL 8 Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial