Step 1: Open a Command Prompt.
Step 2: Go to the MySQL bin folder.
cd "C:\Program Files\MySQL\MySQL Server 5.6\bin"
or
cd "C:\Program Files\MySQL\MySQL Server 5.7\bin"
Step 3: Execute the following command to restore the database.
mysql -u [username] –p [database_name] < [dump_file.sql]
> database_name is the name of the empty database into which you want to load data from the backup file.
Step 4: Enter the username password if prompted for a password.