{"id":74111,"date":"2016-07-29T09:29:12","date_gmt":"2016-07-29T13:29:12","guid":{"rendered":"http:\/\/www.templatemonster.com\/help\/?p=74111"},"modified":"2020-01-29T06:14:12","modified_gmt":"2020-01-29T11:14:12","slug":"wordpress-how-to-install-a-template-using-dump-sql-file","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/wordpress-how-to-install-a-template-using-dump-sql-file.html","title":{"rendered":"WordPress. How to install a template using dump.sql file"},"content":{"rendered":"<p>This tutorial will help you to install the WordPress template with the sample content using dump.sql file.<\/p>\r\n\r\n <div class=\"video-container\">\r\n\t<iframe src=\"https:\/\/www.youtube.com\/embed\/pDT940Vqh5k\"><\/iframe>\r\n<\/div>\r\n<div class=\"inline-banner\">\r\n<a href=\"https:\/\/www.templatemonster.com\/service-center\/\">\r\n<img src=\"\/help\/files\/banners\/inline\/Banner-3-(835-x100).jpg\" \/>\r\n<\/a>\r\n<\/div>\r\n<p>First of all we advise that you check the documentation, provided with your template. Open your template package, downloaded from your personal delivery page and find there a <strong>Documentation<\/strong> folder.<\/p>\r\n\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.1.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.1-300x73.png\" alt=\"how to install a WordPress template using dump file.1\" width=\"300\" height=\"73\" class=\"alignnone size-medium wp-image-74117\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.1-300x73.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.1-150x37.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.1.png 655w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p>Please, open the <strong>Documentation (Installation and Editing).html<\/strong> file and check the installation instructions there.<\/p>\r\n<p>Take into account that the instructions in the template documentation may differ from the described below. These are generic for all the <a href=\"https:\/\/www.templatemonster.com\/wordpress-themes.php\" target=\"_blank\" title=\"WordPress templates\">WordPress templates<\/a>, instructions in the template package are for your specific template.<\/p>\r\n<p>Your WordPress engine is supposed to be installed before template installation. If you did not do that, please check this tutorial. Once WordPress is installed, please, follow these steps:<\/p>\r\n\r\n<div class=\"inline-banner\">\r\n<img src=\"\/help\/files\/banners\/zmz\/tmh\/en\/1_3.png\" onclick=\"showChat()\">\r\n<\/div>\r\n<ol>\r\n\t<li><p>Installing <b>themexxx.zip<\/b> file. There are 2 ways to upload your file: <\/p>\r\n\t\t<ol>\r\n\t\t\t<li><p>Open your WordPress admin panel, go to <b>Appearance > Themes > Add New<\/b>. You will see there the &#8216;upload&#8217; button, please, browse the folder themexxx.zip and install it.<\/p>\r\n\t\t\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.2.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.2-300x71.png\" alt=\"how to install a WordPress template using dump file.2\" width=\"300\" height=\"71\" class=\"alignnone size-medium wp-image-74118\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.2-300x71.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.2-150x35.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.2-1024x241.png 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.2.png 1348w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t\t\t<\/li>\r\n\t\t\t\r\n\t\t\t<li><p>Please, upload the file directly to the <strong>wp-content\/themes<\/strong>, and unzip it there.<\/p>\r\n\t\t\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.3.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.3-300x125.png\" alt=\"how to install a WordPress template using dump file.3\" width=\"300\" height=\"125\" class=\"alignnone size-medium wp-image-74119\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.3-300x125.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.3-150x63.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.3.png 640w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t\t\t<\/li>\r\n\t\t\t\r\n\t\t\t<li><p>After you upload the template, activate it in the admin panel at the <b>Appearance > Themes > Activate theme<\/b>.<\/p>\r\n\t\t\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.4.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.4-300x121.png\" alt=\"how to install a WordPress template using dump file.4\" width=\"300\" height=\"121\" class=\"alignnone size-medium wp-image-74120\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.4-300x121.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.4-150x61.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.4-1024x414.png 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.4.png 1035w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t\t\t<\/li>\r\n\t\t<\/ol>\r\n\t<\/li>\r\n\t\r\n\t<li><p>Installing <b>required plugins<\/b>. The main files of the template have been successfully uploaded, now, please, upload the plugins. There are also 2 ways to do it: <\/p>\r\n\t\t<p>Go to <b>WordPress admin panel > Plugins > Add new > Upload<\/b> and choose the plugin from the <b>sources\/plugins<\/b>, and activate it. Please, upload all the plugins one-by-one.<\/p>\r\n\t\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.5.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.5-300x89.png\" alt=\"how to install a WordPress template using dump file.5\" width=\"300\" height=\"89\" class=\"alignnone size-medium wp-image-74121\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.5-300x89.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.5-150x45.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.5-1024x304.png 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.5.png 1354w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t\t<p>With the help of FTP or File Manager. Please, upload zipped plugins to the <b>wp-conent\/plugins<\/b> folder and unzip them there.<\/p>\r\n\t\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.6.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.6-300x131.png\" alt=\"how to install a WordPress template using dump file.6\" width=\"300\" height=\"131\" class=\"alignnone size-medium wp-image-74122\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.6-300x131.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.6-150x66.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.6.png 643w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t<\/li>\r\n\t<li><p>Installing <b>sample data<\/b>. Now we should upload images to your site. Upload the <b>Uploads<\/b> folder from the theme\/manual install directory to wp-content folder on your server. You can do it via the FTP or File Manager. Please re-write the existing folder uploads on your server. <\/p>\r\n\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.7.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.7-300x134.png\" alt=\"how to install a WordPress template using dump file.7\" width=\"300\" height=\"134\" class=\"alignnone size-medium wp-image-74123\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.7-300x134.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.7-150x67.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.7.png 613w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t<\/li>\r\n\t<li><p>Importing <b>dump.sql<\/b> file. This is the last step. Please, open the <b>dump.sql<\/b> file, located in <b>theme\/manual<\/b> folder of the template package (usually the name is themexxx.sql) in any text editor (for example, Notepad++ or Dreamweaver). Then use the search function (CTRL + F hotkey) to find all the instances of <b>your_website_url_here<\/b> and replace them with your website url. Make sure to click on <b>Replace all<\/b> button and save it.<\/p>\r\n\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.8.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.8-300x221.png\" alt=\"how to install a WordPress template using dump file.8\" width=\"300\" height=\"221\" class=\"alignnone size-medium wp-image-74114\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.8-300x221.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.8-150x111.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.8.png 642w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t\t\r\n\t\t<p>Now we should go into hosting control panel and access the <b>PhpMyAdmin<\/b> database tool in order to import  the modified &#8216;themeXXX.sql&#8217; file to the WordPress database. Once you enter the PhpMyAdmin database tool, select your database. It should look like on a screenshot below. Feel free to check the online tutorial on <a href=\"\/help\/phpmyadmin-how-to-import-sample-data-dump-file-phpmyadmin.html\" target=\"_blank\"> how to upload the SQL file to database<\/a>.<\/p>\r\n\t\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.9.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.9-300x111.png\" alt=\"how to install a WordPress template using dump file.9\" width=\"300\" height=\"111\" class=\"alignnone size-medium wp-image-74115\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.9-300x111.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.9-150x56.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.9-1024x380.png 1024w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.9.png 1238w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t\t\r\n\t\t<p class=\"warning\">Note: Importing the SQL file to your database will overwrite your existing site content and website settings. Do not import the SQL file if you want to keep the existing content! Always backup your database before performing any modifications.<\/p>\r\n\t\t<p>Click on <strong>Import<\/strong> tab, click <strong>Browse<\/strong> and select your modified themeXXX.sql file. Click on the <strong>Go<\/strong> button after doing that.<\/p> \r\n\t\t\r\n<a class=\"darkbox\" href=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.10.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.10-300x267.png\" alt=\"how to install a WordPress template using dump file.10\" width=\"300\" height=\"267\" class=\"alignnone size-medium wp-image-74116\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.10-300x267.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.10-150x133.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2016\/07\/how-to-install-a-WordPress-template-using-dump-file.10.png 934w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t\t\r\n\t\t<p>Open your site. It should look exactly like on the template&#8217;s live demo.<\/p>\r\n\t<\/li>\r\n<\/ol>\r\n<p>Sometimes SQL file import does not work due to tables&#8217; prefix incompatibility. Feel free to check a detailed tutorial on <a href=\"\/help\/wordpress-how-to-change-database-tables-prefix-in-sql-file.html\" target=\"_blank\">how to change your table prefix<\/a>.<\/p>\r\n<p>Feel free to check the detailed video tutorial below:<\/p>\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=pDT940Vqh5k?width=1280&amp;height=720\" rel=\"prettyPhoto\">WordPress. How to install a template using dump.sql file<\/a>\r\n<p>In case you&#8217;re seeking a <a href=\"https:\/\/www.templatemonster.com\/category\/personal-pages-wordpress-themes\/\">wordpress personal template<\/a> to put up a professional website, take a look at our premium themes.<\/p>","protected":false},"excerpt":{"rendered":"<p>This tutorial will help you to install the WordPress template with the sample content using dump.sql file.<\/p>\n","protected":false},"author":67,"featured_media":74124,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[728],"tags":[580,1241,2390,581,2405],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/74111"}],"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\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=74111"}],"version-history":[{"count":5,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/74111\/revisions"}],"predecessor-version":[{"id":85766,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/74111\/revisions\/85766"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/74124"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=74111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=74111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=74111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}