{"id":2804,"date":"2021-08-10T11:42:13","date_gmt":"2021-08-10T02:42:13","guid":{"rendered":"https:\/\/www.ish.org\/blog\/?p=2804"},"modified":"2021-08-10T14:47:41","modified_gmt":"2021-08-10T05:47:41","slug":"mariadb%e3%81%b8%e3%81%ae%e7%a7%bb%e8%a1%8c%ef%bc%88%e3%81%9d%e3%81%ae2wordpress%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.ish.org\/blog\/?p=2804","title":{"rendered":"mariadb\u3078\u306e\u79fb\u884c\uff08\u305d\u306e2:wordpress\uff09"},"content":{"rendered":"<p>\u4eca\u5ea6\u306f\u3053\u3053\u306ewordpress\u306eDB\u3092mysql 8.0.25\u304b\u3089mariadb 10.5.12\u306b\u3057\u3066\u307f\u307e\u3057\u305f\u3002<!--more--><br \/>\n\u624b\u9806\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3002<\/p>\n<pre>% mysqldump --quote-names --skip-lock-tables \\\r\n    --single-transaction --flush-logs \\\r\n    --master-data=2 -u root -pPASSWORD wordpress \\\r\n    &gt; wordpress-dump20210810.sql\r\n% su\r\n# crontab -e\r\n(<a href=\/blog\/?p=2237>\u30d7\u30ed\u30bb\u30b9\u76e3\u8996cron<\/a>\u3092\u505c\u6b62\uff09\r\n# \/usr\/local\/etc\/rc.d\/mysql-server stop\r\n# mv -i \/usr\/local\/etc\/mysql \/usr\/local\/etc\/mysql.old\r\n# pkg delete mysql80-client\r\n# pkg add mariadb105-client-10.5.12.txz\r\n# pkg add mariadb105-server-10.5.12.txz\r\npkg: Missing dependency 'galera26'\u7b49\u304c\u51fa\u308b\u306e\u3067\u3001\r\n     \u30a8\u30e9\u30fc\u304c\u306a\u304f\u306a\u308b\u307e\u3067\u5fc5\u8981\u306apkg\u3092\u8ffd\u52a0\r\n# pkg install galera26\r\n# pkg install rsync\r\n# pkg install unixODBC\r\n# pkg add mariadb105-server-10.5.12.txz\r\n# vi \/usr\/local\/etc\/mysql\/conf.d\/server.cnf\r\nbind-address              = ::1\r\n# bind-address\u306f\u3001mysql 8.0.25\u3067\u306f\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u8907\u6570\r\n# \u6307\u5b9a\u3067\u304d\u307e\u3059\u304c\u3001mariadb\u3067\u306f\u99c4\u76ee\u307f\u305f\u3044\u306a\u306e\u3067IPv6\u306e\r\n# loopback\u3092\u6307\u5b9a\u3057\u305f\r\ninnodb_log_group_home_dir = \/var\/db\/mysql\/log\r\ngeneral_log_file          = <span style=\"font-size: 10pt;\">\/var\/db\/mysql\/log\/general.log<\/span>\r\nlog_bin                   = \/var\/db\/mysql\/log\/mysql-bin\r\nrelay_log                 = \/var\/db\/mysql\/log\/relay-log\r\nslow_query_log_file       = \/var\/db\/mysql\/log\/slow.log\r\ninnodb_doublewrite        = 0\r\ninnodb_flush_method       = O_DSYNC\r\nmax_binlog_cache_size     = 4M\r\nopen_files_limit          = 2048\r\nkey_buffer_size           = 32M\r\nmax_allowed_packet        = 1M\r\ninnodb_buffer_pool_size   = 32M\r\ninnodb_log_file_size      = 4M\r\ninnodb_log_buffer_size    = 4M\r\nZZ\r\n# mv -i \/var\/db\/mysql \/var\/db\/mysql.old\r\n# mkdir -p \/var\/db\/mysql\/log\r\n# chown -R mysql:mysql \/var\/db\/mysql\r\n# \/usr\/local\/etc\/rc.d\/mysql-server start\r\n# \/usr\/local\/bin\/mysql_secure_installation\r\n# mysql -u root\r\ncreate user wordpress identified by 'PASSWORD';\r\ncreate database wordpress character set UTF8MB4;\r\ngrant all on wordpress.* to wordpress;\r\nexit\r\n% mysql -f -u wordpress -pPASSWORD wordpress \\\r\n    &lt; wordpress-dump20210810.sql<\/pre>\n<p>\u3057\u304b\u3057\u3001blog\u3078\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u30a8\u30e9\u30fc\u306b\u306a\u308b\u305f\u3081\u66f4\u306bwp-config.php\u3092\u4fee\u6b63\u3057\u305f\u3002<\/p>\n<pre># vi \/usr\/local\/www\/wordpress\/wp-config.php\r\n\/* define('DB_HOST', 'localhost');*\/\r\n<span style=\"font-size: 10pt;\">define('DB_HOST','localhost:\/var\/run\/mysql\/mysql.sock');\r\n<\/span><\/pre>\n<p>\u305d\u306e\u5f8c\u3001\u30d7\u30ed\u30bb\u30b9\u76e3\u8996cron\u306e\u518d\u8d77\u52d5\u3067\u4e00\u5fdc\u5b8c\u4e86\u3002\u3053\u308c\u3067\u5b89\u5b9a\u3057\u3066\u52d5\u4f5c\u3057\u3066\u304f\u308c\u308b\u3068\u5b09\u3057\u3044\u306e\u3067\u3059\u304c\u3002<\/p>\n<p><a href=\/blog\/?p=2795>\u305d\u306e1<\/a>\u3078\u623b\u308b<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u5ea6\u306f\u3053\u3053\u306ewordpress\u306eDB\u3092mysql 8.0.25\u304b\u3089mariadb 10.5.12\u306b\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,6],"tags":[],"class_list":["post-2804","post","type-post","status-publish","format-standard","hentry","category-freebsd","category-wordpress"],"_links":{"self":[{"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2804","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2804"}],"version-history":[{"count":20,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2804\/revisions"}],"predecessor-version":[{"id":2829,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2804\/revisions\/2829"}],"wp:attachment":[{"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ish.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}