{"id":401,"date":"2021-01-24T20:32:30","date_gmt":"2021-01-24T20:32:30","guid":{"rendered":"https:\/\/hostandtech.com\/help\/?p=401"},"modified":"2021-11-05T20:14:00","modified_gmt":"2021-11-05T20:14:00","slug":"how-to-import-export-mysql-database-using-ssh-connection","status":"publish","type":"post","link":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/","title":{"rendered":"How to Import Export MySQL database using SSH connection"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

This article shows how to Import Export Mysql database, Normally if you are dealing with a large databases over than 128MB it is better to control them by SSH.<\/p>

In the same vein to manage the files and databases on your account you can use SSH connection . It is an efficient method to reach your goal. Just run a simple command\u00a0 to import or export a MYSQL<\/a> database into an existing database on your account.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Using SSH To Import Your MySQL Database<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\n\t\t\t\t\t\tNote<\/span>\n\t\t\t\n\t\t\t\t\t\tThe file must be in .sql format. You can not compress the file in a .zip or .tar.gz file.<\/span>\n\t\t\t\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
  • First Upload the SQL file to the server via the file manager or an FTP client.<\/li>

  • If the database does not exist, please create a database, a user, and give the user full privileges to the database. Note the username and password.<\/strong><\/p><\/li>

  • After that log in to the server through SSH.<\/p><\/li>

  • Navigate to the directory where your .sql file is.<\/p><\/li>

  • After that run the below command:<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\n\t\t\t\t\tmysql -p -u user_name database_name < file.sql (replace 'user_name', 'database_name', and 'file.sql' with the actual name.)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-63769e2 elementor-widget elementor-widget-text-editor\" data-id=\"63769e2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li><p>You will be prompted for your database user password, and then your database will be imported.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c06f14e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c06f14e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8efdcea\" data-id=\"8efdcea\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6d92e44 elementor-widget elementor-widget-heading\" data-id=\"6d92e44\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Using SSH To Export Your MySQL Database<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1391d8c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1391d8c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1637ddb\" data-id=\"1637ddb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-34f7846 elementor-widget elementor-widget-text-editor\" data-id=\"34f7846\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Use the mysqldump command to export a MySQL database.It is a good idea to export your data often as a backup.<\/p><ul><li>First login to server via SSH and execute the below command:<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a5e8dc1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a5e8dc1\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a8dde4f\" data-id=\"a8dde4f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fa1319e elementor-widget elementor-widget-code-highlight\" data-id=\"fa1319e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>mysqldump -p -u username database_name > dbname.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d782d5 elementor-widget elementor-widget-text-editor\" data-id=\"6d782d5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li>Secondly you will be prompted for a password, type in the username password, and press Enter. Replace username, password, and database_name with your MySQL username, password, and database name.<\/li><li><p>The file dbname.sql now holds a backup of your database and is ready for download to your computer. In conclusion to export a single table from your database, you would use the following command:<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-350144a elementor-widget elementor-widget-code-highlight\" data-id=\"350144a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>mysqldump -p --user=username database_name tableName > tableName.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-58f8b27 elementor-widget elementor-widget-text-editor\" data-id=\"58f8b27\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul><li>Again you would need to replace the username, database, and tableName with the correct information. Once done, the table specified would then be saved to your account as\u00a0<strong>tableName.sql.<\/strong><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-015fa6c elementor-widget elementor-widget-elementor-faq-schema\" data-id=\"015fa6c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"elementor-faq-schema.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t                                    <script type=\"application\/ld+json\">\n                    {\n                        \"@context\": \"https:\/\/schema.org\",\n                        \"@type\": \"FAQPage\",\n                        \"mainEntity\": [\n                         {\n                            \"@type\": \"Question\",\n                            \"name\": \"How Do I Import My Mysql Database using SHH?\",\n                            \"acceptedAnswer\": {\n                                \"@type\": \"Answer\",\n                                \"text\": \"&lt;ul&gt;&lt;li&gt;First Upload the SQL file to the server via the file manager or an FTP client.&lt;\/li&gt;&lt;li&gt;&lt;p&gt;If the database does not exist, please create a database, a user, and give the user full privileges to the database. &lt;strong&gt;Note the username and password.&lt;\/strong&gt;&lt;\/p&gt;&lt;\/li&gt;&lt;li&gt;&lt;p&gt;Log in to the server through SSH.&lt;\/p&gt;&lt;\/li&gt;&lt;li&gt;&lt;p&gt;Navigate to the directory where your .sql file is.&lt;\/p&gt;&lt;\/li&gt;&lt;li&gt;&lt;p&gt;After that run the below command: mysql -p -u user_name database_name &lt; file.sql (replace &#039;user_name&#039;, &#039;database_name&#039;, and &#039;file.sql&#039; with the actual name.)&lt;\/p&gt;&lt;\/li&gt;&lt;li&gt;You will be prompted for your database user password, and then your database will be imported.&lt;\/li&gt;&lt;\/ul&gt;\"\n                            }\n                                                    },\n                                             {\n                            \"@type\": \"Question\",\n                            \"name\": \"How Do I Export My Mysql Database using SHH?\",\n                            \"acceptedAnswer\": {\n                                \"@type\": \"Answer\",\n                                \"text\": \"&lt;ul&gt;&lt;li&gt;First login to server via SSH and execute the below command: &lt;code class=&quot; language-bash&quot; style=&quot;white-space: pre-wrap;&quot;&gt;mysqldump -p -u username database_name &gt; dbname.sql&lt;\/code&gt;&lt;\/li&gt;&lt;li&gt;You will be prompted for a password, type in the username password, and press Enter. Replace username, password, and database_name with your MySQL username, password, and database name.&lt;\/li&gt;&lt;li&gt;&lt;p&gt;The file dbname.sql now holds a backup of your database\u00a0and is ready for download to your computer.&lt;\/p&gt;&lt;\/li&gt;&lt;\/ul&gt;\"\n                            }\n                                                    },\n                                             {\n                            \"@type\": \"Question\",\n                            \"name\": \"How Do I Export A Single Table From My Database?\",\n                            \"acceptedAnswer\": {\n                                \"@type\": \"Answer\",\n                                \"text\": \"&lt;ul&gt;&lt;li&gt;use the following command: mysqldump -p --user=username database_name tableName &gt; tableName.sql&lt;\/li&gt;&lt;li&gt;Again you would need to replace the username, database, and tableName with the correct information. Once done, the table specified would then be saved to your account as\u00a0&lt;strong&gt;tableName.sql.&lt;\/strong&gt;&lt;\/li&gt;&lt;\/ul&gt;\"\n                            }\n                                                    }\n                    ]\n                    }\n                <\/script>\n                    \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>This article shows how to Import Export Mysql database, Normally if you are dealing with a large databases over than 128MB it is better to control them by SSH. In the same vein to manage the files and databases on your account you can use SSH connection . It is an efficient method to reach [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":1788,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[250,253],"tags":[122,3],"class_list":["post-401","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","category-mysql","tag-linux","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Import Export Database Via SSH Connection Using mysqldump command<\/title>\n<meta name=\"description\" content=\"How to Import and Export MySQL database by SSH connection using mysqldump Linux command and export a single table from your MySQL database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import Export Database Via SSH Connection Using mysqldump command\" \/>\n<meta property=\"og:description\" content=\"How to Import and Export MySQL database by SSH connection using mysqldump Linux command and export a single table from your MySQL database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/\" \/>\n<meta property=\"og:site_name\" content=\"STS Host and Tech Knowledge base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/stshostandtech\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-24T20:32:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-05T20:14:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png\" \/>\n\t<meta property=\"og:image:width\" content=\"671\" \/>\n\t<meta property=\"og:image:height\" content=\"269\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Host&amp;Tech Support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Import Export Database Via SSH Connection Using mysqldump command\" \/>\n<meta name=\"twitter:description\" content=\"How to Import and Export MySQL database by SSH connection using mysqldump Linux command and export a single table from your MySQL database\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png\" \/>\n<meta name=\"twitter:creator\" content=\"@stshostandtech\" \/>\n<meta name=\"twitter:site\" content=\"@stshostandtech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Host&amp;Tech Support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/\"},\"author\":{\"name\":\"Host&amp;Tech Support\",\"@id\":\"https:\/\/hostandtech.com\/help\/#\/schema\/person\/e047ccece500c5187cf74bddd8596e83\"},\"headline\":\"How to Import Export MySQL database using SSH connection\",\"datePublished\":\"2021-01-24T20:32:30+00:00\",\"dateModified\":\"2021-11-05T20:14:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/\"},\"wordCount\":331,\"publisher\":{\"@id\":\"https:\/\/hostandtech.com\/help\/#organization\"},\"image\":{\"@id\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png\",\"keywords\":[\"Linux\",\"MysQL\"],\"articleSection\":[\"Linux\",\"MySQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/\",\"url\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/\",\"name\":\"Import Export Database Via SSH Connection Using mysqldump command\",\"isPartOf\":{\"@id\":\"https:\/\/hostandtech.com\/help\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png\",\"datePublished\":\"2021-01-24T20:32:30+00:00\",\"dateModified\":\"2021-11-05T20:14:00+00:00\",\"description\":\"How to Import and Export MySQL database by SSH connection using mysqldump Linux command and export a single table from your MySQL database\",\"breadcrumb\":{\"@id\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#primaryimage\",\"url\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png\",\"contentUrl\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png\",\"width\":671,\"height\":269,\"caption\":\"Import Export Database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/hostandtech.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Import Export MySQL database using SSH connection\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hostandtech.com\/help\/#website\",\"url\":\"https:\/\/hostandtech.com\/help\/\",\"name\":\"STS Host and Tech Knowledge base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hostandtech.com\/help\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hostandtech.com\/help\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hostandtech.com\/help\/#organization\",\"name\":\"STS Host and Tech Inc\",\"url\":\"https:\/\/hostandtech.com\/help\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hostandtech.com\/help\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/02\/hostandtechlogo-1.png\",\"contentUrl\":\"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/02\/hostandtechlogo-1.png\",\"width\":630,\"height\":270,\"caption\":\"STS Host and Tech Inc\"},\"image\":{\"@id\":\"https:\/\/hostandtech.com\/help\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/stshostandtech\",\"https:\/\/x.com\/stshostandtech\",\"https:\/\/www.instagram.com\/stshostandtech\",\"https:\/\/www.youtube.com\/channel\/UCqJOPwWE0ILTeIScaND7enw\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hostandtech.com\/help\/#\/schema\/person\/e047ccece500c5187cf74bddd8596e83\",\"name\":\"Host&amp;Tech Support\",\"sameAs\":[\"https:\/\/hostandtech.com\/help\"],\"url\":\"https:\/\/hostandtech.com\/help\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import Export Database Via SSH Connection Using mysqldump command","description":"How to Import and Export MySQL database by SSH connection using mysqldump Linux command and export a single table from your MySQL database","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/","og_locale":"en_US","og_type":"article","og_title":"Import Export Database Via SSH Connection Using mysqldump command","og_description":"How to Import and Export MySQL database by SSH connection using mysqldump Linux command and export a single table from your MySQL database","og_url":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/","og_site_name":"STS Host and Tech Knowledge base","article_publisher":"https:\/\/www.facebook.com\/stshostandtech","article_published_time":"2021-01-24T20:32:30+00:00","article_modified_time":"2021-11-05T20:14:00+00:00","og_image":[{"width":671,"height":269,"url":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png","type":"image\/png"}],"author":"Host&amp;Tech Support","twitter_card":"summary_large_image","twitter_title":"Import Export Database Via SSH Connection Using mysqldump command","twitter_description":"How to Import and Export MySQL database by SSH connection using mysqldump Linux command and export a single table from your MySQL database","twitter_image":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png","twitter_creator":"@stshostandtech","twitter_site":"@stshostandtech","twitter_misc":{"Written by":"Host&amp;Tech Support","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#article","isPartOf":{"@id":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/"},"author":{"name":"Host&amp;Tech Support","@id":"https:\/\/hostandtech.com\/help\/#\/schema\/person\/e047ccece500c5187cf74bddd8596e83"},"headline":"How to Import Export MySQL database using SSH connection","datePublished":"2021-01-24T20:32:30+00:00","dateModified":"2021-11-05T20:14:00+00:00","mainEntityOfPage":{"@id":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/"},"wordCount":331,"publisher":{"@id":"https:\/\/hostandtech.com\/help\/#organization"},"image":{"@id":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#primaryimage"},"thumbnailUrl":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png","keywords":["Linux","MysQL"],"articleSection":["Linux","MySQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/","url":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/","name":"Import Export Database Via SSH Connection Using mysqldump command","isPartOf":{"@id":"https:\/\/hostandtech.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#primaryimage"},"image":{"@id":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#primaryimage"},"thumbnailUrl":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png","datePublished":"2021-01-24T20:32:30+00:00","dateModified":"2021-11-05T20:14:00+00:00","description":"How to Import and Export MySQL database by SSH connection using mysqldump Linux command and export a single table from your MySQL database","breadcrumb":{"@id":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#primaryimage","url":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png","contentUrl":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2021\/01\/import-export-database.png","width":671,"height":269,"caption":"Import Export Database"},{"@type":"BreadcrumbList","@id":"https:\/\/hostandtech.com\/help\/linux\/how-to-import-export-mysql-database-using-ssh-connection\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/hostandtech.com\/help\/"},{"@type":"ListItem","position":2,"name":"How to Import Export MySQL database using SSH connection"}]},{"@type":"WebSite","@id":"https:\/\/hostandtech.com\/help\/#website","url":"https:\/\/hostandtech.com\/help\/","name":"STS Host and Tech Knowledge base","description":"","publisher":{"@id":"https:\/\/hostandtech.com\/help\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hostandtech.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/hostandtech.com\/help\/#organization","name":"STS Host and Tech Inc","url":"https:\/\/hostandtech.com\/help\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hostandtech.com\/help\/#\/schema\/logo\/image\/","url":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/02\/hostandtechlogo-1.png","contentUrl":"https:\/\/hostandtech.com\/help\/wp-content\/uploads\/2022\/02\/hostandtechlogo-1.png","width":630,"height":270,"caption":"STS Host and Tech Inc"},"image":{"@id":"https:\/\/hostandtech.com\/help\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/stshostandtech","https:\/\/x.com\/stshostandtech","https:\/\/www.instagram.com\/stshostandtech","https:\/\/www.youtube.com\/channel\/UCqJOPwWE0ILTeIScaND7enw"]},{"@type":"Person","@id":"https:\/\/hostandtech.com\/help\/#\/schema\/person\/e047ccece500c5187cf74bddd8596e83","name":"Host&amp;Tech Support","sameAs":["https:\/\/hostandtech.com\/help"],"url":"https:\/\/hostandtech.com\/help\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/posts\/401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/comments?post=401"}],"version-history":[{"count":260,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/posts\/401\/revisions"}],"predecessor-version":[{"id":12035,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/posts\/401\/revisions\/12035"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/media\/1788"}],"wp:attachment":[{"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/media?parent=401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/categories?post=401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostandtech.com\/help\/wp-json\/wp\/v2\/tags?post=401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}