{"id":4735,"date":"2023-02-10T17:07:02","date_gmt":"2023-02-10T11:37:02","guid":{"rendered":"https:\/\/trysiteprice.com\/blog\/?p=4735"},"modified":"2023-02-10T17:07:02","modified_gmt":"2023-02-10T11:37:02","slug":"mysqldump-copy-database-using-shell-pipes-and-ssh","status":"publish","type":"post","link":"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/","title":{"rendered":"mysqldump \u2013 Copy Database Using Shell Pipes and SSH"},"content":{"rendered":"<p>The <code>mysqldump<\/code> command is a useful tool for backing up a MySQL database. One way to use <code>mysqldump<\/code> to copy a database from one server to another is by using shell pipes and SSH.<\/p>\n<p>Here&#8217;s an example of how you can use <code>mysqldump<\/code> to copy a database named &#8220;mydatabase&#8221; from a remote server to your local machine:<\/p>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-sql\">ssh <span class=\"hljs-keyword\">user<\/span><span class=\"hljs-variable\">@remote<\/span><span class=\"hljs-operator\">-<\/span>server \"mysqldump mydatabase\" <span class=\"hljs-operator\">|<\/span> mysql <span class=\"hljs-operator\">-<\/span>u localuser <span class=\"hljs-operator\">-<\/span>p mydatabase<br \/>\n<\/code><\/div>\n<\/div>\n<p>In this example, the <code>mysqldump<\/code> command is run on the remote server, and its output is redirected to the local machine through an SSH pipe. The output is then passed to the <code>mysql<\/code> command, which imports the data into the local database named &#8220;mydatabase&#8221;. The <code>-u<\/code> option is used to specify the MySQL user, and the <code>-p<\/code> option is used to prompt for a password.<\/p>\n<p>This method can be useful when you want to copy a database from one server to another without having to transfer large data files. The only data that is transferred over the network is the output of the <code>mysqldump<\/code> command, which can be significantly smaller than a raw data file.<\/p>\n<p>Note that this method requires that you have SSH access to the remote server and that the remote server has access to the MySQL database. Also, be sure to use the correct username and password for both the remote server and the MySQL database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The mysqldump command is a useful tool for backing up a MySQL database. One way to use mysqldump to copy a database from one server to another is by using shell pipes and SSH. Here&#8217;s an example of how you can use mysqldump to copy a database named &#8220;mydatabase&#8221; from a remote server to your &#8230; <a title=\"mysqldump \u2013 Copy Database Using Shell Pipes and SSH\" class=\"read-more\" href=\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/\" aria-label=\"Read more about mysqldump \u2013 Copy Database Using Shell Pipes and SSH\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4735","post","type-post","status-publish","format-standard","hentry","category-best-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>mysqldump \u2013 Copy Database Using Shell Pipes and SSH - TrySitePrice<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"mysqldump \u2013 Copy Database Using Shell Pipes and SSH - TrySitePrice\" \/>\n<meta property=\"og:description\" content=\"The mysqldump command is a useful tool for backing up a MySQL database. One way to use mysqldump to copy a database from one server to another is by using shell pipes and SSH. Here&#8217;s an example of how you can use mysqldump to copy a database named &#8220;mydatabase&#8221; from a remote server to your ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/\" \/>\n<meta property=\"og:site_name\" content=\"TrySitePrice\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-10T11:37:02+00:00\" \/>\n<meta name=\"author\" content=\"Rahul Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/\"},\"author\":{\"name\":\"Rahul Sahu\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\"},\"headline\":\"mysqldump \u2013 Copy Database Using Shell Pipes and SSH\",\"datePublished\":\"2023-02-10T11:37:02+00:00\",\"dateModified\":\"2023-02-10T11:37:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/\"},\"wordCount\":216,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"articleSection\":[\"Best\/Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/\",\"name\":\"mysqldump \u2013 Copy Database Using Shell Pipes and SSH - TrySitePrice\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\"},\"datePublished\":\"2023-02-10T11:37:02+00:00\",\"dateModified\":\"2023-02-10T11:37:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/trysiteprice.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"mysqldump \u2013 Copy Database Using Shell Pipes and SSH\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"name\":\"TrySitePrice\",\"description\":\"Free Website Value Calculator Tool\",\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\",\"name\":\"TrySitePrice\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"contentUrl\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"width\":395,\"height\":268,\"caption\":\"TrySitePrice\"},\"image\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\",\"name\":\"Rahul Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"caption\":\"Rahul Sahu\"},\"sameAs\":[\"https:\/\/trysiteprice.com\/blog\"],\"url\":\"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"mysqldump \u2013 Copy Database Using Shell Pipes and SSH - TrySitePrice","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:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/","og_locale":"en_US","og_type":"article","og_title":"mysqldump \u2013 Copy Database Using Shell Pipes and SSH - TrySitePrice","og_description":"The mysqldump command is a useful tool for backing up a MySQL database. One way to use mysqldump to copy a database from one server to another is by using shell pipes and SSH. Here&#8217;s an example of how you can use mysqldump to copy a database named &#8220;mydatabase&#8221; from a remote server to your ... Read more","og_url":"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/","og_site_name":"TrySitePrice","article_published_time":"2023-02-10T11:37:02+00:00","author":"Rahul Sahu","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/#article","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/"},"author":{"name":"Rahul Sahu","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4"},"headline":"mysqldump \u2013 Copy Database Using Shell Pipes and SSH","datePublished":"2023-02-10T11:37:02+00:00","dateModified":"2023-02-10T11:37:02+00:00","mainEntityOfPage":{"@id":"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/"},"wordCount":216,"commentCount":0,"publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"articleSection":["Best\/Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/","url":"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/","name":"mysqldump \u2013 Copy Database Using Shell Pipes and SSH - TrySitePrice","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/#website"},"datePublished":"2023-02-10T11:37:02+00:00","dateModified":"2023-02-10T11:37:02+00:00","breadcrumb":{"@id":"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/trysiteprice.com\/blog\/mysqldump-copy-database-using-shell-pipes-and-ssh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trysiteprice.com\/blog\/"},{"@type":"ListItem","position":2,"name":"mysqldump \u2013 Copy Database Using Shell Pipes and SSH"}]},{"@type":"WebSite","@id":"https:\/\/trysiteprice.com\/blog\/#website","url":"https:\/\/trysiteprice.com\/blog\/","name":"TrySitePrice","description":"Free Website Value Calculator Tool","publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/trysiteprice.com\/blog\/#organization","name":"TrySitePrice","url":"https:\/\/trysiteprice.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","contentUrl":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","width":395,"height":268,"caption":"TrySitePrice"},"image":{"@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4","name":"Rahul Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","caption":"Rahul Sahu"},"sameAs":["https:\/\/trysiteprice.com\/blog"],"url":"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/"}]}},"_links":{"self":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/4735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/comments?post=4735"}],"version-history":[{"count":1,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/4735\/revisions"}],"predecessor-version":[{"id":4739,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/4735\/revisions\/4739"}],"wp:attachment":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/media?parent=4735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/categories?post=4735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/tags?post=4735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}