How import .sql file to restore MySQL database
Make sure to start your localhost Server (XAMPP, WAMP, etc).
Open phpMyAdmin in your browser and input necessary credentials to access MySQL Database.
Create a new database and name this newly created database.
Import the .sql file into our created database by clicking Import Tab, selecting the file and clicking the Go button below.
Lastly, you will see this messages if the import is successful.
I've included in the downloadable of this tutorial a sample .sql file for you to practice.
That ends this tutorial. Happy Coding :)