How to import the database

1. Download the SQL files

Here's a direct link to download two SQL files from Dropbox:

Now, you need to load the data to your local MySQL database.

OPTIONAL: You may have to create the database before loading (P.S: You get the mysql password when you download mysql: SAVE IT).

First, load the sample_ip database:

mysql -u root sample_ip < sample_ip.sql

Second, load the sample_staff database:

mysql -u root sample_staff < sample_staff.sql

You can also import the .sql files to MySQL Workbench. Just select in menu File - Run SQL Script. No need to "Open" it, just Run it.

Quite a lot of people ask why the user_stat table is empty. It's intentional - you will fill it in one of the lessons. Have fun! :)

And you're done! Enjoy and check my course on Udemy: