{"id":779,"date":"2025-12-19T09:43:21","date_gmt":"2025-12-19T08:43:21","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=779"},"modified":"2026-02-24T14:12:17","modified_gmt":"2026-02-24T13:12:17","slug":"mysql-backup-restore","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/en\/knowledgebase\/mysql-backup-restore\/","title":{"rendered":"Restoring a MySQL database from backup"},"content":{"rendered":"\n<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">mybox creates automatic daily backups of all databases on your account. If you need to roll back a database to an earlier state \u2014 for example after a failed update, a plugin conflict, or accidental data loss \u2014 you can restore it directly from the <a href=\"https:\/\/panel.mybox.com\">mybox panel<\/a>.<\/p>\n\n\n\n<div class=\"wp-block-onethird-callout-box onethird-callout-wrap\"><div class=\"onethird-callout onethird-callout--warn\" style=\"--ot-bg:#FFEAE9;--ot-border:#F8D0D0;--ot-text:#6F7C88;--ot-title:#384048;--ot-body:#6F7C88;--ot-icon:#384048;border-radius:6px;padding:16px\"><div class=\"onethird-callout__head\"><span class=\"onethird-callout__icon\"><svg viewBox=\"0 0 24 24\" width=\"18\" height=\"18\" aria-hidden=\"true\" focusable=\"false\"><path fill=\"none\" stroke=\"#384048\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M12 3 2.5 20.5h19L12 3z\"><\/path><path fill=\"none\" stroke=\"#384048\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M12 9v5\"><\/path><path fill=\"none\" stroke=\"#384048\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M12 17h.01\"><\/path><\/svg><\/span><div class=\"onethird-callout__title\">Before you start<\/div><\/div><div class=\"onethird-callout__body\">Restoring a backup <strong>overwrites all current data<\/strong> in the target database. This operation cannot be undone. If you are unsure, export the current database first using the manual backup option before proceeding.<\/div><\/div><div class=\"onethird-callout__separator\" style=\"height:18px\" aria-hidden=\"true\"><\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"> \u2192<a href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/creating-your-own-mysql-backup\/\">How to create a manual MySQL backup<\/a><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/mysql-backup-restore\/#How_many_backups_are_available\" >How many backups are available?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/mysql-backup-restore\/#Steps\" >Steps<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_many_backups_are_available\"><\/span><strong>How many backups are available?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<\/div>\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Plan<\/strong><\/td><td><strong>Backup retention<\/strong><\/td><\/tr><tr><td><strong>One Box<\/strong><\/td><td>1 day (1 restore point)<\/td><\/tr><tr><td><strong>Flex Box<\/strong><\/td><td>7 days<\/td><\/tr><tr><td><strong>Prime Box<\/strong><\/td><td>7 days<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Steps\"><\/span><strong>Steps<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n___TP_PROTECTED_BLOCK_0___<p class=\"wp-block-paragraph\"><strong>1.<\/strong> Log in to the <a href=\"https:\/\/panel.mybox.com\">mybox panel<\/a> and go to <strong>Databases \u2192 MySQL Databases<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"218\" height=\"251\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-321.png\" alt=\"\" class=\"wp-image-4683\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-321.png 218w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-321-10x12.png 10w\" sizes=\"auto, (max-width: 218px) 100vw, 218px\" \/><\/figure>\n\n<div class=\"translation-block translation-block-merged\">\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>2.<\/strong> Click on the database you want to restore, then select <strong>Backups<\/strong>. A list of available restore points for that database will appear.<\/p>\n\n\n\n<\/div>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"838\" height=\"269\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-323.png\" alt=\"\" class=\"wp-image-4690\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-323.png 838w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-323-300x96.png 300w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-323-768x247.png 768w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-323-18x6.png 18w\" sizes=\"auto, (max-width: 838px) 100vw, 838px\" \/><\/figure>\n\n\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"832\" height=\"113\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-322.png\" alt=\"\" class=\"wp-image-4689\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-322.png 832w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-322-300x41.png 300w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-322-768x104.png 768w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-322-18x2.png 18w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-322-825x113.png 825w\" sizes=\"auto, (max-width: 832px) 100vw, 832px\" \/><\/figure>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.<\/strong> Click <strong>Restore<\/strong> next to the backup you want to use. To see the exact date and time of a backup, hover over the time indicator (e.g. <em>&#8220;2 days ago&#8221;<\/em>).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4.<\/strong> A confirmation window will appear showing the exact backup timestamp. Select the <strong>target database<\/strong> \u2014 this is the database that will be overwritten \u2014 and click <strong>Restore<\/strong> to confirm.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5.<\/strong> A confirmation notification will appear in the upper right corner of the panel. The restore process runs in the background.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>6.<\/strong> Once the operation is complete, the notification will update to confirm the restore is finished.<\/p>\n\n\n\n<div class=\"wp-block-onethird-callout-box onethird-callout-wrap\"><div class=\"onethird-callout onethird-callout--hint\" style=\"--ot-bg:#EAFFF7;--ot-border:#C8E8D8;--ot-text:#6F7C88;--ot-title:#384048;--ot-body:#6F7C88;--ot-icon:#384048;border-radius:6px;padding:16px\"><div class=\"onethird-callout__head\"><span class=\"onethird-callout__icon\"><svg viewBox=\"0 0 24 24\" width=\"18\" height=\"18\" aria-hidden=\"true\" focusable=\"false\"><path fill=\"none\" stroke=\"#384048\" stroke-width=\"2\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M2 10h4v12H2V10zm20 1c0-1.1-.9-2-2-2h-6.31l.95-4.57.02-.2c0-.26-.11-.5-.29-.68L13.17 2 7.59 7.59C7.22 7.95 7 8.45 7 9v11c0 1.1.9 2 2 2h8c.82 0 1.54-.5 1.84-1.22l3.02-7.05c.09-.23.14-.47.14-.73v-2z\"><\/path><\/svg><\/span><div class=\"onethird-callout__title\">Early Access<\/div><\/div><div class=\"onethird-callout__body\">Database backup restore is available in early access. One Box accounts have <strong>1 restore point<\/strong> (previous day). Backup retention of 7 days will be available on Flex Box and Prime Box in a later phase<\/div><\/div><div class=\"onethird-callout__separator\" style=\"height:18px\" aria-hidden=\"true\"><\/div><\/div>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[9,25],"manual_kb_tag":[2126,2142,2127,2143,2128,2144,2129,2145,2130,2131,2132,242,2133,283,2134,389,2135,801,2136,968,2137,1014,2138,1108,2139,1110,2140,2125,2141],"class_list":["post-779","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-databases","manualknowledgebasecat-hosting","manual_kb_tag-restore-database","manual_kb_tag-mybox-backups","manual_kb_tag-database-backups","manual_kb_tag-restore-operation","manual_kb_tag-backup-restore","manual_kb_tag-restore-window","manual_kb_tag-restore-confirmation","manual_kb_tag-restore-status","manual_kb_tag-overwrite-database","manual_kb_tag-restore-process","manual_kb_tag-restore-completed","manual_kb_tag-mybox","manual_kb_tag-backup-list","manual_kb_tag-mybox-panel","manual_kb_tag-select-backups","manual_kb_tag-database-backup","manual_kb_tag-restore-steps","manual_kb_tag-mysql","manual_kb_tag-restore-instructions","manual_kb_tag-databases","manual_kb_tag-backup-confirmation","manual_kb_tag-mybox-com","manual_kb_tag-backup-management","manual_kb_tag-database","manual_kb_tag-target-database","manual_kb_tag-database-restore","manual_kb_tag-overwrite-warning","manual_kb_tag-my-backup-restore","manual_kb_tag-current-data-copy"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/779","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":7,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/779\/revisions"}],"predecessor-version":[{"id":3932,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/779\/revisions\/3932"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/media?parent=779"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manualknowledgebasecat?post=779"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb_tag?post=779"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}