{"id":7109,"date":"2020-02-06T06:38:32","date_gmt":"2020-02-06T06:38:32","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=7109"},"modified":"2022-02-18T13:30:59","modified_gmt":"2022-02-18T13:30:59","slug":"learn-to-import-a-mysql-database-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/","title":{"rendered":"Learn to import a MySQL Database in cPanel"},"content":{"rendered":"<p>Importing a database is important when you want to undertake disaster recovery or in case you wish to migrate your website to a new hosting solution. Before you start with the process, first make sure that you need to create a database backup to import.<\/p>\n<p><strong>Perform the following steps to import a database backup :<\/strong><\/p>\n<p>1) Log in to your <strong>cPanel<\/strong> account.<\/p>\n<p>2) Scroll down to the <strong>Databases<\/strong> section and select <strong>phpMyAdmin<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13766\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png\" alt=\"database1\" width=\"957\" height=\"196\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png 957w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1-300x61.png 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1-768x157.png 768w\" sizes=\"auto, (max-width: 957px) 100vw, 957px\" \/><\/a><\/p>\n<p>3) On the <strong>phpMyAdmin page<\/strong>, click on the <strong>Import<\/strong> tab at the top of the page.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database2.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13767\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database2.jpg\" alt=\"database2\" width=\"1331\" height=\"441\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database2.jpg 1331w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database2-300x99.jpg 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database2-1024x339.jpg 1024w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database2-768x254.jpg 768w\" sizes=\"auto, (max-width: 1331px) 100vw, 1331px\" \/><\/a><\/p>\n<p>4) The import page gets open. On this page, go to the <strong>File to import<\/strong> section at the top, and click on the <strong>Choose file<\/strong> button. A dialogue box gets open from where you can find the <strong>database backup file<\/strong> that you wish to import from your device.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13769\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database3.png\" alt=\"database3\" width=\"1024\" height=\"333\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database3.png 1024w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database3-300x98.png 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database3-768x250.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>5) After choosing the file that you want to import, leave the below settings with their default values (as in the below images) and click on the <strong>Go<\/strong>.<\/p>\n<p>That&#8217;s it.<\/p>\n<p><strong>Also Read :<\/strong><\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-can-i-check-a-mysql-database-for-errors-in-cpanel\/\" target=\"_blank\" rel=\"noopener\"><strong>1)\u00a0How Can I Check a MySQL Database for Errors in cPanel?<\/strong><\/a><\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-resolve-mysql-passwords-do-not-work-after-upgrade-error\/\" target=\"_blank\" rel=\"noopener\"><strong>2)\u00a0How to Resolve \u201cMySQL passwords do not work after upgrade\u201d Error?<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Importing a database is important when you want to undertake disaster recovery or in case you wish to migrate your website to a new hosting solution. Before you start with the process, first make sure that you need to create a database backup to import. Perform the following steps to import a database backup : [&hellip;]<\/p>\n","protected":false},"author":18,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[152,1154,1244,205],"class_list":["post-7109","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-cpanel-faq","tag-cpanel","tag-import-mysql-database","tag-import-mysql-database-in-cpanel","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Learn to import a MySQL Database in cPanel - Web Hosting FAQs by MilesWeb<\/title>\n<meta name=\"description\" content=\"A simple guide on to import MySQL database in cPanel.\" \/>\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\/learn-to-import-a-mysql-database-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn to import a MySQL Database in cPanel - Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"og:description\" content=\"A simple guide on to import MySQL database in cPanel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-06T06:38:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-18T13:30:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png\" \/>\n<meta name=\"author\" content=\"Sonam Wagh\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sonam Wagh\" \/>\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\/learn-to-import-a-mysql-database-in-cpanel\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/\",\"name\":\"Learn to import a MySQL Database in cPanel - Web Hosting FAQs by MilesWeb\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png\",\"datePublished\":\"2020-02-06T06:38:32+00:00\",\"dateModified\":\"2022-02-18T13:30:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\"},\"description\":\"A simple guide on to import MySQL database in cPanel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png\",\"width\":957,\"height\":196,\"caption\":\"database1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn to import a MySQL Database in cPanel\"}]},{\"@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\/dc645d02823c86e07e53798ebe02c6f4\",\"name\":\"Sonam Wagh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g\",\"caption\":\"Sonam Wagh\"},\"description\":\"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/sonam\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn to import a MySQL Database in cPanel - Web Hosting FAQs by MilesWeb","description":"A simple guide on to import MySQL database in cPanel.","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\/learn-to-import-a-mysql-database-in-cpanel\/","og_locale":"en_GB","og_type":"article","og_title":"Learn to import a MySQL Database in cPanel - Web Hosting FAQs by MilesWeb","og_description":"A simple guide on to import MySQL database in cPanel.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2020-02-06T06:38:32+00:00","article_modified_time":"2022-02-18T13:30:59+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png","type":"","width":"","height":""}],"author":"Sonam Wagh","twitter_misc":{"Written by":"Sonam Wagh","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/","name":"Learn to import a MySQL Database in cPanel - Web Hosting FAQs by MilesWeb","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png","datePublished":"2020-02-06T06:38:32+00:00","dateModified":"2022-02-18T13:30:59+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4"},"description":"A simple guide on to import MySQL database in cPanel.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/02\/database1.png","width":957,"height":196,"caption":"database1"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-import-a-mysql-database-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"Learn to import a MySQL Database in cPanel"}]},{"@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\/dc645d02823c86e07e53798ebe02c6f4","name":"Sonam Wagh","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g","caption":"Sonam Wagh"},"description":"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/sonam\/"}]}},"views":554,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7109","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\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=7109"}],"version-history":[{"count":3,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7109\/revisions"}],"predecessor-version":[{"id":13770,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7109\/revisions\/13770"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=7109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=7109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=7109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}