Run your xampp and start apache and MySql.
Add a new database on clicking on new from the left menu.
Now enter the name for database as pointed in the screenshot and click on the create button,
Now click on the database from left and then click on import(on the top of the page). After this choose you database file with .sql.zip extension or with .sql extension.
After choosing file go to the bottom of the page and click on Go button to start importing.
Your import has been successfully finished and now you can use your database. You can now insert, delete, alter and delete table or database also in phpmyadmin dashboard.
Thanks for visiting us.