{"id":535,"date":"2013-10-28T13:26:54","date_gmt":"2013-10-28T12:26:54","guid":{"rendered":"http:\/\/ndk.sytes.net\/wordpress\/?p=535"},"modified":"2013-10-28T13:26:54","modified_gmt":"2013-10-28T12:26:54","slug":"ensim-10-xcentos-5-10-upgrade-mysql-5-0-to-5-5","status":"publish","type":"post","link":"https:\/\/ndk.sytes.net\/wordpress\/?p=535","title":{"rendered":"Ensim 10.x\/CentOS 5.10: upgrade MySQL 5.0 to 5.5"},"content":{"rendered":"<p>\n\tHello,\n<\/p>\n<p>\n\tas you may have noticed, CentOS 5.10 has stopped upstream updates for its stock MySQL version which is stuck at version 5.0.95. They have added MySQL 5.5 now to their repository but these packages are installed in different locations and have other startup-scripts then the default stock version, so that they can be run at the same time, but that&#39;s not very compatible with Ensim and its database management. Therefore I wrote a small upgrade script which removes MySQL 5.0 and installs 5.5, taking care of Ensim&#39;s database structure. Here are some script requirements:\n<\/p>\n<ul>\n<li>\n\t\tpython 2.4+&nbsp;installed\n\t<\/li>\n<li>\n\t\t<a href=\"http:\/\/fedoraproject.org\/wiki\/EPEL\" target=\"_blank\">EPEL<\/a> and <a href=\"http:\/\/iuscommunity.org\/pages\/About.html\" target=\"_blank\">IUS<\/a> repositories installed\n\t<\/li>\n<li>\n\t\tall stock mysql55 packages excluded in yum (found in \/etc\/yum.repos.d\/CentOS-Base.repo)\n\t<\/li>\n<\/ul>\n<p>\n\tHere how to do the upgrade:\n<\/p>\n<ol>\n<li>\n\t\tdownload my script and place it wherever you want and unzip it\n\t<\/li>\n<li>\n\t\tcheck if all requirements above are fulfilled\n\t<\/li>\n<li>\n\t\tlaunch my script with:&nbsp;<em>python \/path\/to\/upgrade_ensim_mysql.py<\/em>\n\t<\/li>\n<li>\n\t\tedit<em> \/etc\/virtualhosting\/filelists\/mysql.sh<\/em> and add following lines to it:<br \/>\n\t\tN:S,rpm:mysql55<br \/>\n\t\tN:S,rpm:mysql55-server<br \/>\n\t\tN:S,rpm:mysql55-libs<br \/>\n\t\tN:S,rpm:mysqlclient15\n\t<\/li>\n<li>\n\t\tedit <em>\/etc\/init.d\/mysqld&nbsp;<\/em>and remove&nbsp;the parameters&nbsp;<em>&#8211;skip-bdb<\/em> and <em>&#8211;skip-innodb<\/em>\n\t<\/li>\n<li>\n\t\tnow restart your mysql server as usual and do an ensim maintenance\n\t<\/li>\n<\/ol>\n<p>\n\tFor all the admins who are sceptic about user programmed scripts, here is what it basically does:\n<\/p>\n<ul>\n<li>\n\t\tbackup old needed files<br \/>\n\t\t<em>\/etc\/my.cnf<\/em><br \/>\n\t\t<em>\/etc\/init.d\/mysqld_app_init<\/em><br \/>\n\t\tcomplete mysql dump to <em>\/root\/mysql_backup.sql<\/em>\n\t<\/li>\n<li>\n\t\tremoves mysql5.0 packages without their dependencies\n\t<\/li>\n<li>\n\t\tinstalls needed mysql55 packages\n\t<\/li>\n<li>\n\t\tunlinks all symlinks and relinks the databases<br \/>\n\t\tthis step is needed because&nbsp;mysql50 supported database names with &quot;-&quot; in it, mysql55 doesn&#39;t, thus the &quot;-&quot; is replaced by &quot;@002d&quot; in the symbolic link\n\t<\/li>\n<li>\n\t\tupgrades all database using mysql_upgrade\n\t<\/li>\n<\/ul>\n<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"Version 0.1\" href=\"https:\/\/ndk.sytes.net\/wordpress?download=993&amp;tmstv=1781904922\" rel=\"nofollow\" id=\"download-link-993\" data-redirect=\"false\" >\n\tEnsim MySQL Upgrader\t(897 downloads\t)\n<\/a>\n\n","protected":false},"excerpt":{"rendered":"<p>Hello, as you may have noticed, CentOS 5.10 has stopped upstream updates for its stock MySQL version which is stuck at version 5.0.95. They have added MySQL 5.5 now to their repository but these packages are installed in different locations and have other startup-scripts then the default stock version, so that they can be run [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,4,7],"tags":[],"class_list":["post-535","post","type-post","status-publish","format-standard","hentry","category-linuxunix","category-programming","category-servers"],"_links":{"self":[{"href":"https:\/\/ndk.sytes.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/535","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ndk.sytes.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ndk.sytes.net\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ndk.sytes.net\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ndk.sytes.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=535"}],"version-history":[{"count":0,"href":"https:\/\/ndk.sytes.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/535\/revisions"}],"wp:attachment":[{"href":"https:\/\/ndk.sytes.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ndk.sytes.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ndk.sytes.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}