{"id":567,"date":"2024-10-22T08:40:16","date_gmt":"2024-10-22T03:10:16","guid":{"rendered":"https:\/\/mumbaiwebhosting.co.in\/articles\/?p=567"},"modified":"2024-10-22T08:41:35","modified_gmt":"2024-10-22T03:11:35","slug":"restore-database-backup-in-cpanel","status":"publish","type":"post","link":"https:\/\/mumbaiwebhosting.co.in\/articles\/restore-database-backup-in-cpanel\/","title":{"rendered":"Restore database backup in cPanel?"},"content":{"rendered":"\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#1-login-to-c-panel\">1. Login to cPanel<\/a><\/li><li><a href=\"#2-access-the-backup-or-backup-wizard-tool\">2. Access the Backup <\/a><\/li><li><a href=\"#3-select-restore-database-backup\">3. Select &#8220;Restore Database Backup&#8221;<\/a><\/li><li><a href=\"#4-choose-the-backup-file\">4. Choose the Backup File<\/a><\/li><li><a href=\"#5-upload-the-backup\">5. Upload the Backup<\/a><\/li><li><a href=\"#6-wait-for-the-restoration-process\">6. Wait for the Restoration Process<\/a><\/li><li><a href=\"#7-verify-the-restoration\">7. Verify the Restoration<\/a><\/li><li><a href=\"#additional-notes\">Additional Notes:<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<p>Restore database backup in <strong><a href=\"https:\/\/cpanel.net\/\" target=\"_blank\" rel=\"noopener\">cPanel<\/a><\/strong> is a straightforward process that involves using the built-in tools to upload and restore your database. Here&#8217;s a step-by-step guide on how to restore a database backup in cPanel:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1-login-to-c-panel\">1. <strong>Login to cPanel<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"447\" src=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-2.png\" alt=\"\" class=\"wp-image-570\" srcset=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-2.png 435w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-2-292x300.png 292w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Navigate to your hosting account\u2019s cPanel dashboard. Typically, this is done by typing <strong>yourdomain.com\/cPanel<\/strong> into your browser and entering your cPanel credentials.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2-access-the-backup-or-backup-wizard-tool\">2. <strong>Access the Backup <\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"365\" src=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-3-1024x365.png\" alt=\"\" class=\"wp-image-571\" srcset=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-3-1024x365.png 1024w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-3-300x107.png 300w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-3-768x273.png 768w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-3.png 1143w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once logged in, scroll down to the <strong>Files<\/strong> section and click on either:\n<ul class=\"wp-block-list\">\n<li><strong>Backup<\/strong>: This tool allows you to download and restore backups for databases, files, and more.<\/li>\n\n\n\n<li><strong>Backup Wizard<\/strong>: This tool provides a more guided, step-by-step process for both backups and restores.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3-select-restore-database-backup\">3. <strong>Select &#8220;Restore Database Backup&#8221;<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the <strong>Backup<\/strong> look for an option that says <strong>Restore a MySQL Database Backup<\/strong>. This will allow you to upload your database backup file.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4-choose-the-backup-file\">4. <strong>Choose the Backup File<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"643\" height=\"170\" src=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-4.png\" alt=\"\" class=\"wp-image-572\" srcset=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-4.png 643w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-4-300x79.png 300w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on the <strong>Choose File<\/strong> button or <strong>Browse<\/strong> (depending on your version of cPanel) to locate the backup file you want to restore. The backup file will typically have an extension like <code>.sql<\/code>, <code>.gz<\/code>, or <code>.zip<\/code> (if compressed).<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"5-upload-the-backup\">5. <strong>Upload the Backup<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"143\" src=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-6-1024x143.png\" alt=\"\" class=\"wp-image-574\" srcset=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-6-1024x143.png 1024w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-6-300x42.png 300w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-6-768x107.png 768w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-6.png 1227w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After selecting the backup file, click <strong>Upload<\/strong> or <strong>Restore<\/strong>. This will begin the process of restoring your database from the backup file.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"6-wait-for-the-restoration-process\">6. <strong>Wait for the Restoration Process<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The time it takes to restore your database will depend on the size of the file. Once the restoration is complete, cPanel will notify you that the database has been successfully restored.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"7-verify-the-restoration\">7. <strong>Verify the Restoration<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After restoring the backup, you should verify that the database has been properly restored. You can do this by:\n<ul class=\"wp-block-list\">\n<li><strong>Logging into phpMyAdmin<\/strong>: Go to the <strong>Databases<\/strong> section in cPanel and click on <strong>phpMyAdmin<\/strong>. Check if the tables, data, and structure of the restored database are correct.<\/li>\n\n\n\n<li><strong>Test the Website<\/strong>: If your website relies on this database, check the site to ensure it\u2019s functioning correctly and displaying the restored data.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"additional-notes\">Additional Notes:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Database Name Matching<\/strong>: Ensure that the backup file is being restored to the correct database. If the database does not already exist, you may need to create a new database and user under the <strong>MySQL Databases<\/strong> section of cPanel, then restore the backup to that database.<\/li>\n\n\n\n<li><strong>Permissions<\/strong>: Make sure that the database user has the correct privileges to access and modify the database if needed. You can manage user privileges in the <strong>MySQL Databases<\/strong> section.<\/li>\n\n\n\n<li><strong>phpMyAdmin (Alternative Method)<\/strong>:\n<ul class=\"wp-block-list\">\n<li>If you&#8217;re having trouble with the <strong>Backup<\/strong> or <strong>Backup Wizard<\/strong>, you can manually restore the database using <strong>phpMyAdmin<\/strong>:\n<ol class=\"wp-block-list\">\n<li>Go to the <strong>Databases<\/strong> section in cPanel and click <strong>phpMyAdmin<\/strong>.<\/li>\n\n\n\n<li>Select the database you want to restore from the list on the left side.<\/li>\n\n\n\n<li>Click the <strong>Import<\/strong> tab at the top of the phpMyAdmin interface.<\/li>\n\n\n\n<li>Use the <strong>Choose File<\/strong> button to select your <code>.sql<\/code> backup file.<\/li>\n\n\n\n<li>Click <strong>Go<\/strong> to begin the import. Wait until it confirms the successful restoration of the database.<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p><strong>How to Restore a MySQL Database in cPanel<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"292\" src=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-1024x292.png\" alt=\"\" class=\"wp-image-568\" srcset=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-1024x292.png 1024w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-300x85.png 300w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-768x219.png 768w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image.png 1078w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Restoring an SQL file overwrites tables and deletes data. If, for example, you published a blog post to your CMS after you last backed up, it will be irreversibly deleted when you restore. Before restoring a backup, make sure it won\u2019t remove data that you want to keep.&nbsp;<\/p>\n\n\n\n<p>In the section titled&nbsp;<em>Restore a MySQL Database Backup<\/em>, click&nbsp;<em>Choose File<\/em>&nbsp;and select an SQL file from your local machine. Click&nbsp;<em>Upload,<\/em>&nbsp;and cPanel will import the file.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"schedule-my-sql-backups-with-cron-in-c-panel\"><strong>Schedule MySQL Backups with Cron in cPanel<\/strong><\/h2>\n\n\n\n<p>We\u2019ve seen how easy it is to back up MySQL databases in your <a href=\"http:\/\/mumbaiwebhosting.co.in\">hosting<\/a> cPanel, but what if you want to automatically back up a database on a schedule? It\u2019s all too easy to forget, and scheduling ensures that the safety of your data don\u2019t depend on your memory.\u00a0<\/p>\n\n\n\n<p>To automate a MySQL backup, you can use the cron task scheduler and the command-line \u201cmysqldump\u201d tool. Navigate to the cPanel&nbsp;<em>Cron Jobs<\/em>&nbsp;page, which you\u2019ll find under&nbsp;<em>Advanced<\/em>&nbsp;on the main page.&nbsp;<\/p>\n\n\n\n<p>Use the drop-down boxes to select a time interval, such as once per week.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"632\" src=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-1.png\" alt=\"\" class=\"wp-image-569\" srcset=\"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-1.png 667w, https:\/\/mumbaiwebhosting.co.in\/articles\/wp-content\/uploads\/2024\/10\/image-1-300x284.png 300w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/figure>\n\n\n\n<p>In the command field, enter the following, replacing the uppercase sections with the appropriate details for your database:<\/p>\n\n\n\n<p>mysqldump -u USERNAME -p PASSWORD database &gt; database_backup.sql<\/p>\n\n\n\n<p>Click the&nbsp;<em>Add New Cron Job<\/em>&nbsp;button, and you\u2019re done. Cron will run the backup at the indicated time interval, saving the SQL file to the location specified at the end of the command (the part after the &gt; symbol).&nbsp;<\/p>\n\n\n\n<p>By following these steps, you can restore database backup in cPanel with ease.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Restore database backup in cPanel is a straightforward process that involves using the built-in tools to upload and restore your database. Here&#8217;s a step-by-step guide on how to restore a database backup in cPanel: 1. Login to cPanel 2. Access the Backup 3. Select &#8220;Restore Database Backup&#8221; 4. Choose the Backup File 5. Upload the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58],"tags":[],"class_list":["post-567","post","type-post","status-publish","format-standard","hentry","category-restore-database-backup"],"_links":{"self":[{"href":"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-json\/wp\/v2\/posts\/567","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-json\/wp\/v2\/comments?post=567"}],"version-history":[{"count":2,"href":"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-json\/wp\/v2\/posts\/567\/revisions"}],"predecessor-version":[{"id":576,"href":"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-json\/wp\/v2\/posts\/567\/revisions\/576"}],"wp:attachment":[{"href":"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-json\/wp\/v2\/media?parent=567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-json\/wp\/v2\/categories?post=567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mumbaiwebhosting.co.in\/articles\/wp-json\/wp\/v2\/tags?post=567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}