{"id":301,"date":"2013-11-15T21:22:39","date_gmt":"2013-11-16T02:22:39","guid":{"rendered":"http:\/\/www.amixa.com\/blog\/?p=301"},"modified":"2016-06-06T15:15:59","modified_gmt":"2016-06-06T19:15:59","slug":"quick-and-easy-method-to-upgrade-mysql-community-edition","status":"publish","type":"post","link":"https:\/\/www.amixa.com\/blog\/2013\/11\/15\/quick-and-easy-method-to-upgrade-mysql-community-edition\/","title":{"rendered":"Quick and easy method to upgrade MySQL Community Edition – Windows Server"},"content":{"rendered":"

I recently crossed my fingers and went through the upgrade process to upgrade MySQL from 5.6.14 to 5.6.17 on my Windows server.\u00a0 (also works for 5.5.x to current)<\/p>\n

 <\/p>\n

NOTE – UPDATED 5\/27\/2016:\u00a0 If you are using the MYSQL Installer – Community (if that is in your Start -> program list, please use that to upgrade you instance.\u00a0 That is much simpler than my process below.\u00a0 The process below should now be considered a LEGACY process.<\/span><\/strong><\/span><\/p>\n

 <\/p>\n

Don’t forget to run<\/span><\/p>\n

mysql_upgrade -u root -p<\/span><\/p>\n

to allow MySQL to upgrade all the tables to the new standard.<\/span><\/p>\n

 <\/p>\n

Through trial and error, I have found the easiest process to do this.<\/p>\n

    \n
  1. stop the existing service via services<\/li>\n
  2. command prompt (as administrator)<\/li>\n
  3. change to the MySQL directory, BIN, and then type in\u00a0mysqld –remove<\/strong>\u00a0 (to remove the service)\n
      \n
    1. If the above command does not work, try using SC DELETE MYSQL\u00a0\u00a0\u00a0 (put the exact service name in place of MYSQL).\u00a0 That should do the trick.<\/li>\n
    2. go into the service manage and refresh and ensure the service is removed.<\/li>\n<\/ol>\n<\/li>\n
    3. go to the control panel and uninstall everything to do with MySQL (presuming this is on a dedicated MySQL box)<\/li>\n
    4. make sure your data is moved to a directory on the root like “MYSQLDATA”<\/li>\n
    5. delete every folder under programdata and program files pertaining to MySQL<\/li>\n
    6. reboot the machine<\/li>\n
    7. log into machine<\/li>\n
    8. make sure .NET Framework 4.0 is installed<\/li>\n
    9. download and run the MySQL Community 5.6.17 (or later) x32 MSI full installer<\/li>\n
    10. do a fresh install<\/li>\n
    11. Server type:\u00a0 Server\u00a0 (for production deployments)<\/li>\n
    12. point things to the correct directories (e.g. your existing data directory, etc.)<\/li>\n
    13. use the same root password as before (on the old install)<\/li>\n
    14. add any extra admin users<\/li>\n
    15. complete the install<\/li>\n
    16. make sure the service is complete<\/li>\n
    17. That’s it!<\/li>\n<\/ol>\n

      hope that helps someone else out there.\u00a0 I took the couple of hours to sort this all out for you!<\/p>\n","protected":false},"excerpt":{"rendered":"

      I recently crossed my fingers and went through the upgrade process to upgrade MySQL from 5.6.14 to 5.6.17 on my Windows server.\u00a0 (also works for 5.5.x to current)   NOTE – UPDATED 5\/27\/2016:\u00a0 If you are using the MYSQL Installer – Community (if that is in your Start -> program list, please use that to upgrade you instance.\u00a0 That is<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61,22],"tags":[8,104],"class_list":["post-301","post","type-post","status-publish","format-standard","hentry","category-mysql","category-windows-server","tag-microsoft-windows-server","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/comments?post=301"}],"version-history":[{"count":7,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/301\/revisions"}],"predecessor-version":[{"id":465,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/301\/revisions\/465"}],"wp:attachment":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/media?parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/categories?post=301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/tags?post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}