{"id":2984,"date":"2017-01-02T11:06:19","date_gmt":"2017-01-02T11:06:19","guid":{"rendered":"https:\/\/www.milesweb.com\/hosting-faqs\/?p=2984"},"modified":"2026-02-27T15:05:08","modified_gmt":"2026-02-27T09:35:08","slug":"learn-backup-database-cpanel-backup-tool","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/","title":{"rendered":"Learn How to backup your Database with cPanel Backup Tool"},"content":{"rendered":"

If you are having an e-commerce website that is built using WordPress, Joomla, Magento, Drupal or any other content management systems, you must be having a MySQL database. It is mandatory to backup a copy of your database on everyday basis to be on a safer side and stay away from an\u00a0unwanted headache. You can backup your database easily via PHPMyAdmin. So here is the step by step process to backup your database using PHPMyAdmin.<\/p>\n

So let\u2019s see how to Backup the Database<\/h3>\n

Step 1:<\/strong> Once you have logged into cPanel, click on “PHPMyAdmin<\/em>” icon in the databases section. Once you are done, you will see a screen like the one below.<\/p>\n

\"\"<\/a><\/p>\n

Step 2:<\/strong> Select the database you need to export to your system by clicking on the box next to the database name as indicated in the screenshot below.<\/p>\n

\"\"<\/a><\/p>\n

Step 3:<\/strong> Now click on Export in the menu located at the top of the phpMySQL screen. This will display the options for export and will also give you a confirmation of where the export is coming from.<\/p>\n

\"\"<\/a><\/p>\n

Step 4:<\/strong> We will be using the Quick export method here. This exports the file in SQL format. If you need to select specific options for the export, then click on Custom and select your options. You should only select this if you are familiar with exporting MYSQL databases. Click on Go to complete the export.<\/p>\n

\"\"<\/a><\/p>\n

<\/h4>\n

Step 5:<\/strong> You will see a screen that asks to choose the location to save the export file. You will also have the option to name the database backup file as per your requirement. Don\u2019t forget to make sure that the\u00a0files are saved to a safe location once the export process is complete.<\/p>\n

\"\"<\/a><\/p>\n

<\/h4>\n

Step 6:<\/strong> Now you have now successfully backed up your database!<\/p>\n

Related: A Step by Step Process to Restore a Database Backup in cPanel<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

If you are having an e-commerce website that is built using WordPress, Joomla, Magento, Drupal or any other content management systems, you must be having a MySQL database. It is mandatory to backup a copy of your database on everyday basis to be on a safer side and stay away from an\u00a0unwanted headache. You can […]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3047],"tags":[],"class_list":["post-2984","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-databases-mysql-mariadb"],"yoast_head":"\nLearn How to backup your Database with cPanel Backup Tool<\/title>\n<meta name=\"description\" content=\"Want to backup your website database? Here is a step by step process that can help you to backup your database with Cpanel backup tools. Learn more here.\" \/>\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.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn How to backup your Database with cPanel Backup Tool\" \/>\n<meta property=\"og:description\" content=\"Want to backup your website database? Here is a step by step process that can help you to backup your database with Cpanel backup tools. Learn more here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-02T11:06:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-27T09:35:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2017\/01\/main-screen-of-phpmysql.1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1031\" \/>\n\t<meta property=\"og:image:height\" content=\"661\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pravin Ganore\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pravin Ganore\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/\"},\"author\":{\"name\":\"Pravin Ganore\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6\"},\"headline\":\"Learn How to backup your Database with cPanel Backup Tool\",\"datePublished\":\"2017-01-02T11:06:19+00:00\",\"dateModified\":\"2026-02-27T09:35:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/\"},\"wordCount\":319,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2017\/01\/main-screen-of-phpmysql.1.png\",\"articleSection\":[\"Databases (MySQL \/ MariaDB)\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/\",\"name\":\"Learn How to backup your Database with cPanel Backup Tool\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2017\/01\/main-screen-of-phpmysql.1.png\",\"datePublished\":\"2017-01-02T11:06:19+00:00\",\"dateModified\":\"2026-02-27T09:35:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6\"},\"description\":\"Want to backup your website database? Here is a step by step process that can help you to backup your database with Cpanel backup tools. Learn more here.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2017\/01\/main-screen-of-phpmysql.1.png\",\"contentUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2017\/01\/main-screen-of-phpmysql.1.png\",\"width\":1031,\"height\":661},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn How to backup your Database with cPanel Backup Tool\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6\",\"name\":\"Pravin Ganore\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/911c7c72d64a0d0e0b6c8f1be7e7421c413395f2f2403d0adb26ae16b4130572?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/911c7c72d64a0d0e0b6c8f1be7e7421c413395f2f2403d0adb26ae16b4130572?s=96&d=blank&r=g\",\"caption\":\"Pravin Ganore\"},\"description\":\"Pravin is Journalist Specializing in Blogging, Social Networking and Community Management. As a constant learner, he is always aiming towards new ideas and greater knowledge. When he is not doing research, reading, or writing for blogs, you can find him hanging around social media sites.\",\"sameAs\":[\"https:\/\/www.milesweb.com\"],\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/author\/pravin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn How to backup your Database with cPanel Backup Tool","description":"Want to backup your website database? Here is a step by step process that can help you to backup your database with Cpanel backup tools. Learn more here.","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.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/","og_locale":"en_US","og_type":"article","og_title":"Learn How to backup your Database with cPanel Backup Tool","og_description":"Want to backup your website database? Here is a step by step process that can help you to backup your database with Cpanel backup tools. Learn more here.","og_url":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2017-01-02T11:06:19+00:00","article_modified_time":"2026-02-27T09:35:08+00:00","og_image":[{"width":1031,"height":661,"url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2017\/01\/main-screen-of-phpmysql.1.png","type":"image\/png"}],"author":"Pravin Ganore","twitter_misc":{"Written by":"Pravin Ganore","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/"},"author":{"name":"Pravin Ganore","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6"},"headline":"Learn How to backup your Database with cPanel Backup Tool","datePublished":"2017-01-02T11:06:19+00:00","dateModified":"2026-02-27T09:35:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/"},"wordCount":319,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2017\/01\/main-screen-of-phpmysql.1.png","articleSection":["Databases (MySQL \/ MariaDB)"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/","name":"Learn How to backup your Database with cPanel Backup Tool","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2017\/01\/main-screen-of-phpmysql.1.png","datePublished":"2017-01-02T11:06:19+00:00","dateModified":"2026-02-27T09:35:08+00:00","author":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6"},"description":"Want to backup your website database? Here is a step by step process that can help you to backup your database with Cpanel backup tools. Learn more here.","breadcrumb":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#primaryimage","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2017\/01\/main-screen-of-phpmysql.1.png","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2017\/01\/main-screen-of-phpmysql.1.png","width":1031,"height":661},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/learn-backup-database-cpanel-backup-tool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"Learn How to backup your Database with cPanel Backup Tool"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6","name":"Pravin Ganore","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/911c7c72d64a0d0e0b6c8f1be7e7421c413395f2f2403d0adb26ae16b4130572?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/911c7c72d64a0d0e0b6c8f1be7e7421c413395f2f2403d0adb26ae16b4130572?s=96&d=blank&r=g","caption":"Pravin Ganore"},"description":"Pravin is Journalist Specializing in Blogging, Social Networking and Community Management. As a constant learner, he is always aiming towards new ideas and greater knowledge. When he is not doing research, reading, or writing for blogs, you can find him hanging around social media sites.","sameAs":["https:\/\/www.milesweb.com"],"url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/pravin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/2984","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=2984"}],"version-history":[{"count":4,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/2984\/revisions"}],"predecessor-version":[{"id":16417,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/2984\/revisions\/16417"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=2984"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=2984"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=2984"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}