{"id":29547,"date":"2022-04-13T06:32:34","date_gmt":"2022-04-13T06:32:34","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=29547"},"modified":"2022-12-23T06:19:40","modified_gmt":"2022-12-23T06:19:40","slug":"mysql-backup-and-restore-a-complete-guide","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/mysql-backup-and-restore-a-complete-guide\/","title":{"rendered":"MySql Backup and Restore &#8211; A Complete Guide"},"content":{"rendered":"\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-devopsschool-com wp-block-embed-devopsschool-com\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"ZvP8H8QNan\"><a href=\"https:\/\/www.devopsschool.com\/blog\/import-all-mysql-databases-at-one-time-in-seperate-file-for-backup\/\">Import all MySQL databases at one time in seperate file for Backup<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Import all MySQL databases at one time in seperate file for Backup&#8221; &#8212; DevOpsSchool.com\" src=\"https:\/\/www.devopsschool.com\/blog\/import-all-mysql-databases-at-one-time-in-seperate-file-for-backup\/embed\/#?secret=V4j2GnHLyY#?secret=ZvP8H8QNan\" data-secret=\"ZvP8H8QNan\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h1 class=\"wp-block-heading\">Generate the backup of a single database<\/h1>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">mysqldump<\/span> <span class=\"hljs-selector-tag\">-u<\/span> <span class=\"hljs-selector-tag\">root<\/span> <span class=\"hljs-selector-tag\">-p<\/span> <span class=\"hljs-selector-tag\">sakila<\/span> &gt; <span class=\"hljs-selector-tag\">C<\/span>:\\<span class=\"hljs-selector-tag\">MySQLBackup<\/span>\\<span class=\"hljs-selector-tag\">sakila_20200424<\/span><span class=\"hljs-selector-class\">.sql<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h1 class=\"wp-block-heading\">Generate the backup of multiple databases or all the databases<\/h1>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">mysqldump<\/span> <span class=\"hljs-selector-tag\">-u<\/span> <span class=\"hljs-selector-tag\">root<\/span> <span class=\"hljs-selector-tag\">-p<\/span> <span class=\"hljs-selector-tag\">--databases<\/span> <span class=\"hljs-selector-tag\">sakila<\/span> <span class=\"hljs-selector-tag\">employees<\/span> &gt; <span class=\"hljs-selector-tag\">C<\/span>:\\<span class=\"hljs-selector-tag\">MySQLBackup<\/span>\\<span class=\"hljs-selector-tag\">sakila_employees_20200424<\/span><span class=\"hljs-selector-class\">.sql<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h1 class=\"wp-block-heading\">Generate the backup of database structure<\/h1>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">mysqldump<\/span> <span class=\"hljs-selector-tag\">-u<\/span> <span class=\"hljs-selector-tag\">root<\/span> <span class=\"hljs-selector-tag\">-p<\/span> <span class=\"hljs-selector-tag\">--no-data<\/span> <span class=\"hljs-selector-tag\">sakila<\/span> &gt; <span class=\"hljs-selector-tag\">C<\/span>:\\<span class=\"hljs-selector-tag\">MySQLBackup<\/span>\\<span class=\"hljs-selector-tag\">sakila_objects_definition_20200424<\/span><span class=\"hljs-selector-class\">.sql<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h1 class=\"wp-block-heading\">Generate the backup of a specific table<\/h1>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\"><span class=\"hljs-selector-tag\">mysqldump<\/span> <span class=\"hljs-selector-tag\">-u<\/span> <span class=\"hljs-selector-tag\">root<\/span> <span class=\"hljs-selector-tag\">-p<\/span> <span class=\"hljs-selector-tag\">sakila<\/span> <span class=\"hljs-selector-tag\">actor<\/span> <span class=\"hljs-selector-tag\">payment<\/span> &gt; <span class=\"hljs-selector-tag\">C<\/span>:\\<span class=\"hljs-selector-tag\">MySQLBackup<\/span>\\<span class=\"hljs-selector-tag\">actor_payment_table_20200424<\/span><span class=\"hljs-selector-class\">.sql<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>","protected":false},"excerpt":{"rendered":"<p>Generate the backup of a single database Generate the backup of multiple databases or all the databases Generate the backup of database structure Generate the backup of a specific table<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-29547","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/29547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=29547"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/29547\/revisions"}],"predecessor-version":[{"id":29548,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/29547\/revisions\/29548"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=29547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=29547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=29547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}