Categories

Featured templates

How to install WordPress theme Sample data (SQL import with GoDaddy)

Rating: 4.2/5. From 6 votes.
Please wait...

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

 

This tutorial will show you how to import the WordPress theme sample data.

The sample data is stored in the SQL file, it’s located in the template sources folder. The SQL file should be imported directly into your WordPress database.

Note: The SQL file will replace all your WordPress posts, pages etc with the sample content. So it’s not recommended to use the SQL import if you have a working blog and you don;t want to lose the data.

1. Open GoDaddy hosting control panel and go to Databases tab. There click MySQL icon.

WordPress SQL import 1(click to enlarge)

2. Select your WordPress database and click the Manage via PhpMyAdmin

WordPress SQL import 2(click to enlarge)

3. In the PhpMyAdmin tool select your database from the left column.

Note: There is a system database information_chema, do not edit it or perform any actions with it.

WordPress SQL import 3(click to enlarge)

4. In the top menu click Import.

WordPress SQL import 4(click to enlarge)

5. Now open the template package and check the dump_readme.txt file (step 4). It says that you need to replace the “your_website_URL_here” phrase with your website URL in the SQL file.

6. Open the SQL file from the template sources folder with your HTML editor (notepad, Dreamweaver, Expression Web etc.)

7. Use the Find&Replace tool (CTRL+F) and replace all instances of “your_website_URL_here” with your URL. Save the file.

8. Now you can import the SQL file. Go back to PhpMyAdmin tool, browse for the SQL file and click Go.

WordPress SQL import 5(click to enlarge)

Thats all, you’ve successfully imported the WordPress theme sample data.

Feel free to check the detailed video tutorial below:
How to import WordPress SQL file using GoDaddy control panel

Innovative Wordpress Themes
This entry was posted in WordPress, WordPress Tutorials and tagged data, database, GoDaddy, import, sample, SQL, WordPress. 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