{"id":6194,"date":"2011-03-09T06:21:35","date_gmt":"2011-03-09T11:21:35","guid":{"rendered":"http:\/\/info.template-help.com\/?p=6194"},"modified":"2017-07-11T06:40:14","modified_gmt":"2017-07-11T10:40:14","slug":"how-to-install-wordpress-theme-sample-data-sql-import-with-godaddy","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/how-to-install-wordpress-theme-sample-data-sql-import-with-godaddy.html","title":{"rendered":"How to install WordPress theme Sample data (SQL import with GoDaddy)"},"content":{"rendered":"

\r\n

ATTENTION: Importing the SQL <\/strong>file to your database will overwrite your existing content<\/strong> and website settings. DO NOT<\/strong> import the SQL file if you want to keep the existing content<\/p>\r\n

NOTE: ALWAYS<\/strong> backup your database before performing any modifications<\/p>\r\n

 <\/p>\r\n

This tutorial will show you how to import the WordPress theme sample data<\/strong>.<\/p>\r\n

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.<\/p>\r\n

\r\n\r\n\r\n<\/a>\r\n<\/div>\r\n

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.<\/p>\r\n

1. Open GoDaddy hosting control panel and go to Databases tab. There click MySQL icon.<\/p>\r\n

\"WordPress(click to enlarge)<\/span><\/a><\/p>\r\n

2. Select your WordPress database and click the Manage via PhpMyAdmin<\/strong><\/p>\r\n

\"WordPress(click to enlarge)<\/span><\/a><\/p>\r\n

3. In the PhpMyAdmin tool select your database from the left column.<\/p>\r\n

Note: There is a system database information_chema, do not edit it or perform any actions with it.<\/p>\r\n

\"WordPress(click to enlarge)<\/span><\/a><\/p>\r\n

4. In the top menu click Import.<\/p>\r\n

\"WordPress(click to enlarge)<\/span><\/a><\/p>\r\n

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

6. Open the SQL file from the template sources folder with your HTML editor (notepad, Dreamweaver, Expression Web etc.)<\/p>\r\n

7. Use the Find&Replace tool (CTRL+F) <\/strong>and replace all instances of “your_website_URL_here” with your URL. Save the file.<\/p>\r\n

8. Now you can import the SQL file. Go back to PhpMyAdmin tool<\/strong>, browse for the SQL file and click Go.<\/p>\r\n

\"WordPress(click to enlarge)<\/span><\/a><\/p>\r\n

Thats all, you’ve successfully imported the WordPress theme sample data.<\/p>\r\n

Feel free to check the detailed video tutorial below:
\r\nHow to import WordPress SQL file using GoDaddy control panel<\/a><\/p>\r\n<\/p>\r\n<\/p>\r\n

<\/p>","protected":false},"excerpt":{"rendered":"

This tutorial will show you how to import the WordPress theme sample data.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[247,728],"tags":[647,545,763,706,646,581,2405],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/6194"}],"collection":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=6194"}],"version-history":[{"count":1,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/6194\/revisions"}],"predecessor-version":[{"id":81828,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/6194\/revisions\/81828"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=6194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=6194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=6194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}