How to Load Sample Database into MySQL Database Server

Summary: in this tutorial, you will learn how to load the MySQL sample database into MySQL database server using MySQL Workbench. After the tutorial, you will have classicmodels sample database loaded into MySQL server for practicing and learning MySQL.

First, download the classicmodels database from the MySQL sample database section

Second, unzip the downloaded file into a temporary folder named temp as follows:

Third, launch MySQL Workbench from the Program Files and follow the steps below:

Launch MySQL Workbench

Launch MySQL Workbench from the Program files

New Connection

Click New Connection to add a new database connection

Setup New Connection

Enter the connection name e.g., local and click OK button

Connection

Click the local database connection to connect to MySQL database server

Connect to MySQL Server

Enter the password for the root account and click OK

MySQL Workbench

MySQL Workbench is open

Open SQL Script

From the File menu, choose "Open SQL Script..."

Choose SQL Script File

Choose the Sample Database File e.g., c:\temp\mysqlsampledatabase.txt

Execute SQL Script

Click execute button from the toolbar to execute the SQL script.

Refresh All

Right click inside the Schema panel and click Refresh All to update the panel

classicmodels database

The classimodels datababase is loaded successfully into MySQL database server

In this tutorial, we have shown you step by step how to load the MySQL sample database named classicmodels into MySQL database server using MySQL Workbench.