{"id":106,"date":"2016-04-08T15:18:55","date_gmt":"2016-04-08T15:18:55","guid":{"rendered":"https:\/\/www.24x7serversupport.com\/24x7serversupport-blog\/?p=106"},"modified":"2016-04-08T15:18:55","modified_gmt":"2016-04-08T15:18:55","slug":"how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows","status":"publish","type":"post","link":"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/","title":{"rendered":"How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows"},"content":{"rendered":"<p>Ref. Link: <a href=\"https:\/\/kb.plesk.com\/en\/124139\">https:\/\/kb.plesk.com\/en\/124139<\/a><\/p>\n<p>Applies to:<\/p>\n<ul>\n<li>Plesk 12.0 for Windows<\/li>\n<li class=\"\">Plesk 11.5 for Windows<\/li>\n<li class=\"\">Plesk 10.4 for Windows<\/li>\n<\/ul>\n<h1><strong>Please note this instruction for client database server only. You cannot upgrade mysql server with Plesk database.<\/strong><\/h1>\n<p>You can use Mysql upgrade manual from vendor:<br \/>\n<a title=\"title\" href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/upgrading.html\">http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/upgrading.html<\/a><\/p>\n<p>Please do not forget to backup data before upgrade. In general instruction is the following:<\/p>\n<ul>\n<li>Create dump of database:<\/li>\n<\/ul>\n<blockquote><p>C:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL51\\bin&gt;mysqldump -uadmin -p**** -P3306 &#8211;all-databases &gt;all.dump<\/p><\/blockquote>\n<ul>\n<li>Download zip archive<\/li>\n<li>Create copy of the following folders, here client databases are saved:<\/li>\n<\/ul>\n<blockquote><p>C:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL<br \/>\nC:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL51<\/p><\/blockquote>\n<ul>\n<li>stop mysql service:<\/li>\n<\/ul>\n<blockquote><p>NET STOP MySQL<\/p><\/blockquote>\n<ul>\n<li>extract downloaded archive to C:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL51 overwriting the existing installation.<\/li>\n<li>start Mysql server<\/li>\n<\/ul>\n<blockquote><p>NET START MySQL<\/p><\/blockquote>\n<ul>\n<li>upgrade mysql:<\/li>\n<\/ul>\n<blockquote><p>C:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL51\\bin&gt;mysql_upgrade -uadmin -p**** -P3306<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Ref. Link: https:\/\/kb.plesk.com\/en\/124139 Applies to: Plesk 12.0 for Windows Plesk 11.5 for Windows Plesk 10.4 for Windows Please note this instruction for client database server only. You cannot upgrade mysql server with Plesk database. You can use Mysql upgrade manual from vendor: http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/upgrading.html Please do not forget to backup data before upgrade. In general instruction [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[37],"tags":[31,32],"class_list":["post-106","post","type-post","status-publish","format-standard","hentry","category-windows","tag-centos","tag-cpanel"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows \u2013 24x7serversupport-Blog<\/title>\n<meta name=\"description\" content=\"Visit us to learn How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows.\" \/>\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.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows \u2013 24x7serversupport-Blog\" \/>\n<meta property=\"og:description\" content=\"Visit us to learn How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/\" \/>\n<meta property=\"og:site_name\" content=\"24x7serversupport Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-08T15:18:55+00:00\" \/>\n<meta name=\"author\" content=\"24x7support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:site\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"24x7support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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\":\"WebPage\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/\",\"name\":\"How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows \u2013 24x7serversupport-Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\"},\"datePublished\":\"2016-04-08T15:18:55+00:00\",\"dateModified\":\"2016-04-08T15:18:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\"},\"description\":\"Visit us to learn How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.24x7serversupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/\",\"name\":\"24x7serversupport Blog\",\"description\":\"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\",\"name\":\"24x7support\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows \u2013 24x7serversupport-Blog","description":"Visit us to learn How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows.","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.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/","og_locale":"en_US","og_type":"article","og_title":"How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows \u2013 24x7serversupport-Blog","og_description":"Visit us to learn How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows.","og_url":"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/","og_site_name":"24x7serversupport Blog","article_published_time":"2016-04-08T15:18:55+00:00","author":"24x7support","twitter_card":"summary_large_image","twitter_creator":"@24x7serversuppo","twitter_site":"@24x7serversuppo","twitter_misc":{"Written by":"24x7support","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/","url":"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/","name":"How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows \u2013 24x7serversupport-Blog","isPartOf":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#website"},"datePublished":"2016-04-08T15:18:55+00:00","dateModified":"2016-04-08T15:18:55+00:00","author":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401"},"description":"Visit us to learn How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows.","breadcrumb":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.24x7serversupport.com\/blog\/how-to-upgrade-plesk-mysql-from-5-1-to-5-5-on-windows\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.24x7serversupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows"}]},{"@type":"WebSite","@id":"https:\/\/www.24x7serversupport.com\/blog\/#website","url":"https:\/\/www.24x7serversupport.com\/blog\/","name":"24x7serversupport Blog","description":"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401","name":"24x7support","url":"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=106"}],"version-history":[{"count":0,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/106\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}