{"id":312158,"date":"2024-01-17T13:19:10","date_gmt":"2024-01-17T05:19:10","guid":{"rendered":"https:\/\/www.idc.net\/help\/312158\/"},"modified":"2024-01-17T13:19:10","modified_gmt":"2024-01-17T05:19:10","slug":"%e4%bb%8emysql-5-1%e5%8d%87%e7%ba%a7%e5%88%b0mariadb-5-5-x","status":"publish","type":"post","link":"https:\/\/idc.net\/help\/312158\/","title":{"rendered":"\u4eceMySQL 5.1\u5347\u7ea7\u5230MariaDB 5.5.x"},"content":{"rendered":"

\u4e0d\u8fc7\u5bf9\u4e8e\u4f7f\u7528 MySQL \u5df1\u4e45, \u5e76\u4e14\u5f88\u719f\u6089 MySQL \u751f\u6001\u7684\u6211\u4eec, \u5176\u5b9e\u6362 MySQL \u5e76\u4e0d\u662f\u8fd9\u4e48\u8feb\u5207\u7684\u4e8b\u60c5, \u6bd5\u7adf\u8fd8\u6ca1\u6709\u5230\u672b\u65e5\u561b.<\/p>\n

\u4e0d\u8fc7\u8be5\u6765\u7684\u8fd8\u662f\u4f1a\u6765, \u4e4b\u524d Gentoo portage \u51fa\u73b0 MySQL 5.5 \u5347\u7ea7\u7684\u9009\u9879, \u6211\u4e00\u5347\u7ea7\u4e0a\u53bb, MySQL 5.5 \u5c31\u52a8\u4e0d\u4e86, \u539f\u56e0\u4e0d\u660e, \u6211\u4e5f\u61d2\u5f97\u67e5, \u6240\u4ee5\u6211\u6682\u65f6\u8bbe mask \u6682\u65f6\u7528\u65e7\u7248.<\/p>\n

\u8be5\u6765\u7684\u8fd8\u662f\u4f1a\u6765, \u6700\u8fd1\u7684 Portage \u4f3c\u4e4e\u5c31\u6709\u5f3a\u8feb\u8981\u4f7f\u7528 5.5 \u7684\u503e\u5411\u4e86, Getoo MySQL 5.5 \u6709\u63d0\u4f9b MySQL \u548cMariaDB \u7684\u9009\u9879.<\/p>\n

\u76ee\u524d\u6765\u770b, \u6bd4\u8d77 MySQL, MariaDB \u662f\u6bd4\u8f83\u597d\u7684\u9009\u62e9[2]. \u81f3\u5c11\u5e94\u8be5\u4e0d\u7528\u6015 Oracle \u780d\u6389\u8fd9\u4e2a Product, \u6bd5\u7adf Oracle \u7684\u4e3b\u529b\u662f Oracle \u7684 DB. \u4e0d\u662f MySQL.<\/p>\n

\u67e5\u4e86\u4e00\u4e0b, Gentoo \u8bba\u575b[3]\u5185\u4f3c\u4e4e\u6ca1\u6709\u5173\u4e8e\u5347\u7ea7\u5230 MariaDB \u7684\u707e\u60c5\u51fa\u73b0, \u6240\u4ee5\u6211\u4e5f\u5c31\u6709\u70b9\u653e\u5fc3\u7684\u51c6\u5907\u5347\u7ea7\u4e86. (\u5e38\u7528 Gentoo \u7684\u5c31\u77e5\u9053, \u6709\u65f6\u6ca1\u6709\u8fd9\u4e48\u987a\u5229\u7684\u4e8b\u60c5\u5440)<\/p>\n

\u4e0d\u8fc7\u968f\u624b\u5347\u4e86\u4e00\u4e0b, \u8fd8\u771f\u7684\u5f88\u7b80\u5355, \u4ee5\u4e0b\u662f\u6b65\u9aa4<\/p>\n

(1) Stop MySQL<\/p>\n

 <\/p>\n

\n \n \n 
    \n  \n  \n  
  1. $ \/etc\/init.d\/mysql stop <\/span><\/span><\/li>\n \n \n <\/ol><\/pre>\n
    (2) \u79fb\u9664 \/etc\/portage\/package.mask \u6709\u5173 virtual\/mysql-5.5 \u90a3\u4e00\u884c<\/p>\n
    (3) \u5b89\u88c5 MariaDB<\/p>\n
     <\/p>\n
    \n \n \n 
      \n  \n  \n  
    1. $ emerge -aV MariaDB <\/span><\/span><\/li>\n \n \n <\/ol><\/pre>\n
      (4) \u5347\u7ea7 configure file.<\/p>\n
       <\/p>\n
      \n \n \n 
        \n  \n  \n  
      1. $ etc-update <\/span><\/span><\/li>\n \n \n <\/ol><\/pre>\n
        (5) \u5347\u7ea7 MySQL DB<\/p>\n
         <\/p>\n
        \n \n \n 
          \n  \n  \n  
        1. $ mysql_upgrade \u2013<\/span>password<\/span>= <\/span><\/span><\/li>\n \n \n <\/ol><\/pre>\n
          (6) \u66f4\u65b0\u7cfb\u7edf\u7684 MySQL Library , \u8fd9\u662f\u6700\u96be\u7684, \u4e0d\u8fc7\u4f1a\u7528 Gentoo \u7684\u5c31\u8981\u81ea\u5df1\u89e3\u4e86<\/p>\n
          $ revdep-rebuild<\/p>\n
          \u76ee\u524d\u770b\u8d77\u6765\u8fd8\u7b97\u6b63\u5e38, \u5e0c\u671b\u4e0d\u8981\u51fa\u4ec0\u4e48\u5927\u95ee\u9898\u624d\u597d.<\/p>\n
          [1] Oracle Makes More Moves To Kill Open Source MySQL<\/p>\n
          [2] MariaDB versus MySQL \u2013 Features<\/p>\n
          [3] MySQL \u2013> MariaDB howto?<\/p>\n
          \u539f\u6587\u94fe\u63a5\uff1ahttp:\/\/blog.richliu.com\/2013\/04\/11\/1445\/<\/p>\n
           <\/p>\n
          \u3010\u7f16\u8f91\u63a8\u8350\u3011<\/p>\n
            \n
          1. MariaDB 5.3\u5c06\u652f\u6301ALTER TABLE\u7684\u8fdb\u5ea6\u63d0\u793a<\/li>\n
          2. MySQL\u521b\u59cb\u4eba\u6253\u9020MariaDB \u5168\u9762\u517c\u5bb9MySQL 5.1<\/li>\n
          3. MariaDB 2\u5468\u5e74\u4e86<\/li>\n
          4. \u6559\u4f60\u4e94\u6b65\u4f18\u5316\u4f60\u7684MongoDB<\/li>\n
          5. NoSQL\u5728\u4f01\u4e1a\u4e2d\u7684\u53d1\u5c55\u5386\u7a0b<\/li>\n<\/ol>\n
             <\/p>\n
             <\/p>\n","protected":false},"excerpt":{"rendered":"
            \u4e0d\u8fc7\u5bf9\u4e8e\u4f7f\u7528 MySQL \u5df1\u4e45, \u5e76\u4e14\u5f88\u719f\u6089 MySQL \u751f\u6001\u7684\u6211\u4eec, \u5176\u5b9e\u6362 MySQL \u5e76\u4e0d\u662f\u8fd9\u4e48\u8feb\u5207\u7684\u4e8b […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7038],"tags":[],"class_list":["post-312158","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts\/312158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/comments?post=312158"}],"version-history":[{"count":0,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/posts\/312158\/revisions"}],"wp:attachment":[{"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/media?parent=312158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/categories?post=312158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/idc.net\/help\/wp-json\/wp\/v2\/tags?post=312158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}