{"id":196,"date":"2024-10-20T13:31:26","date_gmt":"2024-10-20T13:31:26","guid":{"rendered":"https:\/\/webhostingmumbai.net.in\/blog\/?p=196"},"modified":"2024-10-20T13:31:28","modified_gmt":"2024-10-20T13:31:28","slug":"how-to-make-database-backup-in-cpanel","status":"publish","type":"post","link":"https:\/\/webhostingmumbai.net.in\/blog\/how-to-make-database-backup-in-cpanel\/","title":{"rendered":"How to Make Database Backup in cPanel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Taking a Database Backup in <a href=\"https:\/\/www.cpanel.net\/\" target=\"_blank\" rel=\"noopener\"><strong>cPanel<\/strong><\/a> is an important step to ensure that you can restore your website or data in case of an issue. Here&#8217;s a step-by-step guide to back up your database using cPanel<\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#s\">Steps to Take Database Backup<\/a><ul><li><a href=\"#1-log-into-c-panel\">1. Log into cPanel<\/a><\/li><li><a href=\"#2-access-the-backup-tool\">2. Access the &#8220;Backup&#8221; Tool<\/a><\/li><li><a href=\"#3-download-a-my-sql-database-backup\">3. Download a MySQL Database Backup<\/a><\/li><li><a href=\"#4-alternatively-use-php-my-admin-for-database-backup\">4. Alternatively, Use &#8220;phpMyAdmin&#8221; for Database Backup<\/a><\/li><\/ul><\/li><li><a href=\"#conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"s\">Steps to Take Database Backup<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To take a database backup in <a href=\"https:\/\/webhostingmumbai.net.in\/sharedweb-hosting\/\">cPanel hosting<\/a>, follow these steps:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"1-log-into-c-panel\">1. <strong>Log into cPanel<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to your domain&#8217;s cPanel login page (usually <code>yourdomain.com\/cpanel<\/code>) and enter your credentials.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"544\" src=\"https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/login-1024x544.jpg\" alt=\"\" class=\"wp-image-203\" style=\"width:633px;height:auto\" srcset=\"https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/login-1024x544.jpg 1024w, https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/login-300x159.jpg 300w, https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/login-768x408.jpg 768w, https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/login.jpg 1266w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2-access-the-backup-tool\">2. <strong>Access the &#8220;Backup&#8221; Tool<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Scroll down to the <strong>&#8220;Files&#8221;<\/strong> section and click on <strong>&#8220;Backup&#8221;<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"547\" src=\"https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/backup-1024x547.jpg\" alt=\"\" class=\"wp-image-204\" style=\"width:644px;height:auto\" srcset=\"https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/backup-1024x547.jpg 1024w, https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/backup-300x160.jpg 300w, https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/backup-768x410.jpg 768w, https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/backup.jpg 1107w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3-download-a-my-sql-database-backup\">3. <strong>Download a MySQL Database Backup<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the <strong>&#8220;Download a MySQL Database Backup&#8221;<\/strong> section, you will see a list of your databases.<\/li>\n\n\n\n<li>Click on the database name that you want to back up. This will download a <code>.sql<\/code> file (or <code>.gz<\/code> file if compressed) to your computer.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"742\" height=\"775\" src=\"https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/database.png\" alt=\"\" class=\"wp-image-205\" style=\"width:582px;height:auto\" srcset=\"https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/database.png 742w, https:\/\/webhostingmumbai.net.in\/blog\/wp-content\/uploads\/2024\/10\/database-287x300.png 287w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4-alternatively-use-php-my-admin-for-database-backup\">4. <strong>Alternatively, Use &#8220;phpMyAdmin&#8221; for Database Backup<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Scroll down to the <strong>&#8220;Databases&#8221;<\/strong> section and click on <strong>&#8220;phpMyAdmin&#8221;<\/strong>.<\/li>\n\n\n\n<li>In phpMyAdmin, select the database you want to back up from the left sidebar.<\/li>\n\n\n\n<li>Click on the <strong>&#8220;Export&#8221;<\/strong> tab.\n<ul class=\"wp-block-list\">\n<li><strong>Export Method<\/strong>: Choose either:\n<ul class=\"wp-block-list\">\n<li><strong>Quick<\/strong> \u2013 Exports all tables in a simple format.<\/li>\n\n\n\n<li><strong>Custom<\/strong> \u2013 Allows you to select specific tables and additional export options (for advanced users).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Choose the <strong>&#8220;Format&#8221;<\/strong> as <strong>SQL<\/strong>.<\/li>\n\n\n\n<li>Click <strong>&#8220;Go&#8221;<\/strong>, and the backup will be downloaded.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">That&#8217;s it! You now have a backup of your database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"conclusion\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Taking a database backup in cPanel is straightforward. You can use either the <strong>Backup<\/strong> tool for a quick download or <strong><a href=\"https:\/\/www.phpmyadmin.net\/\" target=\"_blank\" rel=\"noopener\">phpMyAdmin<\/a><\/strong> for more customization. Both methods allow you to securely save your database as an <code>.sql<\/code> file, ensuring that your data is safely backed up for future use.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Taking a Database Backup in cPanel is an important step to ensure that you can restore your website or data in case of an issue. Here&#8217;s a step-by-step guide to back up your database using cPanel Steps to Take Database Backup To take a database backup in cPanel hosting, follow these steps: 1. Log into [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":202,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-196","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/posts\/196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/comments?post=196"}],"version-history":[{"count":6,"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/posts\/196\/revisions"}],"predecessor-version":[{"id":206,"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/posts\/196\/revisions\/206"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/media\/202"}],"wp:attachment":[{"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/media?parent=196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/categories?post=196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhostingmumbai.net.in\/blog\/wp-json\/wp\/v2\/tags?post=196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}