{"id":10546,"date":"2014-03-09T06:03:20","date_gmt":"2014-03-09T10:03:20","guid":{"rendered":"http:\/\/info.template-help.com\/?p=10546"},"modified":"2019-03-20T02:35:50","modified_gmt":"2019-03-20T06:35:50","slug":"phpmyadmin-how-to-import-sample-data-dump-file-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/phpmyadmin-how-to-import-sample-data-dump-file-phpmyadmin.html","title":{"rendered":"phpMyAdmin. How to import sample data dump file"},"content":{"rendered":"<div class=\"inline-banner\">\r\n\t<a href=\"https:\/\/tracking.opienetwork.com\/aff_c?offer_id=461&aff_id=13765&aff_sub=tmhelp\" target=\"_blank\">\r\n\t\t<img src=\"https:\/\/www.templatemonster.com\/help\/wp-content\/themes\/tm_help_redesign\/images\/hostpapa.png\" \/>\r\n\t<\/a>\r\n<\/div>\r\n<p>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. <\/p>\r\n\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=GYcZ1-7G0ps?width=1280&amp;height=720\" rel=\"prettyPhoto\">phpMyAdmin. How to import sample data dump file phpMyAdmin<\/a>\r\n\r\n<p class=\"warning\">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.<\/p>\r\n<p class=\"attention\">NOTE: ALWAYS <a href=\"\/help\/phpmyadmin-how-to-backup-a-database.html\" target=\"_blank\">back up<\/a> your database before performing any modifications<\/p>\r\n<p><strong>1.<\/strong> Open phpMyAdmin tool.<\/p>\r\n\r\n<a href=\"\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_1.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_1-300x181.png\" alt=\"phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_1\" width=\"300\" height=\"181\" class=\"aligncenter size-medium wp-image-33517\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_1-300x181.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_1-150x90.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_1.png 971w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p><strong>2.<\/strong> From  the left column, select your database.<\/p>\r\n\r\n<a href=\"\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_2.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_2-300x216.png\" alt=\"phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_2\" width=\"300\" height=\"216\" class=\"aligncenter size-medium wp-image-33518\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_2-300x216.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_2-150x108.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_2.png 800w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p><strong>3.<\/strong> In  the top menu, click the <strong>Import<\/strong> tab.<\/p>\r\n<p><strong>4.<\/strong> Click the <strong>Browse<\/strong> button and in the window which will appear, open your template folder. <\/p>\r\n\r\n<a href=\"\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_3.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_3-300x196.png\" alt=\"phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_3\" width=\"300\" height=\"196\" class=\"aligncenter size-medium wp-image-33519\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_3-300x196.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_3-150x98.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_3.png 888w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p><strong>5.<\/strong> When you are done selecting the file, click the <strong>Go <\/strong>button at the bottom of the page. <\/p>\r\n\r\n<a href=\"\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_4.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_4-300x194.png\" alt=\"phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_4\" width=\"300\" height=\"194\" class=\"aligncenter size-medium wp-image-33520\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_4-300x194.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_4-150x97.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2011\/10\/phpMyAdmin_How_to_import_sample_data_dump_file_via_phpMyAdmin_tool_4.png 888w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p>Feel free to check the detailed video tutorial below:<\/p>\r\n\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=GYcZ1-7G0ps?width=1280&amp;height=720\" rel=\"prettyPhoto\">phpMyAdmin. How to import sample data dump file phpMyAdmin<\/a>\r\n\r\n<div class=\"inline-banner\">\r\n<a href=\"https:\/\/www.templatemonster.com\/cart.php?addOffer=587\">\r\n<img src=\"\/help\/files\/banners\/inline\/Banner-1-(500-x100).jpg\" \/>\r\n<\/a>\r\n<\/div>","protected":false},"excerpt":{"rendered":"<p>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.<\/p>\n","protected":false},"author":37,"featured_media":33521,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1019],"tags":[545,580,706,765,810,769,581],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/10546"}],"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\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=10546"}],"version-history":[{"count":2,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/10546\/revisions"}],"predecessor-version":[{"id":85322,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/10546\/revisions\/85322"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/33521"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=10546"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=10546"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=10546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}