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

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

    \r\n
  1. SSH<\/strong><\/a> to your domain.<\/li>\r\n
  2. Navigate to the directory (folder) where your database dump file has been uploaded to.<\/li>\r\n
  3. Run the following import command. Replace the brackets and the information within them with your database information. Your <\/span>database information<\/span><\/a> can be found within <\/span>Manage MySQL<\/b> in the control panel.<\/span><\/li>\r\n<\/ol>\r\n
    mysql -u[MySQL Login] -h[MySQL Server] [MySQL database] -p < dumpfile.sql<\/div>\r\n\r\n

     <\/p>\r\n","protected":false,"plain":"

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

      \r\n
    1. SSH<\/strong><\/a> to your domain.<\/li>\r\n
    2. Navigate to the directory (folder) where your database dump file has been uploaded to.<\/li>\r\n
    3. Run the following import command. Replace the brackets and the information within them with your database information. Your <\/span>database information<\/span><\/a> can be found within <\/span>Manage MySQL<\/b> in the control panel.<\/span><\/li>\r\n<\/ol>\r\n
      mysql -u[MySQL Login] -h[MySQL Server] [MySQL database] -p < dumpfile.sql<\/div>\r\n\r\n

       <\/p>\r\n"},"excerpt":{"rendered":"

      You can now import your database via command-line using SSH by following the steps provided in our Help Centre guide. <\/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":[180,166],"tags":[18051,17922,383],"topics":[10405],"class_list":["post-3393","post","type-post","status-publish","format-standard","hentry","category-mysql","category-website","tag-how-to-import-a-mysql-database-via-ssh","tag-import-database","tag-ssh","topics-databases"],"acf":[],"additional_meta":{"category_title":[{"term_id":180,"name":"MySQL","slug":"mysql","term_group":0,"term_taxonomy_id":180,"taxonomy":"category","description":"Using MySQL for web applications ","parent":168,"count":9,"filter":"raw","term_order":"92","cat_ID":180,"category_count":9,"category_description":"Using MySQL for web applications ","cat_name":"MySQL","category_nicename":"mysql","category_parent":168},{"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":18051,"name":"How to import a MySQL database via SSH","slug":"how-to-import-a-mysql-database-via-ssh","term_group":0,"term_taxonomy_id":18051,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw","term_order":"2115"},{"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":"2155"},{"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":"2667"}]},"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\/3393","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=3393"}],"version-history":[{"count":0,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts\/3393\/revisions"}],"wp:attachment":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/media?parent=3393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/categories?post=3393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/tags?post=3393"},{"taxonomy":"topics","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/topics?post=3393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}