{"id":9722,"date":"2024-03-14T10:06:05","date_gmt":"2024-03-14T10:06:05","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/"},"modified":"2024-03-20T16:11:07","modified_gmt":"2024-03-20T16:11:07","slug":"how-to-configure-scheduled-database-backups-and-restoration-in-mysql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/","title":{"rendered":"How to configure scheduled database backups and restoration in MySQL?"},"content":{"rendered":"<p>MySQL database backup and restoration can be achieved using the built-in tools mysqldump and mysql. Below are the specific configuration steps:<\/p>\n<ol>\n<li>Scheduled database backups:<br \/>\nYou can use crontab to schedule the execution of the backup script. First, create a backup script such as backup.sh, and add the following content:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-meta\">#!\/bin\/bash<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u8bbe\u7f6e\u5907\u4efd\u6587\u4ef6\u5b58\u653e\u76ee\u5f55<\/span>\r\nbackup_dir=<span class=\"hljs-string\">\"\/path\/to\/backup\"<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u8bbe\u7f6e\u6570\u636e\u5e93\u7528\u6237\u540d\u548c\u5bc6\u7801<\/span>\r\ndb_user=<span class=\"hljs-string\">\"username\"<\/span>\r\ndb_password=<span class=\"hljs-string\">\"password\"<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u8bbe\u7f6e\u6570\u636e\u5e93\u540d<\/span>\r\ndb_name=<span class=\"hljs-string\">\"database_name\"<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u8bbe\u7f6e\u5907\u4efd\u6587\u4ef6\u540d<\/span>\r\nbackup_file=<span class=\"hljs-string\">\"<span class=\"hljs-variable\">$backup_dir<\/span>\/<span class=\"hljs-variable\">$db_name<\/span>-<span class=\"hljs-subst\">$(date +<span class=\"hljs-string\">\"%Y-%m-%d\"<\/span>)<\/span>.sql\"<\/span>\r\n\r\n<span class=\"hljs-comment\"># \u4f7f\u7528mysqldump\u547d\u4ee4\u5907\u4efd\u6570\u636e\u5e93<\/span>\r\nmysqldump -u <span class=\"hljs-variable\">$db_user<\/span> -p<span class=\"hljs-variable\">$db_password<\/span> <span class=\"hljs-variable\">$db_name<\/span> &gt; <span class=\"hljs-variable\">$backup_file<\/span>\r\n<\/code><\/pre>\n<p>Then use crontab to schedule the backup script to run at a specific time, for example, at 3 AM every day.<\/p>\n<pre class=\"post-pre\"><code>0 3 * * * \/path\/to\/backup.sh\r\n<\/code><\/pre>\n<ol>\n<li>Restore database:<br \/>\nTo restore the database, you can use the mysql command to execute the backup file. First, copy the backup file to the server, and then execute the following command to restore the database:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code>mysql -u username -p password database_name &lt; \/path\/to\/backup.sql\r\n<\/code><\/pre>\n<p>The above are the configuration steps for scheduled backup and restoration of MySQL databases, hope it helps you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL database backup and restoration can be achieved using the built-in tools mysqldump and mysql. Below are the specific configuration steps: Scheduled database backups: You can use crontab to schedule the execution of the backup script. First, create a backup script such as backup.sh, and add the following content: #!\/bin\/bash # \u8bbe\u7f6e\u5907\u4efd\u6587\u4ef6\u5b58\u653e\u76ee\u5f55 backup_dir=&#8221;\/path\/to\/backup&#8221; # \u8bbe\u7f6e\u6570\u636e\u5e93\u7528\u6237\u540d\u548c\u5bc6\u7801 [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-9722","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to configure scheduled database backups and restoration in MySQL? - Blog - Silicon Cloud<\/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:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to configure scheduled database backups and restoration in MySQL?\" \/>\n<meta property=\"og:description\" content=\"MySQL database backup and restoration can be achieved using the built-in tools mysqldump and mysql. Below are the specific configuration steps: Scheduled database backups: You can use crontab to schedule the execution of the backup script. First, create a backup script such as backup.sh, and add the following content: #!\/bin\/bash # \u8bbe\u7f6e\u5907\u4efd\u6587\u4ef6\u5b58\u653e\u76ee\u5f55 backup_dir=&quot;\/path\/to\/backup&quot; # \u8bbe\u7f6e\u6570\u636e\u5e93\u7528\u6237\u540d\u548c\u5bc6\u7801 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T10:06:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-20T16:11:07+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"How to configure scheduled database backups and restoration in MySQL?\",\"datePublished\":\"2024-03-14T10:06:05+00:00\",\"dateModified\":\"2024-03-20T16:11:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/\"},\"wordCount\":133,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/\",\"name\":\"How to configure scheduled database backups and restoration in MySQL? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T10:06:05+00:00\",\"dateModified\":\"2024-03-20T16:11:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to configure scheduled database backups and restoration in MySQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to configure scheduled database backups and restoration in MySQL? - Blog - Silicon Cloud","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.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"How to configure scheduled database backups and restoration in MySQL?","og_description":"MySQL database backup and restoration can be achieved using the built-in tools mysqldump and mysql. Below are the specific configuration steps: Scheduled database backups: You can use crontab to schedule the execution of the backup script. First, create a backup script such as backup.sh, and add the following content: #!\/bin\/bash # \u8bbe\u7f6e\u5907\u4efd\u6587\u4ef6\u5b58\u653e\u76ee\u5f55 backup_dir=\"\/path\/to\/backup\" # \u8bbe\u7f6e\u6570\u636e\u5e93\u7528\u6237\u540d\u548c\u5bc6\u7801 [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T10:06:05+00:00","article_modified_time":"2024-03-20T16:11:07+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"How to configure scheduled database backups and restoration in MySQL?","datePublished":"2024-03-14T10:06:05+00:00","dateModified":"2024-03-20T16:11:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/"},"wordCount":133,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/","name":"How to configure scheduled database backups and restoration in MySQL? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T10:06:05+00:00","dateModified":"2024-03-20T16:11:07+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-configure-scheduled-database-backups-and-restoration-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to configure scheduled database backups and restoration in MySQL?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=9722"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9722\/revisions"}],"predecessor-version":[{"id":42913,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9722\/revisions\/42913"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=9722"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=9722"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=9722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}