{"id":3391,"date":"2014-08-05T15:42:00","date_gmt":"2014-08-05T13:42:00","guid":{"rendered":"http:\/\/localhost\/helpcentre\/?p=3391"},"modified":"2025-12-29T15:28:56","modified_gmt":"2025-12-29T13:28:56","slug":"export-database-via-ssh","status":"publish","type":"post","link":"https:\/\/xneelo.co.za\/help-centre\/website\/export-database-via-ssh\/","title":{"rendered":"How to export a database via SSH"},"content":{"rendered":"

You may export a database via command-line using SSH<\/strong> by following the below steps:<\/p>\n

    \n
  1. SSH<\/strong><\/a> to your domain.<\/li>\n
  2. Run the following export command. Replace the brackets and the information within them with your database information. Your database information<\/a> can be found within Manage MySQL<\/strong> in the control panel.<\/li>\n<\/ol>\n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    mysqldump --add-drop-table -Q -u[MySQL Login] -h[MySQL Server] [MySQL database] \r\n-p > dumpfile.sql<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false,"plain":"You may export a database via command-line using SSH<\/strong> by following the below steps:\r\n
      \r\n \t
    1. SSH<\/strong><\/a> to your domain.<\/li>\r\n \t
    2. Run the following export command. Replace the brackets and the information within them with your database information. Your database information<\/a> can be found within Manage MySQL<\/strong> in the control panel.<\/li>\r\n<\/ol>\r\n
      \r\n
      \r\n
      \r\n
      \r\n
      \r\n
      \r\n
      \r\n
      \r\n
      mysqldump --add-drop-table -Q -u[MySQL Login] -h[MySQL Server] [MySQL database] \r\n-p > dumpfile.sql<\/pre>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>"},"excerpt":{"rendered":"
      Using our easy-to-follow guide, you’ll be able to export a database via command-line, by using SSH. Before exporting, enable SSH for your domain.<\/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":[166],"tags":[21134,18369,18036,18039,15460,383,279],"topics":[10405],"class_list":["post-3391","post","type-post","status-publish","format-standard","hentry","category-website","tag-ssh-domain","tag-how-to-export-a-database-via-ssh","tag-export-via-ssh","tag-export","tag-database","tag-ssh","tag-ftp","topics-databases"],"acf":[],"additional_meta":{"category_title":[{"term_id":166,"name":"Website","slug":"website","term_group":0,"term_taxonomy_id":166,"taxonomy":"category","description":"About your Website(s)","parent":0,"count":169,"filter":"raw","term_order":"120","cat_ID":166,"category_count":169,"category_description":"About your Website(s)","cat_name":"Website","category_nicename":"website","category_parent":0}],"tag_title":[{"term_id":21134,"name":"ssh domain","slug":"ssh-domain","term_group":0,"term_taxonomy_id":21134,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw","term_order":"1090"},{"term_id":18369,"name":"How to export a database via SSH","slug":"how-to-export-a-database-via-ssh","term_group":0,"term_taxonomy_id":18369,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw","term_order":"1999"},{"term_id":18036,"name":"export via ssh","slug":"export-via-ssh","term_group":0,"term_taxonomy_id":18036,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw","term_order":"2107"},{"term_id":18039,"name":"export","slug":"export","term_group":0,"term_taxonomy_id":18039,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw","term_order":"2108"},{"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":383,"name":"ssh","slug":"ssh","term_group":0,"term_taxonomy_id":383,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw","term_order":"2657"},{"term_id":279,"name":"ftp","slug":"ftp","term_group":0,"term_taxonomy_id":279,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw","term_order":"2995"}]},"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\/3391","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=3391"}],"version-history":[{"count":0,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts\/3391\/revisions"}],"wp:attachment":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/media?parent=3391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/categories?post=3391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/tags?post=3391"},{"taxonomy":"topics","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/topics?post=3391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}