{"id":3389,"date":"2014-08-05T15:18:00","date_gmt":"2014-08-05T13:18:00","guid":{"rendered":"http:\/\/localhost\/helpcentre\/?p=3389"},"modified":"2026-01-30T10:44:34","modified_gmt":"2026-01-30T08:44:34","slug":"import-phpmyadmin","status":"publish","type":"post","link":"https:\/\/xneelo.co.za\/help-centre\/website\/managing-website\/import-phpmyadmin\/","title":{"rendered":"How to import your database via phpMyAdmin in konsoleH"},"content":{"rendered":"<p>Use the<b> phpMyAdmin<\/b> tool within konsoleH to import a copy of your database to your hosting account.<\/p>\n<h2>Import<\/h2>\n<ol>\n<li>Browse to <strong><a href=\"http:\/\/secure.konsoleh.co.za\" target=\"_blank\" rel=\"noopener noreferrer\">konsoleH<\/a><\/strong> and log in\u00a0at <a href=\"https:\/\/xneelo.co.za\/help-centre\/accounts-and-payments\/konsoleh-access-levels\/\" target=\"_blank\" rel=\"noopener noreferrer\">(Admin or Domain level)<\/a><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15443\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2016\/06\/kh-login-wide.png\" alt=\"kh-login-wide\" width=\"2082\" height=\"689\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2016\/06\/kh-login-wide.png 2082w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2016\/06\/kh-login-wide-300x99.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2016\/06\/kh-login-wide-1024x339.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2016\/06\/kh-login-wide-768x254.png 768w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2016\/06\/kh-login-wide-1536x508.png 1536w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2016\/06\/kh-login-wide-2048x678.png 2048w\" sizes=\"auto, (max-width: 2082px) 100vw, 2082px\" \/><\/p>\n<p>2. If Admin level: Select or search for a domain name in the <strong>Hosting Services<\/strong>\u00a0tab<\/p>\n<p>3. Select <strong>Manage Services<\/strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15127\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-services.png\" alt=\"kh-manage-services\" width=\"2020\" height=\"1128\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-services.png 2020w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-services-300x168.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-services-1024x572.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-services-768x429.png 768w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-services-1536x858.png 1536w\" sizes=\"auto, (max-width: 2020px) 100vw, 2020px\" \/><\/p>\n<p>4. Select <strong>Manage MySQL\u00a0<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15157\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql3.png\" alt=\"kh-manage-mysql3\" width=\"250\" height=\"469\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql3.png 250w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql3-160x300.png 160w\" sizes=\"auto, (max-width: 250px) 100vw, 250px\" \/><\/p>\n<p>5. Select a database<\/p>\n<p>6. Click <strong>phpMyAdmin<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15135\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql-2.png\" alt=\"kh-manage-mysql-2\" width=\"1620\" height=\"279\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql-2.png 1620w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql-2-300x52.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql-2-1024x176.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql-2-768x132.png 768w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql-2-1536x265.png 1536w\" sizes=\"auto, (max-width: 1620px) 100vw, 1620px\" \/><\/p>\n<p>7. Select the <strong>database name<\/strong> to expand the tables, then select <strong>Import<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15161\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import.png\" alt=\"phpmyadmin-import\" width=\"2470\" height=\"294\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import.png 2470w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import-300x36.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import-1024x122.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import-768x91.png 768w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import-1536x183.png 1536w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import-2048x244.png 2048w\" sizes=\"auto, (max-width: 2470px) 100vw, 2470px\" \/><\/p>\n<p>8. Select <b>Browse<\/b>\u00a0under the <b>File to Import<\/b>\u00a0section.<\/p>\n<p>9. Select the <b>dump file<\/b> you wish to import and click <b>Open<\/b><\/p>\n<p>10. Select the required <b>Format<\/b>. In most cases, <b>SQL<\/b>\u00a0will be sufficient.<\/p>\n<p>11. Select <b>Go<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15163\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import2.png\" alt=\"phpmyadmin-import2\" width=\"1640\" height=\"1004\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import2.png 1640w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import2-300x184.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import2-1024x627.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import2-768x470.png 768w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import2-1536x940.png 1536w\" sizes=\"auto, (max-width: 1640px) 100vw, 1640px\" \/><\/p>\n<p><b>Note:<\/b> The phpMyAdmin tool within konsoleH can only import database dump files that are <strong>250<\/strong><b>\u00a0MB<\/b> or smaller in size. Should your database dump file be larger than <strong>2<\/strong><b>50 MB<\/b>, you may import it <a href=\"https:\/\/xneelo.co.za\/help-centre\/website\/import-database-via-ssh\/\">via command-line<\/a> using SSH.<\/p>\n","protected":false,"plain":"Use the<b> phpMyAdmin<\/b> tool within konsoleH to import a copy of your database to your hosting account.\r\n<h2>Import<\/h2>\r\n<ol>\r\n \t<li>Browse to <strong><a href=\"http:\/\/secure.konsoleh.co.za\" target=\"_blank\" rel=\"noopener noreferrer\">konsoleH<\/a><\/strong> and log in\u00a0at <a href=\"https:\/\/xneelo.co.za\/help-centre\/accounts-and-payments\/konsoleh-access-levels\/\" target=\"_blank\" rel=\"noopener noreferrer\">(Admin or Domain level)<\/a><\/li>\r\n<\/ol>\r\n<img class=\"alignnone size-full wp-image-15443\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2016\/06\/kh-login-wide.png\" alt=\"kh-login-wide\" width=\"2082\" height=\"689\" \/>\r\n\r\n2. If Admin level: Select or search for a domain name in the <strong>Hosting Services<\/strong>\u00a0tab\r\n\r\n3. Select <strong>Manage Services<\/strong><img class=\"alignnone size-full wp-image-15127\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-services.png\" alt=\"kh-manage-services\" width=\"2020\" height=\"1128\" \/>\r\n\r\n4. Select <strong>Manage MySQL\u00a0<\/strong>\r\n\r\n<img class=\"alignnone size-full wp-image-15157\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql3.png\" alt=\"kh-manage-mysql3\" width=\"250\" height=\"469\" \/>\r\n\r\n5. Select a database\r\n\r\n6. Click <strong>phpMyAdmin<\/strong>\r\n\r\n<img class=\"alignnone size-full wp-image-15135\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/kh-manage-mysql-2.png\" alt=\"kh-manage-mysql-2\" width=\"1620\" height=\"279\" \/>\r\n\r\n7. Select the <strong>database name<\/strong> to expand the tables, then select <strong>Import<\/strong>\r\n\r\n<img class=\"alignnone size-full wp-image-15161\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import.png\" alt=\"phpmyadmin-import\" width=\"2470\" height=\"294\" \/>\r\n\r\n8. Select <b>Browse<\/b>\u00a0under the <b>File to Import<\/b>\u00a0section.\r\n\r\n9. Select the <b>dump file<\/b> you wish to import and click <b>Open<\/b>\r\n\r\n10. Select the required <b>Format<\/b>. In most cases, <b>SQL<\/b>\u00a0will be sufficient.\r\n\r\n11. Select <b>Go<\/b>\r\n\r\n<img class=\"alignnone size-full wp-image-15163\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-import2.png\" alt=\"phpmyadmin-import2\" width=\"1640\" height=\"1004\" \/>\r\n\r\n<b>Note:<\/b> The phpMyAdmin tool within konsoleH can only import database dump files that are <strong>250<\/strong><b>\u00a0MB<\/b> or smaller in size. Should your database dump file be larger than <strong>2<\/strong><b>50 MB<\/b>, you may import it <a href=\"https:\/\/xneelo.co.za\/help-centre\/website\/import-database-via-ssh\/\">via command-line<\/a> using SSH."},"excerpt":{"rendered":"<p>Use the phpMyAdmin tool within konsoleH to import a copy of your database to your hosting account.<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"lsx_disable_title":"0","_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"categories":[168],"tags":[17919,17922,15460,657,659],"topics":[10403],"class_list":["post-3389","post","type-post","status-publish","format-standard","hentry","category-managing-website","tag-import-your-database-via-phpmyadmin","tag-import-database","tag-database","tag-phpmyadmin","tag-import-mysql","topics-konsoleh-tools"],"acf":[],"additional_meta":{"category_title":[{"term_id":168,"name":"Managing your Website","slug":"managing-website","term_group":0,"term_taxonomy_id":168,"taxonomy":"category","description":"Managing your Website","parent":166,"count":52,"filter":"raw","term_order":"83","cat_ID":168,"category_count":52,"category_description":"Managing your Website","cat_name":"Managing your Website","category_nicename":"managing-website","category_parent":166}],"tag_title":[{"term_id":17919,"name":"import your database via phpMyAdmin","slug":"import-your-database-via-phpmyadmin","term_group":0,"term_taxonomy_id":17919,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw","term_order":"2144"},{"term_id":17922,"name":"import database","slug":"import-database","term_group":0,"term_taxonomy_id":17922,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw","term_order":"2145"},{"term_id":15460,"name":"database","slug":"database","term_group":0,"term_taxonomy_id":15460,"taxonomy":"post_tag","description":"","parent":0,"count":12,"filter":"raw","term_order":"2569"},{"term_id":657,"name":"phpmyadmin","slug":"phpmyadmin","term_group":0,"term_taxonomy_id":657,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw","term_order":"2776"},{"term_id":659,"name":"import mysql","slug":"import-mysql","term_group":0,"term_taxonomy_id":659,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw","term_order":"2800"}]},"featured_image_src":null,"author_info":{"display_name":"marketing","author_link":"https:\/\/xneelo.co.za\/help-centre\/author\/marketing\/","author_avatar":"https:\/\/secure.gravatar.com\/avatar\/a6ea315e112423b2b955cb020fbce2b0835956c6ad85ff0f13f1db298977eaaa?s=96&d=mm&r=g"},"_links":{"self":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts\/3389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/comments?post=3389"}],"version-history":[{"count":0,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts\/3389\/revisions"}],"wp:attachment":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/media?parent=3389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/categories?post=3389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/tags?post=3389"},{"taxonomy":"topics","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/topics?post=3389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}