The following tutorial will show you how to import the sample data dump file into your database. This is usually done through the phpMyAdmin tool located in your hosting control panel.
ATTENTION: Importing the SQL file to your database will overwrite your existing content and website settings. DO NOT import the SQL file if you want to keep the existing content.
NOTE: ALWAYS backup your database before performing any modifications
1. Open phpMyAdmin tool
2. From the left column select your database
3. From the top menu click the Import tab
4. Click Browse button and in the appeared window open your template folder.
The dump files are usually located in the template sources or sources/sample_data folders. They are also could be provided is .sql file or .zip or .gzip archives. All these file types could be imported into phpMyAdmin.
5. When you are done selecting the file click the Go button at the bottom of the page.
Feel free to check the detailed video tutorial below:phpMyAdmin. How to import sample data dump file phpMyAdmin,