{"id":1307,"date":"2016-09-18T16:13:56","date_gmt":"2016-09-18T16:13:56","guid":{"rendered":"https:\/\/wickedrobot.dev\/support\/?p=56"},"modified":"2025-10-08T06:14:05","modified_gmt":"2025-10-08T06:14:05","slug":"how-to-import-a-database-via-phpmyadmin-in-cpanel","status":"publish","type":"epkb_post_type_1","link":"https:\/\/wickedrobot.dev\/knowledge-base\/how-to-import-a-database-via-phpmyadmin-in-cpanel","title":{"rendered":"How to Import a Database via phpMyAdmin in cPanel"},"content":{"rendered":"<p><span style=\"font-size: medium;\"><span style=\"font-size: medium;\"><br \/>\n<span style=\"font-size: medium;\"><strong>1.<\/strong> Log in to 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 <strong>phpMyAdmin<\/strong>.<\/span><br \/>\n<span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/img\/phpmyadmin-icon.gif\" alt=\"\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong>3.<\/strong> From the navigation tree in the left sidebar, select an appropriate database in which you want to import data using the SQL file.<\/span><br \/>\n<span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/img\/phpmyadmin-expand-db.gif\" alt=\"\" \/><\/span><\/p>\n<p><span style=\"font-size: medium;\"><strong><br \/>\n4. <\/strong>Click on <strong>Import<\/strong>.<\/span><br \/>\n<span style=\"font-size: medium;\"><img decoding=\"async\" src=\"\/img\/phpmyadmin-import.gif\" alt=\"\" \/><\/span><\/p>\n<p><strong>5. <\/strong>Under <strong>File to Import<\/strong>, click on <strong>Browse<\/strong> and select SQL file from your computer.<strong><img decoding=\"async\" src=\"\/img\/phpmyadmin-import2.gif\" alt=\"\" \/><\/strong><\/p>\n<p><strong>6.<\/strong> Scroll down and click on <strong><strong>Go<\/strong><\/strong>.<\/p>\n<p>If it shows a success message, your SQL has been successfully uploaded.<strong><img decoding=\"async\" src=\"\/img\/phpmyadmin-successfully.gif\" alt=\"\" \/><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Log in to your cPanel account. 2. In the Databases section, click on phpMyAdmin. 3. From the navigation tree in the left sidebar, select an appropriate database in which you want to import data using the SQL file. 4. Click on Import. 5. Under File to Import, click on Browse and select SQL file &#8230; <a title=\"How to Import a Database via phpMyAdmin in cPanel\" class=\"read-more\" href=\"https:\/\/wickedrobot.dev\/knowledge-base\/how-to-import-a-database-via-phpmyadmin-in-cpanel\" aria-label=\"Read more about How to Import a Database via phpMyAdmin in cPanel\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"epkb_post_type_1_category":[88],"epkb_post_type_1_tag":[],"class_list":["post-1307","epkb_post_type_1","type-epkb_post_type_1","status-publish","hentry","epkb_post_type_1_category-databases"],"_links":{"self":[{"href":"https:\/\/wickedrobot.dev\/jipumel\/wp\/v2\/epkb_post_type_1\/1307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wickedrobot.dev\/jipumel\/wp\/v2\/epkb_post_type_1"}],"about":[{"href":"https:\/\/wickedrobot.dev\/jipumel\/wp\/v2\/types\/epkb_post_type_1"}],"author":[{"embeddable":true,"href":"https:\/\/wickedrobot.dev\/jipumel\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wickedrobot.dev\/jipumel\/wp\/v2\/comments?post=1307"}],"version-history":[{"count":0,"href":"https:\/\/wickedrobot.dev\/jipumel\/wp\/v2\/epkb_post_type_1\/1307\/revisions"}],"wp:attachment":[{"href":"https:\/\/wickedrobot.dev\/jipumel\/wp\/v2\/media?parent=1307"}],"wp:term":[{"taxonomy":"epkb_post_type_1_category","embeddable":true,"href":"https:\/\/wickedrobot.dev\/jipumel\/wp\/v2\/epkb_post_type_1_category?post=1307"},{"taxonomy":"epkb_post_type_1_tag","embeddable":true,"href":"https:\/\/wickedrobot.dev\/jipumel\/wp\/v2\/epkb_post_type_1_tag?post=1307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}