{"id":27,"date":"2015-02-19T13:06:46","date_gmt":"2015-02-19T13:06:46","guid":{"rendered":"http:\/\/eliteservermanagement.com\/issues\/?p=27"},"modified":"2019-11-01T08:09:52","modified_gmt":"2019-11-01T08:09:52","slug":"how-to-upgrade-mysql-with-cloudlinux-and-cpanel","status":"publish","type":"post","link":"https:\/\/eliteservermanagement.com\/issues\/how-to-upgrade-mysql-with-cloudlinux-and-cpanel\/","title":{"rendered":"How to upgrade mysql with cloudlinux and cpanel"},"content":{"rendered":"<p style=\"text-align: left;\">Using the mysql upgrade option in cpanel will not work with cloud Linux<\/p>\n<p style=\"text-align: left;\">Please make sure to take backup of mysql folder in tar as well as .sql format.<\/p>\n<p style=\"text-align: left;\">For upgrading to MySQL 5.5(for example), you should to do:<\/p>\n<p style=\"text-align: left;\">\/usr\/share\/lve\/dbgovernor\/db-select-mysql &#8211;mysql-version=mysql55<br \/>\n\/usr\/share\/lve\/dbgovernor\/db-select-mysql &#8211;install-now<\/p>\n<p style=\"text-align: left;\">That&#8217;s it<\/p>\n<p style=\"text-align: left;\">root@bima [~]# mysql -V<br \/>\nmysql Ver 14.14 Distrib 5.5.34, for Linux (x86_64) using readline 5.1<br \/>\nroot@bima [~]#<\/p>\n<p style=\"text-align: left;\">Recompile apache\/php after mysql upgrade.<\/p>\n<p style=\"text-align: left;\"><span style=\"color: black;\"><b>eLite Server Management<br \/>\n<\/b><\/span><span style=\"line-height: 1.5;\">&nbsp;We Specialize In cPanel Server Management<br \/>\nAffordable 24\/7 Technical Support Company<br \/>\n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Using the mysql upgrade option in cpanel will not work with cloud Linux Please make sure to take backup of mysql folder in tar as well as .sql format. For upgrading to MySQL 5.5(for example), you should to do: \/usr\/share\/lve\/dbgovernor\/db-select-mysql &#8211;mysql-version=mysql55 \/usr\/share\/lve\/dbgovernor\/db-select-mysql &#8211;install-now That&#8217;s it root@bima [~]# mysql -V mysql Ver 14.14 Distrib 5.5.34, for [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[13,12,6],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/eliteservermanagement.com\/issues\/wp-json\/wp\/v2\/posts\/27"}],"collection":[{"href":"https:\/\/eliteservermanagement.com\/issues\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eliteservermanagement.com\/issues\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eliteservermanagement.com\/issues\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eliteservermanagement.com\/issues\/wp-json\/wp\/v2\/comments?post=27"}],"version-history":[{"count":4,"href":"https:\/\/eliteservermanagement.com\/issues\/wp-json\/wp\/v2\/posts\/27\/revisions"}],"predecessor-version":[{"id":187,"href":"https:\/\/eliteservermanagement.com\/issues\/wp-json\/wp\/v2\/posts\/27\/revisions\/187"}],"wp:attachment":[{"href":"https:\/\/eliteservermanagement.com\/issues\/wp-json\/wp\/v2\/media?parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eliteservermanagement.com\/issues\/wp-json\/wp\/v2\/categories?post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eliteservermanagement.com\/issues\/wp-json\/wp\/v2\/tags?post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}