{"id":5874,"date":"2016-08-10T09:11:12","date_gmt":"2016-08-10T09:11:12","guid":{"rendered":"https:\/\/bodhost.com\/kb\/?p=5874"},"modified":"2026-02-26T14:03:11","modified_gmt":"2026-02-26T14:03:11","slug":"how-to-save-a-database-with-mysqldump-in-wamp","status":"publish","type":"post","link":"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/","title":{"rendered":"How to Save a Database with MySQLDump in WAMP?"},"content":{"rendered":"\r\n<h5 class=\"wp-block-heading\"><strong>Summary<\/strong><\/h5>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Today, we will learn how to save a MySQL database on a Windows environment, after installing a web server WAMP. We will use a native tool that comes with MySQL i.e. MySQLDump.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">In this tutorial, we are going to use WAMP 2.5 and will name the backup as \u201cmydb\u201d.<\/p>\r\n\r\n\r\n\r\n<h5 class=\"wp-block-heading\"><strong>Database Saving<\/strong><\/h5>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">We will have to open a Windows command prompt. Building on the executable \u201cmysqldump\u201d then can quickly back up a database.<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">cd \"C: \\ wamp \\ bin \\ mysql \\ mysql5.6.17 \\ bin \\\"\r\nmysqldump.exe -u root -p mydatabase&gt; C: \\ Backup \\ mabase.sql\r\nEnter password: ****************<\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">We jump by assigning the directory where the executable file located and then mysqldump.exe with the \u2013u option to the user name, \u2013p option to be asked for the password, and following your options as it is necessary to indicate the name of the database. Then the end of the line records the output to a file named \u201cmabase.sql\u201d located in the directory \u201cC:\\Backup\u201d.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">The download has to enter the password every time. Which is not a practical thing to perform the backup through a script. Hence, we will see a better alternative.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">At the root of the \u201cC\u201d drive, create a file \u201cmy.cnf\u201d with the following content tailoring information:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">[Mysqldump]\r\nuser = user\r\npassword = password\r\n<\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Save this file, this also be positioned at the following locations from the documentation of mysqldump:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">- C: \\ WINDOWS \\ my.cnf \r\n- C: \\ wamp \\ mysql \\ my.cnf\r\n<\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">On this file, please limit by security permissions. And specify permissions for the accounting system and the account that is running WAMP on your server.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Finally, the option is removed &#8220;-p&#8221; command, since it will necessary to specify a password, it will refer directly to the my.cnf<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-preformatted\">cd \"C: \\ wamp \\ bin \\ mysql \\ mysql5.6.17 \\ bin \\\"\r\nmysqldump.exe -u root mydatabase&gt; C: \\ Backup \\ mabase.sql\r\n<\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">The backup should run without intervention from you to enter the password!<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">To script all, you can add the date in the name of the file, save it in a script file Batch, and run by a scheduled task.<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Summary Today, we will learn how to save a MySQL database on a Windows environment, after installing a web server WAMP. We will use a native tool that comes with&hellip;<\/p>\n<p><a href=\"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/\" class=\"more-link\">Read More<\/a><\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[836],"tags":[788,786,787],"class_list":["post-5874","post","type-post","status-publish","format-standard","hentry","category-database","tag-how-to-save-database","tag-mysqldump","tag-wamp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Save a Database with MySQLDump in WAMP?<\/title>\n<meta name=\"description\" content=\"Learn how to use MySQLDump in WAMP to easily save a database. Keep your data safe and secure with these simple steps. Perfect for beginners!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Save a Database with MySQLDump in WAMP?\" \/>\n<meta property=\"og:description\" content=\"Learn how to use MySQLDump in WAMP to easily save a database. Keep your data safe and secure with these simple steps. Perfect for beginners!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - bodHOST\" \/>\n<meta property=\"article:published_time\" content=\"2016-08-10T09:11:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-26T14:03:11+00:00\" \/>\n<meta name=\"author\" content=\"Stanley Poter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stanley Poter\" \/>\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:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-save-a-database-with-mysqldump-in-wamp\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-save-a-database-with-mysqldump-in-wamp\\\/\"},\"author\":{\"name\":\"Stanley Poter\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/09d74a6c8cc87831c7722d3c5006a7b2\"},\"headline\":\"How to Save a Database with MySQLDump in WAMP?\",\"datePublished\":\"2016-08-10T09:11:12+00:00\",\"dateModified\":\"2026-02-26T14:03:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-save-a-database-with-mysqldump-in-wamp\\\/\"},\"wordCount\":299,\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"keywords\":[\"How to Save Database\",\"MySQLDump\",\"WAMP\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-save-a-database-with-mysqldump-in-wamp\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-save-a-database-with-mysqldump-in-wamp\\\/\",\"name\":\"How to Save a Database with MySQLDump in WAMP?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\"},\"datePublished\":\"2016-08-10T09:11:12+00:00\",\"dateModified\":\"2026-02-26T14:03:11+00:00\",\"description\":\"Learn how to use MySQLDump in WAMP to easily save a database. Keep your data safe and secure with these simple steps. Perfect for beginners!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-save-a-database-with-mysqldump-in-wamp\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-save-a-database-with-mysqldump-in-wamp\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-save-a-database-with-mysqldump-in-wamp\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Database\",\"item\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/category\\\/database\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Save a Database with MySQLDump in WAMP?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"alternateName\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"contentUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"width\":240,\"height\":240,\"caption\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/09d74a6c8cc87831c7722d3c5006a7b2\",\"name\":\"Stanley Poter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/054b9fa5e2ef6d163cd09392387bc6d5e3b785360d8f7b3625791850670fc434?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/054b9fa5e2ef6d163cd09392387bc6d5e3b785360d8f7b3625791850670fc434?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/054b9fa5e2ef6d163cd09392387bc6d5e3b785360d8f7b3625791850670fc434?s=96&d=mm&r=g\",\"caption\":\"Stanley Poter\"},\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/author\\\/stanleypoter\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Save a Database with MySQLDump in WAMP?","description":"Learn how to use MySQLDump in WAMP to easily save a database. Keep your data safe and secure with these simple steps. Perfect for beginners!","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:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/","og_locale":"en_US","og_type":"article","og_title":"How to Save a Database with MySQLDump in WAMP?","og_description":"Learn how to use MySQLDump in WAMP to easily save a database. Keep your data safe and secure with these simple steps. Perfect for beginners!","og_url":"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/","og_site_name":"Knowledge Base - bodHOST","article_published_time":"2016-08-10T09:11:12+00:00","article_modified_time":"2026-02-26T14:03:11+00:00","author":"Stanley Poter","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stanley Poter","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/#article","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/"},"author":{"name":"Stanley Poter","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/09d74a6c8cc87831c7722d3c5006a7b2"},"headline":"How to Save a Database with MySQLDump in WAMP?","datePublished":"2016-08-10T09:11:12+00:00","dateModified":"2026-02-26T14:03:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/"},"wordCount":299,"publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"keywords":["How to Save Database","MySQLDump","WAMP"],"articleSection":["Database"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/","url":"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/","name":"How to Save a Database with MySQLDump in WAMP?","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/#website"},"datePublished":"2016-08-10T09:11:12+00:00","dateModified":"2026-02-26T14:03:11+00:00","description":"Learn how to use MySQLDump in WAMP to easily save a database. Keep your data safe and secure with these simple steps. Perfect for beginners!","breadcrumb":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.bodhost.com\/kb\/how-to-save-a-database-with-mysqldump-in-wamp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Database","item":"https:\/\/www.bodhost.com\/kb\/category\/database\/"},{"@type":"ListItem","position":2,"name":"How to Save a Database with MySQLDump in WAMP?"}]},{"@type":"WebSite","@id":"https:\/\/www.bodhost.com\/kb\/#website","url":"https:\/\/www.bodhost.com\/kb\/","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","description":"","publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"alternateName":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bodhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bodhost.com\/kb\/#organization","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","url":"https:\/\/www.bodhost.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","contentUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","width":240,"height":240,"caption":"Web Hosting Knowledge Base | bodHOST Hosting FAQ"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/09d74a6c8cc87831c7722d3c5006a7b2","name":"Stanley Poter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/054b9fa5e2ef6d163cd09392387bc6d5e3b785360d8f7b3625791850670fc434?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/054b9fa5e2ef6d163cd09392387bc6d5e3b785360d8f7b3625791850670fc434?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/054b9fa5e2ef6d163cd09392387bc6d5e3b785360d8f7b3625791850670fc434?s=96&d=mm&r=g","caption":"Stanley Poter"},"url":"https:\/\/www.bodhost.com\/kb\/author\/stanleypoter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/5874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/comments?post=5874"}],"version-history":[{"count":10,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/5874\/revisions"}],"predecessor-version":[{"id":12053,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/5874\/revisions\/12053"}],"wp:attachment":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/media?parent=5874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/categories?post=5874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/tags?post=5874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}