How to create a database in Plesk<\/a><\/p>\n2) Open up phpMyAdmin inside Plesk<\/p>\n
– Go to Databases<\/p>\n
– Select the Database<\/p>\n
– Go to Webadmin<\/p>\n
3) Once you are in phpMyAdmin, Select the Database on the left hand bar.<\/p>\n
4) Go to import<\/p>\n
5) Click the ‘Choose’ button to browse the location of the text file<\/p>\n
6) Click “Go” to import the SQL file<\/p>\n
If you experience any problems, please log a ticket with our Help Desk.<\/p>\n","protected":false},"excerpt":{"rendered":"
To import a MySQL database you can use phpMyAdmin which is available in your Plesk control panel. 1) Firstly, you will need \u00a0to create the database in Plesk that you would like to import the SQL file to. – Video tutorial:\u00a0How to create a database in Plesk 2) Open up phpMyAdmin inside Plesk – Go … Read more…<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":""},"categories":[79,63,61,36],"tags":[],"class_list":["post-1171","post","type-post","status-publish","format-standard","hentry","category-phpmyadmin-support","category-plesk-support","category-support","category-web-hosting"],"yoast_head":"\nHow to import a MySQL database using phpMyAdmin - UK-Cheapest.co.uk<\/title>\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.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to import a MySQL database using phpMyAdmin - UK-Cheapest.co.uk\" \/>\n<meta property=\"og:description\" content=\"To import a MySQL database you can use phpMyAdmin which is available in your Plesk control panel. 1) Firstly, you will need \u00a0to create the database in Plesk that you would like to import the SQL file to. – Video tutorial:\u00a0How to create a database in Plesk 2) Open up phpMyAdmin inside Plesk – Go ... Read more...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"UK-Cheapest.co.uk\" \/>\n<meta property=\"article:published_time\" content=\"2011-12-20T14:48:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2011-12-20T14:53:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/IMG_3064.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"439\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Tel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ukchelpdesk\" \/>\n<meta name=\"twitter:site\" content=\"@ukchelpdesk\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/how-to-import-a-mysql-database-using-phpmyadmin\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/how-to-import-a-mysql-database-using-phpmyadmin\\\/\"},\"author\":{\"name\":\"Tel\",\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/#\\\/schema\\\/person\\\/cc362846e073808e407707b0e9c1c567\"},\"headline\":\"How to import a MySQL database using phpMyAdmin\",\"datePublished\":\"2011-12-20T14:48:52+00:00\",\"dateModified\":\"2011-12-20T14:53:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/how-to-import-a-mysql-database-using-phpmyadmin\\\/\"},\"wordCount\":120,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/#organization\"},\"articleSection\":[\"phpMyAdmin\",\"Plesk\",\"Support\",\"Web Hosting\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/how-to-import-a-mysql-database-using-phpmyadmin\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/how-to-import-a-mysql-database-using-phpmyadmin\\\/\",\"url\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/how-to-import-a-mysql-database-using-phpmyadmin\\\/\",\"name\":\"How to import a MySQL database using phpMyAdmin - UK-Cheapest.co.uk\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/#website\"},\"datePublished\":\"2011-12-20T14:48:52+00:00\",\"dateModified\":\"2011-12-20T14:53:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/how-to-import-a-mysql-database-using-phpmyadmin\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/how-to-import-a-mysql-database-using-phpmyadmin\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/how-to-import-a-mysql-database-using-phpmyadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"UK-Cheapest.co.uk\",\"item\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to import a MySQL database using phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/#website\",\"url\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/\",\"name\":\"UK-Cheapest.co.uk\",\"description\":\"Cheap Domain Names, Web Hosting, Site Builder & Web Security\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/#organization\",\"name\":\"UKC\",\"url\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/Screenshot-2023-12-14-at-17.40.07.png\",\"contentUrl\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/Screenshot-2023-12-14-at-17.40.07.png\",\"width\":217,\"height\":55,\"caption\":\"UKC\"},\"image\":{\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/ukchelpdesk\",\"https:\\\/\\\/www.instagram.com\\\/ukc_hosting\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/#\\\/schema\\\/person\\\/cc362846e073808e407707b0e9c1c567\",\"name\":\"Tel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/255f677faa9a37d31442f1eff4b4857791ccc7bb017486164af8bf319a0255d2?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/255f677faa9a37d31442f1eff4b4857791ccc7bb017486164af8bf319a0255d2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/255f677faa9a37d31442f1eff4b4857791ccc7bb017486164af8bf319a0255d2?s=96&d=mm&r=g\",\"caption\":\"Tel\"},\"url\":\"https:\\\/\\\/www.uk-cheapest.co.uk\\\/support\\\/author\\\/tel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to import a MySQL database using phpMyAdmin - UK-Cheapest.co.uk","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.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/","og_locale":"en_GB","og_type":"article","og_title":"How to import a MySQL database using phpMyAdmin - UK-Cheapest.co.uk","og_description":"To import a MySQL database you can use phpMyAdmin which is available in your Plesk control panel. 1) Firstly, you will need \u00a0to create the database in Plesk that you would like to import the SQL file to. – Video tutorial:\u00a0How to create a database in Plesk 2) Open up phpMyAdmin inside Plesk – Go ... Read more...","og_url":"https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/","og_site_name":"UK-Cheapest.co.uk","article_published_time":"2011-12-20T14:48:52+00:00","article_modified_time":"2011-12-20T14:53:01+00:00","og_image":[{"width":768,"height":439,"url":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/IMG_3064.jpeg","type":"image\/jpeg"}],"author":"Tel","twitter_card":"summary_large_image","twitter_creator":"@ukchelpdesk","twitter_site":"@ukchelpdesk","twitter_misc":{"Written by":"Tel","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/"},"author":{"name":"Tel","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/person\/cc362846e073808e407707b0e9c1c567"},"headline":"How to import a MySQL database using phpMyAdmin","datePublished":"2011-12-20T14:48:52+00:00","dateModified":"2011-12-20T14:53:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/"},"wordCount":120,"commentCount":0,"publisher":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#organization"},"articleSection":["phpMyAdmin","Plesk","Support","Web Hosting"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/","url":"https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/","name":"How to import a MySQL database using phpMyAdmin - UK-Cheapest.co.uk","isPartOf":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#website"},"datePublished":"2011-12-20T14:48:52+00:00","dateModified":"2011-12-20T14:53:01+00:00","breadcrumb":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/how-to-import-a-mysql-database-using-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"UK-Cheapest.co.uk","item":"https:\/\/www.uk-cheapest.co.uk\/support\/"},{"@type":"ListItem","position":2,"name":"How to import a MySQL database using phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#website","url":"https:\/\/www.uk-cheapest.co.uk\/support\/","name":"UK-Cheapest.co.uk","description":"Cheap Domain Names, Web Hosting, Site Builder & Web Security","publisher":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.uk-cheapest.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#organization","name":"UKC","url":"https:\/\/www.uk-cheapest.co.uk\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-14-at-17.40.07.png","contentUrl":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-content\/uploads\/2023\/12\/Screenshot-2023-12-14-at-17.40.07.png","width":217,"height":55,"caption":"UKC"},"image":{"@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/ukchelpdesk","https:\/\/www.instagram.com\/ukc_hosting\/"]},{"@type":"Person","@id":"https:\/\/www.uk-cheapest.co.uk\/support\/#\/schema\/person\/cc362846e073808e407707b0e9c1c567","name":"Tel","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/255f677faa9a37d31442f1eff4b4857791ccc7bb017486164af8bf319a0255d2?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/255f677faa9a37d31442f1eff4b4857791ccc7bb017486164af8bf319a0255d2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/255f677faa9a37d31442f1eff4b4857791ccc7bb017486164af8bf319a0255d2?s=96&d=mm&r=g","caption":"Tel"},"url":"https:\/\/www.uk-cheapest.co.uk\/support\/author\/tel\/"}]}},"_links":{"self":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts\/1171","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/comments?post=1171"}],"version-history":[{"count":7,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts\/1171\/revisions"}],"predecessor-version":[{"id":1184,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/posts\/1171\/revisions\/1184"}],"wp:attachment":[{"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/media?parent=1171"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/categories?post=1171"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.uk-cheapest.co.uk\/support\/wp-json\/wp\/v2\/tags?post=1171"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}