{"id":3387,"date":"2014-08-05T14:50:00","date_gmt":"2014-08-05T12:50:00","guid":{"rendered":"http:\/\/localhost\/helpcentre\/?p=3387"},"modified":"2026-01-30T10:41:10","modified_gmt":"2026-01-30T08:41:10","slug":"export-phpmyadmin","status":"publish","type":"post","link":"https:\/\/xneelo.co.za\/help-centre\/website\/managing-website\/export-phpmyadmin\/","title":{"rendered":"How to export a database via phpMyAdmin via konsoleH"},"content":{"rendered":"<p>You may export a database via the <a href=\"https:\/\/xneelo.co.za\/help-centre\/website\/managing-website\/mysql\/how-do-i-create-and-manage-a-mysql-database-2\/\"><strong>phpMyAdmin<\/strong><\/a> tool within <strong>konsoleH<\/strong> by following the below steps:<\/p>\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. 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-36017\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/Screenshot-2022-07-20-at-13.37.09.png\" alt=\"\" width=\"1316\" height=\"228\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/Screenshot-2022-07-20-at-13.37.09.png 1316w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/Screenshot-2022-07-20-at-13.37.09-300x52.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/Screenshot-2022-07-20-at-13.37.09-1024x177.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/Screenshot-2022-07-20-at-13.37.09-768x133.png 768w\" sizes=\"auto, (max-width: 1316px) 100vw, 1316px\" \/><\/p>\n<p>7. Select the<strong> database name<\/strong> to expand the tables, then select <strong>Export<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15137\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export.png\" alt=\"phpmyadmin-export\" width=\"2470\" height=\"294\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export.png 2470w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-300x36.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-1024x122.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-768x91.png 768w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-1536x183.png 1536w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-2048x244.png 2048w\" sizes=\"auto, (max-width: 2470px) 100vw, 2470px\" \/><\/p>\n<p>8. Select <strong>Quick \u2013\u00a0display only the minimal options<\/strong><\/p>\n<p>9. Select the required <strong>Format<\/strong>. In most cases <strong>SQL<\/strong>\u00a0will be sufficient.<\/p>\n<p>10. Select <strong>Go<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15139\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-2.png\" alt=\"phpmyadmin-export-2\" width=\"1554\" height=\"749\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-2.png 1554w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-2-300x145.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-2-1024x494.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-2-768x370.png 768w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-2-1536x740.png 1536w\" sizes=\"auto, (max-width: 1554px) 100vw, 1554px\" \/><\/p>\n<p>Your web browser will prompt you to download the database dump file to your computer.<\/p>\n<p>If the database dump file fails to generate, the likely reason is that the database is too large in size. In these cases, you may export the database <a href=\"https:\/\/xneelo.co.za\/help-centre\/website\/export-database-via-ssh\/\">via command-line<\/a> using SSH.<\/p>\n","protected":false,"plain":"You may export a database via the <a href=\"https:\/\/xneelo.co.za\/help-centre\/website\/managing-website\/mysql\/how-do-i-create-and-manage-a-mysql-database-2\/\"><strong>phpMyAdmin<\/strong><\/a> tool within <strong>konsoleH<\/strong> by following the below steps:\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. 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-36017\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/Screenshot-2022-07-20-at-13.37.09.png\" alt=\"\" width=\"1316\" height=\"228\" \/>\r\n\r\n7. Select the<strong> database name<\/strong> to expand the tables, then select <strong>Export<\/strong>\r\n\r\n<img class=\"alignnone size-full wp-image-15137\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export.png\" alt=\"phpmyadmin-export\" width=\"2470\" height=\"294\" \/>\r\n\r\n8. Select <strong>Quick \u2013\u00a0display only the minimal options<\/strong>\r\n\r\n9. Select the required <strong>Format<\/strong>. In most cases <strong>SQL<\/strong>\u00a0will be sufficient.\r\n\r\n10. Select <strong>Go<\/strong>\r\n\r\n<img class=\"alignnone size-full wp-image-15139\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2014\/08\/phpmyadmin-export-2.png\" alt=\"phpmyadmin-export-2\" width=\"1554\" height=\"749\" \/>\r\n\r\nYour web browser will prompt you to download the database dump file to your computer.\r\n\r\nIf the database dump file fails to generate, the likely reason is that the database is too large in size. In these cases, you may export the database <a href=\"https:\/\/xneelo.co.za\/help-centre\/website\/export-database-via-ssh\/\">via command-line<\/a> using SSH."},"excerpt":{"rendered":"<p>Using our step-by-step visual guide you can export a database via the phpMyAdmin tool within konsoleH. We show you how.<\/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":[17931,17522,657],"topics":[10403],"class_list":["post-3387","post","type-post","status-publish","format-standard","hentry","category-managing-website","tag-export-a-database-via-phpmyadmin","tag-export-a-mysql-database","tag-phpmyadmin","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":17931,"name":"export a database via phpMyAdmin","slug":"export-a-database-via-phpmyadmin","term_group":0,"term_taxonomy_id":17931,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw","term_order":"2141"},{"term_id":17522,"name":"export a MySQL database","slug":"export-a-mysql-database","term_group":0,"term_taxonomy_id":17522,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw","term_order":"2278"},{"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"}]},"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\/3387","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=3387"}],"version-history":[{"count":0,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts\/3387\/revisions"}],"wp:attachment":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/media?parent=3387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/categories?post=3387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/tags?post=3387"},{"taxonomy":"topics","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/topics?post=3387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}