{"id":4086,"date":"2019-10-29T17:33:09","date_gmt":"2019-10-29T09:33:09","guid":{"rendered":"https:\/\/www.mondoze.com\/guide\/?post_type=kb&#038;p=4086"},"modified":"2022-10-05T07:56:26","modified_gmt":"2022-10-04T23:56:26","slug":"restore-mysql-database-with-cpanel-backup-tool","status":"publish","type":"kb","link":"https:\/\/www.mondoze.com\/guide\/kb\/restore-mysql-database-with-cpanel-backup-tool","title":{"rendered":"Restore MySQL Database With Cpanel Backup Tool"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"4086\" class=\"elementor elementor-4086\" data-elementor-settings=\"[]\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4b769df0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4b769df0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3ebc68ec\" data-id=\"3ebc68ec\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e35b560 elementor-widget elementor-widget-heading\" data-id=\"e35b560\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Restore MySQL Database With Cpanel Backup Tool<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5c2d8fea elementor-widget elementor-widget-text-editor\" data-id=\"5c2d8fea\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<div dir=\"ltr\"><p dir=\"ltr\">With the Backups tool in Cpanel, you may generate, download or restore backup files, MySQL databases and email domain forwarder \/filter. It is recommended to download the backups to your local machine as a backup.<\/p><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7adaf56 elementor-widget elementor-widget-heading\" data-id=\"7adaf56\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-medium\">You may refer to the step below on how to restore\u00a0 from CPanel.<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c1a24c2 elementor-widget elementor-widget-text-editor\" data-id=\"c1a24c2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<div dir=\"ltr\"><p>1. Login to your Cpanel at domain_name\/cpanel\/ or domain_name:2082<\/p><\/div><div dir=\"ltr\">2. Click on the Backups icon.<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d5e9be1 elementor-widget elementor-widget-image\" data-id=\"d5e9be1\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" loading=\"lazy\" width=\"728\" height=\"207\" src=\"https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/blob1464755440543.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/blob1464755440543.png 728w, https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/blob1464755440543-300x85.png 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a28cf9 elementor-widget elementor-widget-text-editor\" data-id=\"7a28cf9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<div dir=\"ltr\">3. Choose on the option.\u00a0<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a7ef13f elementor-widget elementor-widget-image\" data-id=\"a7ef13f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" loading=\"lazy\" width=\"759\" height=\"403\" src=\"https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/blob1464755481880.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/blob1464755481880.png 759w, https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/blob1464755481880-300x159.png 300w\" sizes=\"(max-width: 759px) 100vw, 759px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-55e974d elementor-widget elementor-widget-text-editor\" data-id=\"55e974d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<div dir=\"ltr\">Browse\u00a0 backup file you have on your local machine then click on upload button.<\/div><div dir=\"ltr\">\u00a0<\/div><div dir=\"ltr\"><p>4. Wait the operation to restore to be completed. (<i>Note: This might take several minute which depend on your MySQL database backup file size.<\/i>)<\/p><\/div><div dir=\"ltr\">5. Once completed, you may have to reassign the corresponding database user to the\u00a0 again.<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fb4a08c elementor-widget elementor-widget-heading\" data-id=\"fb4a08c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">To assign the database user to a MySQL database, you may go back to the main page of the CPanel.<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc63a8f elementor-widget elementor-widget-text-editor\" data-id=\"dc63a8f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<div dir=\"ltr\">1. Click on MySQL databases.<\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c9bd4b3 elementor-widget elementor-widget-image\" data-id=\"c9bd4b3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-image\">\n\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" loading=\"lazy\" width=\"726\" height=\"133\" src=\"https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/blob1464755504088.png\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/blob1464755504088.png 726w, https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/blob1464755504088-300x55.png 300w\" sizes=\"(max-width: 726px) 100vw, 726px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a1f011 elementor-widget elementor-widget-text-editor\" data-id=\"7a1f011\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<div dir=\"ltr\">2. Browse to \u201cAdd Users To Databases:\u201d section.<\/div><div dir=\"ltr\"><p>3. Choose the corresponding user and database, click on &#8220;Add user to database&#8221;.<\/p><\/div>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Restore MySQL Database With Cpanel Backup Tool With the Backups tool in Cpanel, you may generate, download or restore backup files, MySQL databases and email domain forwarder \/filter. It is recommended to download the backups to your local machine as a backup. You may refer to the step below on how to restore\u00a0 from CPanel. &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.mondoze.com\/guide\/kb\/restore-mysql-database-with-cpanel-backup-tool\"> <span class=\"screen-reader-text\">Restore MySQL Database With Cpanel Backup Tool<\/span> Read More \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}}},"kbtopic":[44],"kbtag":[110],"mkb_version":[],"_links":{"self":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/4086"}],"collection":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/comments?post=4086"}],"version-history":[{"count":16,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/4086\/revisions"}],"predecessor-version":[{"id":21887,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/4086\/revisions\/21887"}],"wp:attachment":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/media?parent=4086"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=4086"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtag?post=4086"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=4086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}