{"id":23050,"date":"2023-11-11T21:52:40","date_gmt":"2023-11-11T12:52:40","guid":{"rendered":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/?p=23050"},"modified":"2023-11-11T21:52:40","modified_gmt":"2023-11-11T12:52:40","slug":"slackware-arm%e3%81%a8raspberry-pi-os-64bit%e3%81%aemariadb%e3%81%af%e3%83%90%e3%82%a4%e3%83%8a%e3%83%aa%e3%83%bc%e3%82%b3%e3%83%b3%e3%83%91%e3%83%81","status":"publish","type":"post","link":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/?p=23050","title":{"rendered":"Slackware ARM\u3068Raspberry Pi OS 64bit\u306eMariaDB\u306f\u30d0\u30a4\u30ca\u30ea\u30fc\u30b3\u30f3\u30d1\u30c1"},"content":{"rendered":"\n

標記の件確認しました．そうだろうとは思っていました．逆にそうでなかったなら何なんだろうとも思っていました😥<\/p>\n\n\n\n

これで，Raspberry Pi 5導入時にサーバーのOSをRaspberry Pi OS 64bitにする最大の懸念<\/a>が払拭されました．<\/p>\n\n\n\n

一応確認した方法を書いときます．<\/p>\n\n\n\n

Slackware ARMのMariaDBを，<\/p>\n\n\n\n

\/etc\/rc.d\/rc.mysqld stop<\/code><\/pre>\n\n\n\n
で停止させてから，\/var\/lib\/mysql以下をtarで固めてsftpするか，rsyncを使ってRaspberry Pi OS 64bitのマシンの適当な作業ディレクトリーに置いときます1<\/a><\/sup>Slackware ARMのMariaDBは再起動しておきます．<\/span>．<\/p>\n\n\n\n
以下はRaspberry Pi OS 64bit側での作業です．<\/p>\n\n\n\n
apt install mariadb-server<\/code><\/pre>\n\n\n\n
で，mariadbのサーバーをインストールします．これだけでMariaDBが動き出しますが，念の為動作を確認してからおまじないを実行します．<\/p>\n\n\n\n
systemctl status mariadb\nmysql_secure_installation<\/code><\/pre>\n\n\n\n
これで，rootだけログインできる空のデータベースが動き出します．ここで一旦，<\/p>\n\n\n\n
systemctl stop mariadb<\/code><\/pre>\n\n\n\n
で，MariaDBを停止させて，<\/p>\n\n\n\n
cd \/var\/lib\nmv mysql mysql-empty<\/code><\/pre>\n\n\n\n
あとは，Slackware ARMから持ってきたデータを展開してから，\/var\/lib\/mysql<\/code>として置きます．念の為，\/var\/lib\/mysql<\/code>以下のオーナー・グループがmysql:mysql<\/code>になっているか確認してなってなければ修正します．<\/p>\n\n\n\n
これで，<\/p>\n\n\n\n
systemctl start mariadb<\/code><\/pre>\n\n\n\n
として起動を確認して，あとはSlackware ARMで使っていたユーザーでログインして中身を確認します．<\/p>\n\n\n\n
コマンドラインだけでは不便なので，phpMyAdminをあとでインストールしたいと思います．<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6a19\u8a18\u306e\u4ef6\u78ba\u8a8d\u3057\u307e\u3057\u305f\uff0e\u305d\u3046\u3060\u308d\u3046\u3068\u306f\u601d\u3063\u3066\u3044\u307e\u3057\u305f\uff0e\u9006\u306b\u305d\u3046\u3067\u306a\u304b\u3063\u305f\u306a\u3089\u4f55\u306a\u3093\u3060\u308d\u3046\u3068\u3082\u601d\u3063\u3066\u3044\u307e\u3057\u305f\ud83d\ude25 \u3053\u308c\u3067\uff0cRaspberry Pi 5\u5c0e\u5165\u6642\u306b\u30b5\u30fc\u30d0\u30fc\u306eOS\u3092Raspberry Pi OS 64bit\u306b\u3059\u308b\u6700\u5927\u306e\u61f8\u5ff5\u304c\u6255\u62ed\u3055\u308c\u307e\u3057\u305f\uff0e \u4e00\u5fdc\u78ba\u8a8d\u3057\u305f\u65b9\u6cd5\u3092\u66f8\u3044\u3068\u304d\u307e\u3059\uff0e Slackware ARM\u306eMariaDB\u3092\uff0c \u3067\u505c\u6b62\u3055\u305b\u3066\u304b\u3089\uff0c\/var\/lib\/mysql\u4ee5\u4e0b\u3092tar\u3067\u56fa\u3081\u3066sftp\u3059\u308b\u304b\uff0crsync\u3092\u4f7f\u3063\u3066Raspberry Pi OS 64bit\u306e\u30de\u30b7\u30f3\u306e\u9069\u5f53\u306a\u4f5c\u696d\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u30fc\u306b\u7f6e\u3044\u3068\u304d\u307e\u3059\uff0e \u4ee5\u4e0b\u306fRaspberry Pi OS 64bit\u5074\u3067\u306e\u4f5c\u696d\u3067\u3059\uff0e \u3067\uff0cmariadb\u306e\u30b5\u30fc\u30d0\u30fc\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\uff0e\u3053\u308c\u3060\u3051\u3067MariaDB\u304c\u52d5\u304d\u51fa\u3057\u307e\u3059\u304c\uff0c\u5ff5\u306e\u70ba\u52d5\u4f5c\u3092\u78ba\u8a8d\u3057\u3066\u304b\u3089\u304a\u307e\u3058\u306a\u3044\u3092\u5b9f\u884c\u3057\u307e\u3059\uff0e \u3053\u308c\u3067\uff0croot\u3060\u3051\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u308b\u7a7a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u52d5\u304d\u51fa\u3057\u307e\u3059\uff0e\u3053\u3053\u3067\u4e00\u65e6\uff0c \u3067\uff0cMariaDB\u3092\u505c\u6b62\u3055\u305b\u3066\uff0c \u3042\u3068\u306f\uff0cSlackware ARM\u304b\u3089\u6301\u3063\u3066\u304d\u305f\u30c7\u30fc\u30bf\u3092\u5c55\u958b\u3057\u3066\u304b\u3089\uff0c\/var\/lib\/mysql\u3068\u3057\u3066\u7f6e\u304d\u307e\u3059\uff0e\u5ff5\u306e\u70ba\uff0c\/var\/lib\/mysql\u4ee5\u4e0b\u306e\u30aa\u30fc\u30ca\u30fc\u30fb\u30b0\u30eb\u30fc\u30d7\u304cmysql:mysql\u306b\u306a\u3063\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3057\u3066\u306a\u3063\u3066\u306a\u3051\u308c\u3070\u4fee\u6b63\u3057\u307e\u3059\uff0e \u3053\u308c\u3067\uff0c \u3068\u3057\u3066\u8d77\u52d5\u3092\u78ba\u8a8d\u3057\u3066\uff0c\u3042\u3068\u306fSlackware ARM\u3067\u4f7f\u3063\u3066\u3044\u305f\u30e6\u30fc\u30b6\u30fc\u3067\u30ed\u30b0\u30a4\u30f3\u3057\u3066\u4e2d\u8eab\u3092\u78ba\u8a8d\u3057\u307e\u3059\uff0e \u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u3060\u3051\u3067\u306f\u4e0d\u4fbf\u306a\u306e\u3067\uff0cphpMyAdmin\u3092\u3042\u3068\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3044\u3068\u601d\u3044\u307e\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,27,29],"tags":[],"class_list":["post-23050","post","type-post","status-publish","format-standard","hentry","category-linux","category-rasapberry-pi","category-systemd"],"publishpress_future_action":{"enabled":false,"date":"2026-05-30 08:57:41","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\/23050","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=23050"}],"version-history":[{"count":0,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/posts\/23050\/revisions"}],"wp:attachment":[{"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23050"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23050"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}