{"id":1855,"date":"2012-08-01T12:30:06","date_gmt":"2012-08-01T12:30:06","guid":{"rendered":"http:\/\/sgis.co.uk\/blog\/?p=1855"},"modified":"2012-08-01T12:33:28","modified_gmt":"2012-08-01T12:33:28","slug":"mysql-upgrade","status":"publish","type":"post","link":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/","title":{"rendered":"MySQL upgrade"},"content":{"rendered":"<p>Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to improve performance and security. Full information on the upgrade can be found via the official MySQL website here: <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/upgrading-from-previous-series.html\" target=\"_blank\">http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/upgrading-from-previous-series.html<\/a><\/p>\n<p>The upgrade will affect fewer than 0.1% of our customers and these customers should already be aware as the errors would have been flagged silently on MySQL version 5.1.<\/p>\n<p>If you aren&#8217;t receiving any MySQL errors after the upgrade is complete then there is nothing you need to do. If you are receiving MySQL errors after the upgrade please <a href=\"https:\/\/sgis.co.uk\/secure\/contact-support\">contact support<\/a> for assistance. You can view the upgrade process via our system status page here <a href=\"http:\/\/sgis.co.uk\/system_status.php\" target=\"_blank\">http:\/\/sgis.co.uk\/system_status.php<\/a><\/p>\n<p>Please <a href=\"https:\/\/sgis.co.uk\/secure\/contact-support\">contact support<\/a> if you have any questions.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to &#8230;<\/p>\n<p><a href=\"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/\" target=\"_top\">Read article<\/a><\/p>\n","protected":false},"author":1,"featured_media":346,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,45],"tags":[77],"class_list":["post-1855","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-latest-news","category-site-changes","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to improve performance and security.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"SGIS\"\/>\n\t<meta name=\"keywords\" content=\"mysql\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"SGIS web hosting blog | Web hosting updates and advice\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Upgrading MySQL from 5.1.57 to 5.5.25a | SGIS updates &amp; advice\" \/>\n\t\t<meta property=\"og:description\" content=\"Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to improve performance and security.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2012-08-01T12:30:06+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2012-08-01T12:33:28+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Upgrading MySQL from 5.1.57 to 5.5.25a | SGIS updates &amp; advice\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to improve performance and security.\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#article\",\"name\":\"Upgrading MySQL from 5.1.57 to 5.5.25a | SGIS updates & advice\",\"headline\":\"MySQL upgrade\",\"author\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/author\\\/sgadmin\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2011\\\/06\\\/newslogo.png\",\"width\":186,\"height\":186},\"datePublished\":\"2012-08-01T12:30:06+00:00\",\"dateModified\":\"2012-08-01T12:33:28+00:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#webpage\"},\"articleSection\":\"SGIS News, Site changes and updates, MySQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sgis.co.uk\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/category\\\/latest-news\\\/#listItem\",\"name\":\"SGIS News\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/category\\\/latest-news\\\/#listItem\",\"position\":2,\"name\":\"SGIS News\",\"item\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/category\\\/latest-news\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#listItem\",\"name\":\"MySQL upgrade\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#listItem\",\"position\":3,\"name\":\"MySQL upgrade\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/category\\\/latest-news\\\/#listItem\",\"name\":\"SGIS News\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/#organization\",\"name\":\"SGIS Hosting\",\"description\":\"Web hosting updates and advice\",\"url\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/logo.png\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#organizationLogo\",\"width\":250,\"height\":250},\"image\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/author\\\/sgadmin\\\/#author\",\"url\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/author\\\/sgadmin\\\/\",\"name\":\"SGIS\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c35932044581e2e15da4796e5adf8e22f5cd6b2a2e65dd6e7684636ab187e609?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"SGIS\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#webpage\",\"url\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/\",\"name\":\"Upgrading MySQL from 5.1.57 to 5.5.25a | SGIS updates & advice\",\"description\":\"Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to improve performance and security.\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/author\\\/sgadmin\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/author\\\/sgadmin\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2011\\\/06\\\/newslogo.png\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#mainImage\",\"width\":186,\"height\":186},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/2012\\\/08\\\/mysql-upgrade\\\/#mainImage\"},\"datePublished\":\"2012-08-01T12:30:06+00:00\",\"dateModified\":\"2012-08-01T12:33:28+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/\",\"name\":\"SGIS web hosting blog\",\"description\":\"Web hosting updates and advice\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/sgis.co.uk\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Upgrading MySQL from 5.1.57 to 5.5.25a | SGIS updates & advice","description":"Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to improve performance and security.","canonical_url":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/","robots":"max-image-preview:large","keywords":"mysql","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#article","name":"Upgrading MySQL from 5.1.57 to 5.5.25a | SGIS updates & advice","headline":"MySQL upgrade","author":{"@id":"https:\/\/sgis.co.uk\/blog\/author\/sgadmin\/#author"},"publisher":{"@id":"https:\/\/sgis.co.uk\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/sgis.co.uk\/blog\/wp-content\/uploads\/2011\/06\/newslogo.png","width":186,"height":186},"datePublished":"2012-08-01T12:30:06+00:00","dateModified":"2012-08-01T12:33:28+00:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#webpage"},"isPartOf":{"@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#webpage"},"articleSection":"SGIS News, Site changes and updates, MySQL"},{"@type":"BreadcrumbList","@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/sgis.co.uk\/blog#listItem","position":1,"name":"Home","item":"https:\/\/sgis.co.uk\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/sgis.co.uk\/blog\/category\/latest-news\/#listItem","name":"SGIS News"}},{"@type":"ListItem","@id":"https:\/\/sgis.co.uk\/blog\/category\/latest-news\/#listItem","position":2,"name":"SGIS News","item":"https:\/\/sgis.co.uk\/blog\/category\/latest-news\/","nextItem":{"@type":"ListItem","@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#listItem","name":"MySQL upgrade"},"previousItem":{"@type":"ListItem","@id":"https:\/\/sgis.co.uk\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#listItem","position":3,"name":"MySQL upgrade","previousItem":{"@type":"ListItem","@id":"https:\/\/sgis.co.uk\/blog\/category\/latest-news\/#listItem","name":"SGIS News"}}]},{"@type":"Organization","@id":"https:\/\/sgis.co.uk\/blog\/#organization","name":"SGIS Hosting","description":"Web hosting updates and advice","url":"https:\/\/sgis.co.uk\/blog\/","logo":{"@type":"ImageObject","url":"https:\/\/sgis.co.uk\/blog\/wp-content\/uploads\/2024\/03\/logo.png","@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#organizationLogo","width":250,"height":250},"image":{"@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/sgis.co.uk\/blog\/author\/sgadmin\/#author","url":"https:\/\/sgis.co.uk\/blog\/author\/sgadmin\/","name":"SGIS","image":{"@type":"ImageObject","@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/c35932044581e2e15da4796e5adf8e22f5cd6b2a2e65dd6e7684636ab187e609?s=96&d=mm&r=g","width":96,"height":96,"caption":"SGIS"}},{"@type":"WebPage","@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#webpage","url":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/","name":"Upgrading MySQL from 5.1.57 to 5.5.25a | SGIS updates & advice","description":"Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to improve performance and security.","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/sgis.co.uk\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#breadcrumblist"},"author":{"@id":"https:\/\/sgis.co.uk\/blog\/author\/sgadmin\/#author"},"creator":{"@id":"https:\/\/sgis.co.uk\/blog\/author\/sgadmin\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/sgis.co.uk\/blog\/wp-content\/uploads\/2011\/06\/newslogo.png","@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#mainImage","width":186,"height":186},"primaryImageOfPage":{"@id":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/#mainImage"},"datePublished":"2012-08-01T12:30:06+00:00","dateModified":"2012-08-01T12:33:28+00:00"},{"@type":"WebSite","@id":"https:\/\/sgis.co.uk\/blog\/#website","url":"https:\/\/sgis.co.uk\/blog\/","name":"SGIS web hosting blog","description":"Web hosting updates and advice","inLanguage":"en-US","publisher":{"@id":"https:\/\/sgis.co.uk\/blog\/#organization"}}]},"og:locale":"en_US","og:site_name":"SGIS web hosting blog | Web hosting updates and advice","og:type":"article","og:title":"Upgrading MySQL from 5.1.57 to 5.5.25a | SGIS updates &amp; advice","og:description":"Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to improve performance and security.","og:url":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/","article:published_time":"2012-08-01T12:30:06+00:00","article:modified_time":"2012-08-01T12:33:28+00:00","twitter:card":"summary","twitter:title":"Upgrading MySQL from 5.1.57 to 5.5.25a | SGIS updates &amp; advice","twitter:description":"Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to improve performance and security."},"aioseo_meta_data":{"post_id":"1855","title":"Upgrading MySQL from 5.1.57 to 5.5.25a | SGIS updates &amp; advice","description":"Over the next few weeks we will be upgrading MySQL from version 5.1.57 to 5.5.25a. This upgrade is needed to improve performance and security.","keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-07-05 09:39:45","updated":"2022-11-09 00:05:48","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/sgis.co.uk\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/sgis.co.uk\/blog\/category\/latest-news\/\" title=\"SGIS News\">SGIS News<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMySQL upgrade\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/sgis.co.uk\/blog"},{"label":"SGIS News","link":"https:\/\/sgis.co.uk\/blog\/category\/latest-news\/"},{"label":"MySQL upgrade","link":"https:\/\/sgis.co.uk\/blog\/2012\/08\/mysql-upgrade\/"}],"_links":{"self":[{"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/posts\/1855","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=1855"}],"version-history":[{"count":5,"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/posts\/1855\/revisions"}],"predecessor-version":[{"id":1859,"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/posts\/1855\/revisions\/1859"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/media\/346"}],"wp:attachment":[{"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=1855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=1855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sgis.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=1855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}