{"id":3495,"date":"2014-12-21T10:45:32","date_gmt":"2014-12-21T01:45:32","guid":{"rendered":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/?p=3495"},"modified":"2014-12-21T10:45:32","modified_gmt":"2014-12-21T01:45:32","slug":"mariadb%e3%81%ab%e3%82%ac%e3%83%81%e3%83%a3%e3%83%83%e3%81%a8%e5%88%87%e3%82%8a%e6%9b%bf%e3%81%88","status":"publish","type":"post","link":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/?p=3495","title":{"rendered":"MariaDB\u306b\u30ac\u30c1\u30e3\u30c3\u3068\u5207\u308a\u66ff\u3048"},"content":{"rendered":"

懸案のMySQLからMariaDBへの切り替えを敢行しました．<\/p>\n

一応仮想マシンで先にテストをしました．バイナリーコンパチをうたっているので，Slackwareの出来合いのバイナリーパッケージをinstallpkgで大丈夫だとは思いましたが，念のため，当該のマシンでSlackBuildしました．<\/p>\n

従前はMySQL 5.5.xなので，対応するmariaDBも5.5.xです．Slackware-currentにMariaDBの5.5.xの最新版5.5.40が使われているので，そのままSlackBuildしました．<\/p>\n

MySQLには，make uninstall<\/strong>がないので，できたパッケージをinstallpkgで上書きインストールしました．さすがに，念のため，事前に\/var\/lib\/mysqlはtbzにして保存してますが^^;<\/p>\n

気をつけなければいけないのは，SlackBuildしたMariaDBのmysqldのインストール先は，\/usr\/binではなくて，\/usr\/libexecということです．MySQLのmysqldをパスの通らないところに移動して，<\/p>\n

\/etc\/rc.d\/rc.mysqld start<\/pre>\n
でうまく動きました．<\/p>\n
全く同じ手順で，実機にもインストールして，無事動いているようです1<\/a><\/sup>このWordPressも，MySQL\/MariaDBを使用しています．<\/span>．<\/p>\n
\"20141221-MariaDB2\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u61f8\u6848\u306eMySQL\u304b\u3089MariaDB\u3078\u306e\u5207\u308a\u66ff\u3048\u3092\u6562\u884c\u3057\u307e\u3057\u305f\uff0e \u4e00\u5fdc\u4eee\u60f3\u30de\u30b7\u30f3\u3067\u5148\u306b\u30c6\u30b9\u30c8\u3092\u3057\u307e\u3057\u305f\uff0e\u30d0\u30a4\u30ca\u30ea\u30fc\u30b3\u30f3\u30d1\u30c1\u3092\u3046\u305f\u3063\u3066\u3044\u308b\u306e\u3067\uff0cSlackware\u306e\u51fa\u6765\u5408\u3044\u306e\u30d0\u30a4\u30ca\u30ea\u30fc\u30d1\u30c3\u30b1\u30fc\u30b8\u3092installpkg\u3067\u5927\u4e08\u592b\u3060\u3068\u306f\u601d\u3044\u307e\u3057\u305f\u304c\uff0c\u5ff5\u306e\u305f\u3081\uff0c\u5f53\u8a72\u306e\u30de\u30b7\u30f3\u3067SlackBuild\u3057\u307e\u3057\u305f\uff0e \u5f93\u524d\u306fMySQL 5.5.x\u306a\u306e\u3067\uff0c\u5bfe\u5fdc\u3059\u308bmariaDB\u30825.5.x\u3067\u3059\uff0eSlackware-current\u306bMariaDB\u306e5.5.x\u306e\u6700\u65b0\u72485.5.40\u304c\u4f7f\u308f\u308c\u3066\u3044\u308b\u306e\u3067\uff0c\u305d\u306e\u307e\u307eSlackBuild\u3057\u307e\u3057\u305f\uff0e MySQL\u306b\u306f\uff0cmake uninstall\u304c\u306a\u3044\u306e\u3067\uff0c\u3067\u304d\u305f\u30d1\u30c3\u30b1\u30fc\u30b8\u3092installpkg\u3067\u4e0a\u66f8\u304d\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3057\u305f\uff0e\u3055\u3059\u304c\u306b\uff0c\u5ff5\u306e\u305f\u3081\uff0c\u4e8b\u524d\u306b\/var\/lib\/mysql\u306ftbz\u306b\u3057\u3066\u4fdd\u5b58\u3057\u3066\u307e\u3059\u304c^^; \u6c17\u3092\u3064\u3051\u306a\u3051\u308c\u3070\u3044\u3051\u306a\u3044\u306e\u306f\uff0cSlackBuild\u3057\u305fMariaDB\u306emysqld\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5148\u306f\uff0c\/usr\/bin\u3067\u306f\u306a\u304f\u3066\uff0c\/usr\/libexec\u3068\u3044\u3046\u3053\u3068\u3067\u3059\uff0eMySQL\u306emysqld\u3092\u30d1\u30b9\u306e\u901a\u3089\u306a\u3044\u3068\u3053\u308d\u306b\u79fb\u52d5\u3057\u3066\uff0c \/etc\/rc.d\/rc.mysqld start \u3067\u3046\u307e\u304f\u52d5\u304d\u307e\u3057\u305f\uff0e \u5168\u304f\u540c\u3058\u624b\u9806\u3067\uff0c\u5b9f\u6a5f\u306b\u3082\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\uff0c\u7121\u4e8b\u52d5\u3044\u3066\u3044\u308b\u3088\u3046\u3067\u3059\uff0e<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_daextam_enable_autolinks":"","footnotes":""},"categories":[8],"tags":[291,402],"class_list":["post-3495","post","type-post","status-publish","format-standard","hentry","category-linux","tag-mariadb","tag-slackware"],"publishpress_future_action":{"enabled":false,"date":"2026-04-18 23:05:31","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/posts\/3495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3495"}],"version-history":[{"count":0,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/posts\/3495\/revisions"}],"wp:attachment":[{"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}