{"id":6342,"date":"2019-08-20T06:05:44","date_gmt":"2019-08-20T06:05:44","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=6342"},"modified":"2022-02-19T06:35:48","modified_gmt":"2022-02-19T06:35:48","slug":"how-to-create-backup-of-a-mysql-database","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/","title":{"rendered":"How To Create Backup Of A MySQL Database?"},"content":{"rendered":"<p><strong>Steps for creating backup of a MySQL database:<\/strong><!--more--><\/p>\n<ul>\n<li>Login to your control panel and go to \u2018MySQL Database\u2019.<\/li>\n<li>On the left hand side, select a database that you wish to manage.<\/li>\n<li>A list of usernames will be displayed on the right hand side, click on the Access icon for the selected username. When you click on the Access icon, phpMyAdmin page will be displayed through which you can manage the selected database.<\/li>\n<li>While your database is selected on the left hand side pane:\n<ul>\n<li>Click on the Export tab<\/li>\n<li>All the tables will be exported quickly<\/li>\n<li>Format SQL and Go<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13780\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png\" alt=\"export\" width=\"880\" height=\"273\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png 880w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export-300x93.png 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export-768x238.png 768w\" sizes=\"auto, (max-width: 880px) 100vw, 880px\" \/><\/a><\/p>\n<ul>\n<li>Now your database will be available for downloading and other options.<\/li>\n<\/ul>\n<p><strong>How to schedule specific tables in a database for an on-demand backup?<\/strong><\/p>\n<ul>\n<li>Login to your control panel and go to \u2018MySQL Database\u2019.<\/li>\n<li>On the left hand side, select a database that you wish to manage.<\/li>\n<li>A list of usernames will be displayed on the right hand side, click on the Access icon for the selected username. When you click on the Access icon, phpMyAdmin page will be displayed through which you can manage the selected database.<\/li>\n<li>While your database is selected on the left hand side pane:\n<ul>\n<li>Click on the Export tab<\/li>\n<li>Change the Export method to \u2018Custom\u2019<\/li>\n<li>Select all the tables that you want to Export<\/li>\n<li>Change the other Export options<\/li>\n<li>Format SQL and Go<\/li>\n<\/ul>\n<\/li>\n<li>Now your database will be available for downloading and other options.<\/li>\n<\/ul>\n<p><strong>What to do when you are unable to schedule a MySQL database backup?<\/strong><\/p>\n<p><strong>Issue : <\/strong>When you go to MySQL Beta &gt;&gt; \u2018Manage Backups\u2019 tab and when you click on a particular database name for creating the backup, nothing happens.<\/p>\n<p><strong>Why does this happen? <\/strong>This happens because the server is trying to post an error and it is not getting displayed. The error is : Server is busy. Please try again later.<\/p>\n<p><strong>The solution : <\/strong>The simple solution is that you should try to schedule the data backup at a later point of time.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Steps for creating backup of a MySQL database:<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,947,925],"tags":[950,205,471,616],"class_list":["post-6342","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-cpanel-faq","category-mysql","category-phpmyadmin","tag-create-backup","tag-mysql","tag-mysql-database","tag-phpmyadmin"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create Backup Of A MySQL Database?<\/title>\n<meta name=\"description\" content=\"This article features steps for creating backup of a MySQL database.\" \/>\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.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create Backup Of A MySQL Database?\" \/>\n<meta property=\"og:description\" content=\"This article features steps for creating backup of a MySQL database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-20T06:05:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-19T06:35:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png\" \/>\n<meta name=\"author\" content=\"Ujwala\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ujwala\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/\",\"name\":\"How To Create Backup Of A MySQL Database?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png\",\"datePublished\":\"2019-08-20T06:05:44+00:00\",\"dateModified\":\"2022-02-19T06:35:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\"},\"description\":\"This article features steps for creating backup of a MySQL database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png\",\"width\":880,\"height\":273,\"caption\":\"export\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create Backup Of A MySQL Database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\",\"name\":\"Ujwala\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g\",\"caption\":\"Ujwala\"},\"description\":\"My aim is to create enriching content on topics related to SEO, web hosting and social media. The idea is to elevate the readers to new levels of usability, accessibility and understanding.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/ujwala\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Create Backup Of A MySQL Database?","description":"This article features steps for creating backup of a MySQL database.","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.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/","og_locale":"en_GB","og_type":"article","og_title":"How To Create Backup Of A MySQL Database?","og_description":"This article features steps for creating backup of a MySQL database.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2019-08-20T06:05:44+00:00","article_modified_time":"2022-02-19T06:35:48+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png","type":"","width":"","height":""}],"author":"Ujwala","twitter_misc":{"Written by":"Ujwala","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/","name":"How To Create Backup Of A MySQL Database?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png","datePublished":"2019-08-20T06:05:44+00:00","dateModified":"2022-02-19T06:35:48+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8"},"description":"This article features steps for creating backup of a MySQL database.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/08\/export.png","width":880,"height":273,"caption":"export"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-backup-of-a-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How To Create Backup Of A MySQL Database?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8","name":"Ujwala","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g","caption":"Ujwala"},"description":"My aim is to create enriching content on topics related to SEO, web hosting and social media. The idea is to elevate the readers to new levels of usability, accessibility and understanding.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/ujwala\/"}]}},"views":591,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=6342"}],"version-history":[{"count":3,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6342\/revisions"}],"predecessor-version":[{"id":13781,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/6342\/revisions\/13781"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=6342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=6342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=6342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}