{"id":9623,"date":"2016-09-07T13:19:04","date_gmt":"2016-09-07T12:19:04","guid":{"rendered":"https:\/\/myworldofit.net\/?p=9623"},"modified":"2017-08-18T20:23:35","modified_gmt":"2017-08-18T19:23:35","slug":"upgrading-mysql-community-server-from-5-1-to-5-5-on-windows","status":"publish","type":"post","link":"https:\/\/myworldofit.net\/?p=9623","title":{"rendered":"Upgrading MySQL Community Server from 5.1 to 5.5 on Windows"},"content":{"rendered":"<p>In this guide I&#8217;ll show a &#8216;working&#8217; method to upgrade from MySQL Server 5.1 to 5.5 on a Windows Server 2008 R2 machine. In this case MySQL Server 5.1 was installed by the Microsoft Web Platform Installer some time ago, however&nbsp;this version doesn&#8217;t deliver very good performance (and its horribly outdated!) so it was time to get it replaced.<\/p>\n<p>The good chaps at MySQL do offer a guide on how to do this on their website &#8211;&nbsp;<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/windows-upgrading.html\">https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/windows-upgrading.html<\/a> however I hope you will find this one will serve you better.<\/p>\n<p>A few points to note before we continue&#8230;.<\/p>\n<ul>\n<li>This guide assumes you are using a default install of MySQL Server 5.1 (as delivered by the Microsoft Web Platform Installer)<\/li>\n<li>This guide only looks at a &#8216;simple&#8217; server deployment i.e. no clustering or other funky features are in use<\/li>\n<li>It is recommended to jump only one version at a time when going from MySQL version to version e.g. 5.1 to 5.5 (there were no 5.2, 5.3 or 5.4 versions) and then 5.5 to 5.6 and 5.6 to 5.7&#8230;<\/li>\n<li>You can download previous versions of MySQL Server from this link &#8211;&nbsp;<a href=\"http:\/\/dev.mysql.com\/downloads\/mysql\/\">http:\/\/dev.mysql.com\/downloads\/mysql\/<\/a> just click on the &#8216;Looking for previous GA versions?&#8217; link<\/li>\n<li>Be sure to take a backup of your databases before you attempt this guide on a production machine (see&nbsp;<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/backup-methods.html\">https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/backup-methods.html<\/a> for some ideas on how to do this)<\/li>\n<li>If possible run through the upgrade process a few times on a testing machine (one that you can break and no one will notice) first<\/li>\n<\/ul>\n<p>So on with the guide!<\/p>\n<p><!-- default-view.php -->\n<div\n\tclass=\"ngg-galleryoverview default-view\n\t ngg-ajax-pagination-none\t\"\n\tid=\"ngg-gallery-a83d0b8cf546cc47e40441271823b9ee-1\"\n\tdata-gallery-id=\"138\">\n\n\t\t<!-- Thumbnails -->\n\t\t\t\t<div id=\"ngg-image-0\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/1.PNG\"\n\t\t\t\ttitle=\"So starting out we have a MySQL server running v5.1 here showing a database (in PHPMyAdmin) called jimbob that will be coming over in the migration.\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/1.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_1.PNG\"\n\t\t\t\tdata-image-id=\"1137\"\n\t\t\t\tdata-title=\"1\"\n\t\t\t\tdata-description=\"So starting out we have a MySQL server running v5.1 here showing a database (in PHPMyAdmin) called jimbob that will be coming over in the migration.\"\n\t\t\t\tdata-image-slug=\"1-14\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"1\"\n\t\t\t\t\talt=\"1\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_1.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-1\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/2.PNG\"\n\t\t\t\ttitle=\"On the desktop we have the downloaded MySQL Server v5.5 and have the installer ready to go (with its 5.6 and 5.7 brothers).\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/2.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_2.PNG\"\n\t\t\t\tdata-image-id=\"1138\"\n\t\t\t\tdata-title=\"2\"\n\t\t\t\tdata-description=\"On the desktop we have the downloaded MySQL Server v5.5 and have the installer ready to go (with its 5.6 and 5.7 brothers).\"\n\t\t\t\tdata-image-slug=\"2-14\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"2\"\n\t\t\t\t\talt=\"2\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_2.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-2\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/3.PNG\"\n\t\t\t\ttitle=\"In this first step head to an administrative command prompt and stop the current MySQL Server service (in this case with the command net stop mysql).\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/3.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_3.PNG\"\n\t\t\t\tdata-image-id=\"1139\"\n\t\t\t\tdata-title=\"3\"\n\t\t\t\tdata-description=\"In this first step head to an administrative command prompt and stop the current MySQL Server service (in this case with the command net stop mysql).\"\n\t\t\t\tdata-image-slug=\"3-14\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"3\"\n\t\t\t\t\talt=\"3\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_3.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-3\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/4.PNG\"\n\t\t\t\ttitle=\"With the service stopped lets have a look at the database...in C &gt; ProgramData (its there just hidden) &gt; MySQL &gt; MySQL Server 5.1 &gt; data we can see the jimbob database.\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/4.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_4.PNG\"\n\t\t\t\tdata-image-id=\"1140\"\n\t\t\t\tdata-title=\"4\"\n\t\t\t\tdata-description=\"With the service stopped lets have a look at the database...in C &gt; ProgramData (its there just hidden) &gt; MySQL &gt; MySQL Server 5.1 &gt; data we can see the jimbob database.\"\n\t\t\t\tdata-image-slug=\"4-14\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"4\"\n\t\t\t\t\talt=\"4\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_4.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-4\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/5.PNG\"\n\t\t\t\ttitle=\"Head up one level and take a copy of that data folder (just in case anything goes horribly wrong!)\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/5.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_5.PNG\"\n\t\t\t\tdata-image-id=\"1141\"\n\t\t\t\tdata-title=\"5\"\n\t\t\t\tdata-description=\"Head up one level and take a copy of that data folder (just in case anything goes horribly wrong!)\"\n\t\t\t\tdata-image-slug=\"5-14\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"5\"\n\t\t\t\t\talt=\"5\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_5.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-5\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/6.PNG\"\n\t\t\t\ttitle=\"Next remove the currently installed MySQL service - to do this open an administrative command prompt and run the command in the screenshot above.\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/6.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_6.PNG\"\n\t\t\t\tdata-image-id=\"1142\"\n\t\t\t\tdata-title=\"6\"\n\t\t\t\tdata-description=\"Next remove the currently installed MySQL service - to do this open an administrative command prompt and run the command in the screenshot above.\"\n\t\t\t\tdata-image-slug=\"6-14\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"6\"\n\t\t\t\t\talt=\"6\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_6.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-6\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/7.PNG\"\n\t\t\t\ttitle=\"With that done fire up the MySQL Server v5.5 installer...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/7.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_7.PNG\"\n\t\t\t\tdata-image-id=\"1143\"\n\t\t\t\tdata-title=\"7\"\n\t\t\t\tdata-description=\"With that done fire up the MySQL Server v5.5 installer...\"\n\t\t\t\tdata-image-slug=\"7-13\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"7\"\n\t\t\t\t\talt=\"7\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_7.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-7\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/8.PNG\"\n\t\t\t\ttitle=\"You may will find that the current version has been detected, click the Add button...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/8.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_8.PNG\"\n\t\t\t\tdata-image-id=\"1144\"\n\t\t\t\tdata-title=\"8\"\n\t\t\t\tdata-description=\"You may will find that the current version has been detected, click the Add button...\"\n\t\t\t\tdata-image-slug=\"8-13\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"8\"\n\t\t\t\t\talt=\"8\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_8.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-8\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/9.PNG\"\n\t\t\t\ttitle=\"Accept the terms of the licencing agreement and click Next...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/9.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_9.PNG\"\n\t\t\t\tdata-image-id=\"1145\"\n\t\t\t\tdata-title=\"9\"\n\t\t\t\tdata-description=\"Accept the terms of the licencing agreement and click Next...\"\n\t\t\t\tdata-image-slug=\"9-13\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"9\"\n\t\t\t\t\talt=\"9\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_9.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-9\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/10.PNG\"\n\t\t\t\ttitle=\"Under the Available Products options find and add the latest version of MySQL Server - in this case the 64bit edition and click Next...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/10.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_10.PNG\"\n\t\t\t\tdata-image-id=\"1146\"\n\t\t\t\tdata-title=\"10\"\n\t\t\t\tdata-description=\"Under the Available Products options find and add the latest version of MySQL Server - in this case the 64bit edition and click Next...\"\n\t\t\t\tdata-image-slug=\"10-12\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"10\"\n\t\t\t\t\talt=\"10\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_10.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-10\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/11.PNG\"\n\t\t\t\ttitle=\"With everything ready to go click Execute...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/11.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_11.PNG\"\n\t\t\t\tdata-image-id=\"1117\"\n\t\t\t\tdata-title=\"11\"\n\t\t\t\tdata-description=\"With everything ready to go click Execute...\"\n\t\t\t\tdata-image-slug=\"11-12\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"11\"\n\t\t\t\t\talt=\"11\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_11.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-11\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/12.PNG\"\n\t\t\t\ttitle=\"After a short wait the server will be installed, click Next...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/12.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_12.PNG\"\n\t\t\t\tdata-image-id=\"1118\"\n\t\t\t\tdata-title=\"12\"\n\t\t\t\tdata-description=\"After a short wait the server will be installed, click Next...\"\n\t\t\t\tdata-image-slug=\"12-10\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"12\"\n\t\t\t\t\talt=\"12\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_12.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-12\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/13.PNG\"\n\t\t\t\ttitle=\"Time to get it configured, click Next...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/13.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_13.PNG\"\n\t\t\t\tdata-image-id=\"1119\"\n\t\t\t\tdata-title=\"13\"\n\t\t\t\tdata-description=\"Time to get it configured, click Next...\"\n\t\t\t\tdata-image-slug=\"13-9\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"13\"\n\t\t\t\t\talt=\"13\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_13.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-13\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/14.PNG\"\n\t\t\t\ttitle=\"Enter your choice of root password, to keep things simple I would suggest keeping it the same as the existing MySQL server root password and then changing it at a later date if required, once done click Next...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/14.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_14.PNG\"\n\t\t\t\tdata-image-id=\"1120\"\n\t\t\t\tdata-title=\"14\"\n\t\t\t\tdata-description=\"Enter your choice of root password, to keep things simple I would suggest keeping it the same as the existing MySQL server root password and then changing it at a later date if required, once done click Next...\"\n\t\t\t\tdata-image-slug=\"14-9\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"14\"\n\t\t\t\t\talt=\"14\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_14.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-14\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/15.PNG\"\n\t\t\t\ttitle=\"Leave the options as the defaults and click Next....\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/15.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_15.PNG\"\n\t\t\t\tdata-image-id=\"1121\"\n\t\t\t\tdata-title=\"15\"\n\t\t\t\tdata-description=\"Leave the options as the defaults and click Next....\"\n\t\t\t\tdata-image-slug=\"15-7\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"15\"\n\t\t\t\t\talt=\"15\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_15.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-15\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/17.PNG\"\n\t\t\t\ttitle=\"Kick off the application of the configuration and once done click Finish.\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/17.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_17.PNG\"\n\t\t\t\tdata-image-id=\"1122\"\n\t\t\t\tdata-title=\"17\"\n\t\t\t\tdata-description=\"Kick off the application of the configuration and once done click Finish.\"\n\t\t\t\tdata-image-slug=\"17-3\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"17\"\n\t\t\t\t\talt=\"17\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_17.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-16\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/18.PNG\"\n\t\t\t\ttitle=\"With everything configured click Next....\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/18.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_18.PNG\"\n\t\t\t\tdata-image-id=\"1123\"\n\t\t\t\tdata-title=\"18\"\n\t\t\t\tdata-description=\"With everything configured click Next....\"\n\t\t\t\tdata-image-slug=\"18-3\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"18\"\n\t\t\t\t\talt=\"18\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_18.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-17\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/19.PNG\"\n\t\t\t\ttitle=\"and finally Finish.\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/19.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_19.PNG\"\n\t\t\t\tdata-image-id=\"1124\"\n\t\t\t\tdata-title=\"19\"\n\t\t\t\tdata-description=\"and finally Finish.\"\n\t\t\t\tdata-image-slug=\"19-2\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"19\"\n\t\t\t\t\talt=\"19\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_19.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-18\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/20.PNG\"\n\t\t\t\ttitle=\"You may then be prompted to Update the Catalog, feel free to click the Cancel button at this stage.\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/20.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_20.PNG\"\n\t\t\t\tdata-image-id=\"1125\"\n\t\t\t\tdata-title=\"20\"\n\t\t\t\tdata-description=\"You may then be prompted to Update the Catalog, feel free to click the Cancel button at this stage.\"\n\t\t\t\tdata-image-slug=\"20-2\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"20\"\n\t\t\t\t\talt=\"20\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_20.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-19\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/23.PNG\"\n\t\t\t\ttitle=\"As you may have noticed the installation will have started the MySQL55 service, before we copy in our old database head back to an administrative command prompt and run net stop mysql55.\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/23.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_23.PNG\"\n\t\t\t\tdata-image-id=\"1147\"\n\t\t\t\tdata-title=\"23\"\n\t\t\t\tdata-description=\"As you may have noticed the installation will have started the MySQL55 service, before we copy in our old database head back to an administrative command prompt and run net stop mysql55.\"\n\t\t\t\tdata-image-slug=\"23-1\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"23\"\n\t\t\t\t\talt=\"23\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_23.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-20\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/21.PNG\"\n\t\t\t\ttitle=\"Back to the good bit! Head back to that data folder in the MySQL Server 5.1 folder and copy the entire folder....\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/21.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_21.PNG\"\n\t\t\t\tdata-image-id=\"1126\"\n\t\t\t\tdata-title=\"21\"\n\t\t\t\tdata-description=\"Back to the good bit! Head back to that data folder in the MySQL Server 5.1 folder and copy the entire folder....\"\n\t\t\t\tdata-image-slug=\"21-2\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"21\"\n\t\t\t\t\talt=\"21\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_21.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-21\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/22.PNG\"\n\t\t\t\ttitle=\"This time in the C &gt; ProgramData &gt; MySQL &gt; MySQL Server 5.5 folder paste\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/22.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_22.PNG\"\n\t\t\t\tdata-image-id=\"1127\"\n\t\t\t\tdata-title=\"22\"\n\t\t\t\tdata-description=\"This time in the C &gt; ProgramData &gt; MySQL &gt; MySQL Server 5.5 folder paste\"\n\t\t\t\tdata-image-slug=\"22-1\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"22\"\n\t\t\t\t\talt=\"22\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_22.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-22\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/24.PNG\"\n\t\t\t\ttitle=\"You will be prompted to confirm that you wish to copy over the existing data folder, click Yes...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/24.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_24.PNG\"\n\t\t\t\tdata-image-id=\"1129\"\n\t\t\t\tdata-title=\"24\"\n\t\t\t\tdata-description=\"You will be prompted to confirm that you wish to copy over the existing data folder, click Yes...\"\n\t\t\t\tdata-image-slug=\"24-1\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"24\"\n\t\t\t\t\talt=\"24\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_24.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-23\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/25.PNG\"\n\t\t\t\ttitle=\"and choose Copy and Replace for any existing conflicts...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/25.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_25.PNG\"\n\t\t\t\tdata-image-id=\"1130\"\n\t\t\t\tdata-title=\"25\"\n\t\t\t\tdata-description=\"and choose Copy and Replace for any existing conflicts...\"\n\t\t\t\tdata-image-slug=\"25-1\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"25\"\n\t\t\t\t\talt=\"25\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_25.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-24\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/26.PNG\"\n\t\t\t\ttitle=\"Before starting the mysql55 service delete the ib_logfile0 and ib_logfile1 files within the data folder...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/26.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_26.PNG\"\n\t\t\t\tdata-image-id=\"1131\"\n\t\t\t\tdata-title=\"26\"\n\t\t\t\tdata-description=\"Before starting the mysql55 service delete the ib_logfile0 and ib_logfile1 files within the data folder...\"\n\t\t\t\tdata-image-slug=\"26-1\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"26\"\n\t\t\t\t\talt=\"26\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_26.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-25\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/27.PNG\"\n\t\t\t\ttitle=\"Time to get the mysql55 service running again, this time using net start mysql55 from an administrative command prompt.\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/27.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_27.PNG\"\n\t\t\t\tdata-image-id=\"1132\"\n\t\t\t\tdata-title=\"27\"\n\t\t\t\tdata-description=\"Time to get the mysql55 service running again, this time using net start mysql55 from an administrative command prompt.\"\n\t\t\t\tdata-image-slug=\"27\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"27\"\n\t\t\t\t\talt=\"27\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_27.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-26\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/28.PNG\"\n\t\t\t\ttitle=\"Finally you will need to use the mysql_upgrade.exe application in the MySQL Server 5.5 folder (in Program Files) to patch the databases you have copied over from the previous install to the 5.5 standard, to do this use the command in the screenshot above, once you hit enter you will be prompted for your root password.....\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/28.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_28.PNG\"\n\t\t\t\tdata-image-id=\"1133\"\n\t\t\t\tdata-title=\"28\"\n\t\t\t\tdata-description=\"Finally you will need to use the mysql_upgrade.exe application in the MySQL Server 5.5 folder (in Program Files) to patch the databases you have copied over from the previous install to the 5.5 standard, to do this use the command in the screenshot above, once you hit enter you will be prompted for your root password.....\"\n\t\t\t\tdata-image-slug=\"28\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"28\"\n\t\t\t\t\talt=\"28\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_28.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-27\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/30.PNG\"\n\t\t\t\ttitle=\"Once everything has migrated over (and that you have tested that your MySQL databases work as expected)...\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/30.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_30.PNG\"\n\t\t\t\tdata-image-id=\"1134\"\n\t\t\t\tdata-title=\"30\"\n\t\t\t\tdata-description=\"Once everything has migrated over (and that you have tested that your MySQL databases work as expected)...\"\n\t\t\t\tdata-image-slug=\"30\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"30\"\n\t\t\t\t\talt=\"30\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_30.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-28\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/31.PNG\"\n\t\t\t\ttitle=\"...feel free to delete the old version of MySQL Server from your server.\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/31.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_31.PNG\"\n\t\t\t\tdata-image-id=\"1135\"\n\t\t\t\tdata-title=\"31\"\n\t\t\t\tdata-description=\"...feel free to delete the old version of MySQL Server from your server.\"\n\t\t\t\tdata-image-slug=\"31\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"31\"\n\t\t\t\t\talt=\"31\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_31.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\t\t\t<div id=\"ngg-image-29\" class=\"ngg-gallery-thumbnail-box\n\t\t\t\t\t\t\t\t\t\t\t\"\n\t\t\t>\n\t\t\t\t\t\t<div class=\"ngg-gallery-thumbnail\">\n\t\t\t<a href=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/32.PNG\"\n\t\t\t\ttitle=\"Just a final screenshot to show how PHPMyAdmin shows the new MySQL Server version :)\"\n\t\t\t\tdata-src=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/32.PNG\"\n\t\t\t\tdata-thumbnail=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_32.PNG\"\n\t\t\t\tdata-image-id=\"1136\"\n\t\t\t\tdata-title=\"32\"\n\t\t\t\tdata-description=\"Just a final screenshot to show how PHPMyAdmin shows the new MySQL Server version :)\"\n\t\t\t\tdata-image-slug=\"32\"\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tclass=\"ngg-fancybox\" rel=\"a83d0b8cf546cc47e40441271823b9ee\">\n\t\t\t\t\t\t\t\t<img\n\t\t\t\t\ttitle=\"32\"\n\t\t\t\t\talt=\"32\"\n\t\t\t\t\tsrc=\"https:\/\/myworldofit.net\/wp-content\/gallery\/mysql-5-1-to-5-5\/thumbs\/thumbs_32.PNG\"\n\t\t\t\t\twidth=\"100\"\n\t\t\t\t\theight=\"75\"\n\t\t\t\t\tstyle=\"max-width:100%;\"\n\t\t\t\t\/>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\n\t\n\t<br style=\"clear: both\" \/>\n\n\t\n\t\t<div class=\"ngg-clear\"><\/div>\n\t<\/div>\n<\/p>\n<p>Final point to note&#8230;.this guide only works with migrations to 5.5 from 5.1, if going to further versions you will be missing some tables which will in turn generate error messages during the upgrade process. More information on that here <a href=\"http:\/\/dba.stackexchange.com\/questions\/54608\/innodb-error-table-mysql-innodb-table-stats-not-found-after-upgrade-to-mys\">http:\/\/dba.stackexchange.com\/questions\/54608\/innodb-error-table-mysql-innodb-table-stats-not-found-after-upgrade-to-mys<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this guide I&#8217;ll show a &#8216;working&#8217; method to upgrade from MySQL Server 5.1 to 5.5 on a Windows Server 2008 R2 machine. In this case MySQL Server 5.1 was installed by the Microsoft Web Platform Installer some time ago, however&nbsp;this version doesn&#8217;t deliver very good performance (and its horribly outdated!) so it was time to get it replaced. The&#8230; <a class=\"read-more\" href=\"https:\/\/myworldofit.net\/?p=9623\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[11],"tags":[351,354,352,353],"series":[],"class_list":["post-9623","post","type-post","status-publish","format-standard","hentry","category-servers","tag-mysql","tag-mysql-community-server","tag-mysql-server","tag-upgrade"],"_links":{"self":[{"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/posts\/9623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myworldofit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9623"}],"version-history":[{"count":4,"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/posts\/9623\/revisions"}],"predecessor-version":[{"id":10439,"href":"https:\/\/myworldofit.net\/index.php?rest_route=\/wp\/v2\/posts\/9623\/revisions\/10439"}],"wp:attachment":[{"href":"https:\/\/myworldofit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myworldofit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myworldofit.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9623"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/myworldofit.net\/index.php?rest_route=%2Fwp%2Fv2%2Fseries&post=9623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}