Categories

phpMyAdmin. How to import sample data dump file

Rating: 5.0/5. From 7 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.

phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_1

2. From the left column, select your database.

phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_2

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.

phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_3

5. When you are done selecting the file, click the Go button at the bottom of the page.

phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_4

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