phpMyAdmin. How to import sample data dump file

Rating: 5.0. From 6 votes.
Please wait...

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 available in your hosting control panel.

phpMyAdmin. How to import sample data dump file phpMyAdmin

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 back up your database before performing any modifications

1. Open phpMyAdmin tool.


2. From the left column, select your database.


3. In the top menu, click the Import tab.

4. Click the Browse button and in the window which will appear, open your template folder.


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
This entry was posted in Hosting FAQ and tagged database, dump, import, MySQL, phpMyAdmin, sample data, SQL. Bookmark the permalink.

Submit a ticket

If you are still unable to find a sufficient tutorial regarding your issue please use the following link to submit a request to our technical support team. We'll provide you with our help and assistance within next 24 hours: Submit a ticket

  • Sin

    in “theme1254.sql” I’ve replaced all instances of “your_website_url_here” to my website URL, imported the dump file successfully, I activated the theme in WordPress’ backend, copied all the files as said in the readme.txt but still cannot see the theme in the WordPress frontend. What’s wrong? Did I miss anything?
    Do you offer any help? Would you need my WP admin password? I’d gladly hand it out – just to get it working!!!

    No votes yet.
    Please wait...
    • Anonymous

      Our technicians will be glad to help you, please contact them directly using the online help desk at
      Provide them with access to your hosting server and WordPress admin panel and they will provide you with further assistance.

      No votes yet.
      Please wait...