{"id":33695,"date":"2016-09-18T16:13:56","date_gmt":"2016-09-18T16:13:56","guid":{"rendered":"https:\/\/hostduplex.com\/kb\/?p=56"},"modified":"2016-09-18T16:13:56","modified_gmt":"2016-09-18T16:13:56","slug":"how-to-import-database-via-phpmyadmin-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.hostduplex.com\/kb\/how-to-import-database-via-phpmyadmin-in-cpanel\/","title":{"rendered":"How to import database via phpMyAdmin in cPanel?"},"content":{"rendered":"<p><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><strong>1.<\/strong> Log into your cPanel account.<\/span><\/span><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>2.<\/strong> In the <strong>Databases<\/strong> section, click on the<strong> phpMyAdmin<\/strong> icon.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-icon.gif\" alt=\"\" align=\"middle\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>3.<\/strong> In left side-bar, Click on the expand button to expand the database like &#8220;example&#8221;.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-expand-db.gif\" alt=\"\" align=\"left\" \/><\/span><span style=\"font-size: medium;\"><br \/>\n<\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>4.<\/strong> Under your cPanel username, you can see a list of all databases. Select an appropriate database in which you want to import SQL.<\/p>\n<p><span style=\"font-size: medium;\"><strong><br \/>\n5. <\/strong>Click on the <strong>Import<\/strong> button.<br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-import.gif\" alt=\"\" \/><\/span><\/p>\n<p><strong>6. <\/strong>Under <strong>File to Import<\/strong> click on the <strong>Browse<\/strong> button, Select SQL file from your PC.<strong><br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-import2.gif\" alt=\"\" \/><\/strong><\/p>\n<p><strong>7.<\/strong> Scroll down and then click on the<strong> <strong>Go<\/strong> <\/strong>button.<\/p>\n<p>If its show a message in green box then it means your SQL is successfully uploaded.<strong><br \/>\n<img decoding=\"async\" src=\"\/kb\/img\/phpmyadmin-successfully.gif\" alt=\"\" \/><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Log into your cPanel account. 2. In the Databases section, click on the phpMyAdmin icon. 3. In left side-bar, Click on the expand button to expand the database like &#8220;example&#8221;. &nbsp; &nbsp; &nbsp; &nbsp; 4. Under your cPanel username, you can see a list of all databases. Select an&#8230;<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[57],"tags":[],"class_list":["post-33695","post","type-post","status-publish","format-standard","hentry","category-databases"],"_links":{"self":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts\/33695","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/comments?post=33695"}],"version-history":[{"count":0,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/posts\/33695\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/media?parent=33695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/categories?post=33695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/tags?post=33695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}