{"id":932,"date":"2012-11-22T12:11:12","date_gmt":"2012-11-22T12:11:12","guid":{"rendered":"http:\/\/pariswells.com\/blog\/?p=932"},"modified":"2012-11-22T12:11:12","modified_gmt":"2012-11-22T12:11:12","slug":"how-to-export-mysql-database-via-windows-mysql-command-line-client","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/random\/how-to-export-mysql-database-via-windows-mysql-command-line-client","title":{"rendered":"How to Export MySQL Database via Windows MySQL Command Line Client"},"content":{"rendered":"\r\n<p><a href=\"http:\/\/pariswells.com\/blog\/wp-content\/uploads\/2012\/11\/mysql-big21.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-medium wp-image-933 img-responsive\" title=\"mysql-big2[1]\" src=\"http:\/\/pariswells.com\/blog\/wp-content\/uploads\/2012\/11\/mysql-big21-300x199.gif\" alt=\"\" width=\"300\" height=\"199\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2012\/11\/mysql-big21-300x199.gif 300w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2012\/11\/mysql-big21.gif 425w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>Navigate to the following directory in Command Prompt<\/p>\r\n<p><strong>C:\\Program Files\\MySQL\\MySQL Server 5.0\\bin<\/strong><\/p>\r\n<p>Run the following command replacing the bold with your details<\/p>\r\n<p>mysqldump &#8211;host=<strong>localhost<\/strong> &#8211;user=<strong>username<\/strong> \u00a0&#8211;password=<strong>password<\/strong> <strong>database_name<\/strong> \u00a0-r &#8220;C:\\<strong>filename<\/strong>.sql&#8221;<\/p>\r\n<p>&nbsp;<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Navigate to the following directory in Command Prompt C:\\Program Files\\MySQL\\MySQL Server 5.0\\bin Run the following command replacing the bold with your details mysqldump &#8211;host=localhost &#8211;user=username \u00a0&#8211;password=password database_name [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[526],"class_list":["post-932","post","type-post","status-publish","format-standard","hentry","category-random","tag-export-mysql-windows"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=932"}],"version-history":[{"count":1,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/932\/revisions"}],"predecessor-version":[{"id":934,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/932\/revisions\/934"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}