{"id":29532,"date":"2022-04-13T04:10:49","date_gmt":"2022-04-13T04:10:49","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=29532"},"modified":"2022-12-23T06:19:41","modified_gmt":"2022-12-23T06:19:41","slug":"import-all-mysql-databases-at-one-time-in-seperate-file-for-backup","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/import-all-mysql-databases-at-one-time-in-seperate-file-for-backup\/","title":{"rendered":"Import all MySQL databases at one time in seperate file for Backup"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Script<\/h2>\n\n\n\n<script src=\"https:\/\/gist.github.com\/devops-school\/896d5280078c62c08c48b29ad0f3ff6e.js\"><\/script>\n\n\n\n<h2 class=\"wp-block-heading\">Commands<\/h2>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">$ mysqldump -u root -p --all-databases &gt; alldb.sql\r\n\nLook up the documentation <span class=\"hljs-keyword\">for<\/span> mysqldump. You may want to <span class=\"hljs-keyword\">use<\/span> <span class=\"hljs-title\">some<\/span> <span class=\"hljs-title\">of<\/span> <span class=\"hljs-title\">the<\/span> <span class=\"hljs-title\">options<\/span> <span class=\"hljs-title\">mentioned<\/span> <span class=\"hljs-title\">in<\/span> <span class=\"hljs-title\">comments<\/span>:\r\n\r\n$ <span class=\"hljs-title\">mysqldump<\/span> -<span class=\"hljs-title\">u<\/span> <span class=\"hljs-title\">root<\/span> -<span class=\"hljs-title\">p<\/span> --<span class=\"hljs-title\">opt<\/span> --<span class=\"hljs-title\">all<\/span>-<span class=\"hljs-title\">databases<\/span> &gt; <span class=\"hljs-title\">alldb<\/span>.<span class=\"hljs-title\">sql<\/span>\r\n$ <span class=\"hljs-title\">mysqldump<\/span> -<span class=\"hljs-title\">u<\/span> <span class=\"hljs-title\">root<\/span> -<span class=\"hljs-title\">p<\/span> --<span class=\"hljs-title\">all<\/span>-<span class=\"hljs-title\">databases<\/span> --<span class=\"hljs-title\">skip<\/span>-<span class=\"hljs-title\">lock<\/span>-<span class=\"hljs-title\">tables<\/span> &gt; <span class=\"hljs-title\">alldb<\/span>.<span class=\"hljs-title\">sql<\/span>\r\n\n<span class=\"hljs-title\">Import<\/span>:\r\n$ <span class=\"hljs-title\">mysql<\/span> -<span class=\"hljs-title\">u<\/span> <span class=\"hljs-title\">root<\/span> -<span class=\"hljs-title\">p<\/span> &lt; <span class=\"hljs-title\">alldb<\/span>.<span class=\"hljs-title\">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\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>","protected":false},"excerpt":{"rendered":"<p>Script Commands<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-29532","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/29532","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=29532"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/29532\/revisions"}],"predecessor-version":[{"id":29533,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/29532\/revisions\/29533"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=29532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=29532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=29532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}