How to Upload the dump.sql Manually

Here you can find the instructions on how to install sample data.
Please DO NOT import sample data if you have a live website as it will completely replace your database contents, and all your website data will be LOST.

Magento template package contains the sample data file (dump.sql). This file is located under the /sources/sample_data folder of your template. It allows you to load sample data, so that your website looks exactly like our demo template.

  • sample_data — contains Magento theme sample data files.
  • pub — contains files and directories that should be uploaded to the root directory of your Magento installation.
  • dump.sql — the database backup file. Contains the theme sample content.
Do not import dump.sql if you already have the data on your site. By importing dump.sql all the products will be erased from your store. If you do not want to install sample data, use clean database while installing Magento. Skip the sample data installation step.
In order to install the dump file, follow the steps below:

1. Log into cPanel > navigate to the Databases section and click on the phpMyAdmib icon.

 upload magento dump

2. Select the database which is  used for Magento Commerce.

 upload magento dump

3. Navigate to the Import” tab and click on the Browse button.

import sample data

4. Find the “/sources/sample_data” folder of your template and select the dump.sql file. Click GO.

 

install sample data
* The import process can take a few minutes.