{"id":56042,"date":"2015-10-19T05:10:19","date_gmt":"2015-10-19T09:10:19","guid":{"rendered":"http:\/\/www.templatemonster.com\/help\/?p=56042"},"modified":"2018-09-21T08:15:40","modified_gmt":"2018-09-21T12:15:40","slug":"how-to-import-database-tables-via-sql-tab-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/how-to-import-database-tables-via-sql-tab-in-phpmyadmin.html","title":{"rendered":"How to import database tables via SQL tab in phpMyAdmin"},"content":{"rendered":"<p>This tutorial provides a description of how to import database tables via SQL tab in phpMyAdmin.<\/p>\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=Gqk0ZzyNoxY?width=1280&amp;height=720\" rel=\"prettyPhoto\">How to import database tables via SQL tab in phpMyAdmin<\/a>\r\n<p>In order to import database tables via SQL tab in phpMyAdmin, you should do the following:<\/p>\r\n<ol>\r\n<li><p>Open your <strong>dump.sql<\/strong> file with a text editor (e.g., Notepad++, Sublime Text 3).<\/p>\r\n<\/li>\r\n<li><p>Select all the content\/tables of the file (Ctrl+A) and copy them (Ctrl+C).<\/p> \r\n<\/li>\r\n<li><p>Navigate to your <strong>database<\/strong> in <strong>phpMyAdmin<\/strong>, click the <strong>SQL<\/strong> tab above, paste all the content\/tables of dump.sql file (ctrl+V):<\/p>\r\n\r\n<a href=\"\/help\/wp-content\/uploads\/2015\/10\/scrn12.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/10\/scrn12-300x169.jpg\" alt=\"scrn1\" width=\"300\" height=\"169\" class=\"aligncenter size-medium wp-image-56043\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/10\/scrn12-300x169.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/10\/scrn12-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/10\/scrn12.jpg 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<\/li>\r\n<li><p>Click <strong>Go<\/strong>:<\/p>\r\n\r\n<a href=\"\/help\/wp-content\/uploads\/2015\/10\/scrn22.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2015\/10\/scrn22-300x169.jpg\" alt=\"scrn2\" width=\"300\" height=\"169\" class=\"aligncenter size-medium wp-image-56044\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/10\/scrn22-300x169.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/10\/scrn22-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2015\/10\/scrn22.jpg 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n<\/li>\r\n<\/ol>\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=Gqk0ZzyNoxY?width=1280&amp;height=720\" rel=\"prettyPhoto\">How to import database tables via SQL tab in 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>This tutorial provides a description of how to import database tables via SQL tab in phpMyAdmin.<\/p>\n","protected":false},"author":94,"featured_media":56047,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1019],"tags":[764,706,810,581,1085],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/56042"}],"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\/94"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=56042"}],"version-history":[{"count":1,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/56042\/revisions"}],"predecessor-version":[{"id":82810,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/56042\/revisions\/82810"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/56047"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=56042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=56042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=56042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}