mysql バージョンアップ の履歴差分(No.2)

• 履歴一覧
• 現在との差分 を表示
• ソース を表示
• 履歴 を表示
• mysql バージョンアップ へ行く。
  • 1 (2019-05-07 (火) 14:00:53)
  • 2 (2019-05-07 (火) 16:22:38)

• 追加された行はこの色です。
• 削除された行はこの色です。

#author("2019-05-07T14:00:53+09:00","default:kuji","kuji")
#author("2019-05-07T16:22:38+09:00","default:kuji","kuji")
CONTENTS
#contents
----
Lastmodified　&lastmod;
----
*mysql バージョンアップ [#n3a5bbd2]

mysql56はメンテ終了なので、取り敢えず57へUPする。なお、mysql56は稼働させたまま作業する。


 # pkg delete mysql56-server-5.6.44
 Updating database digests format: 100%
 Checking integrity... done (0 conflicting)
 Deinstallation has been requested for the following 1 packages (of 0 packages in the universe):
 
 Installed packages to be REMOVED:
         mysql56-server-5.6.44
 
 Number of packages to be removed: 1
 
 The operation will free 82 MiB.
 
 Proceed with deinstalling packages? [y/N]:

とサーバは、単独でdelete できるが、クライアントは、依存関係が多々あって、port deinstall するのがヨサゲ。

 # pkg delete mysql56-client-5.6.44
 Checking integrity... done (0 conflicting)
 Deinstallation has been requested for the following 11 packages (of 0 packages in the universe):
 
 Installed packages to be REMOVED:
        mysql56-client-5.6.44
        apr-1.6.5.1.6.1_1
        p5-DBD-mysql-4.050
        postfix-3.4.5,1
        mysql56-server-5.6.44
        apache24-2.4.39
        spamassassin-3.4.2_3
        ja-mailman-2.1.14.j7_6,1
        ap24-mod_http2-devel-1.11.4
        mod_php71-7.1.28_2
        amavisd-new-2.11.1_1,1
 
 Number of packages to be removed: 11
 
 The operation will free 199 MiB.
 
 Proceed with deinstalling packages? [y/N]:

まず、pkg delete mysql56-server-5.6.44　する。

 # portinstall mysql57-server
 [Reading data from pkg(8) ... - 483 packages found - done]
 ** Port marked as IGNORE: databases/mysql57-server:
        cannot install: MySQL versions mismatch: mysql56-client is installed and wanted version is mysql57-client
 ** Listing the failed packages (-:ignored / *:skipped / !:failed)
        - databases/mysql57-server

 # cd /usr/ports/databases/mysql56-client
 # make deinstall
 ===>  Deinstalling for mysql56-client
 ===>   Deinstalling mysql56-client-5.6.44
 Checking integrity... done (0 conflicting)
 Deinstallation has been requested for the following 1 packages (of 0 packages in the universe):
 
 Installed packages to be REMOVED:
         mysql56-client-5.6.44
 
 Number of packages to be removed: 1
 
 The operation will free 38 MiB.
 [1/1] Deinstalling mysql56-client-5.6.44...
 [1/1] Deleting files for mysql56-client-5.6.44: 100%

以下を実行するとクライアントもインストールされる。

 # portinstall mysql57-server
 [Reading data from pkg(8) ... - 482 packages found - done]

以下の様なスクリプトを実行してアップグレードする。

 #/bin/sh!
 /usr/local/etc/rc.d/mysql-server restart && \
 /usr/local/bin/mysql_upgrade -u root -pパスワード


実行すると・・・

                                      
 mysql_upgrade: [Warning] Using a password on the command line interface can be insecure.
 Checking if update is needed.
 Checking server version.
 Running queries to upgrade MySQL server.
 Checking system database.
 mysql.columns_priv                                 OK
 mysql.db                                           OK
 mysql.engine_cost                                  OK
      :                 :
 mysql.time_zone_transition                         OK
 mysql.time_zone_transition_type                    OK
 mysql.user                                         OK
 Upgrading the sys schema.
 Checking databases.
 JM3.vg49r_assets                                   OK
 JM3.vg49r_associations                             OK
      :                 :
 phpmyadmin.pma__tracking                           OK
 phpmyadmin.pma__userconfig                         OK
 phpmyadmin.pma__usergroups                         OK
 phpmyadmin.pma__users                              OK
 sys.sys_config                                     OK
 Upgrade process completed successfully.
 Checking if update is needed.

となって移行完了。

 # portinstall mysql57-server --batch &&  /root/bin/check.sh

* [#y55cdd91]

 ===>  openldap-sasl-client-2.4.47 conflicts with installed package(s):
      openldap-client-2.4.47
 
      They install files into the same place.
      You may want to stop build with Ctrl + C.
 ===>  License OPENLDAP accepted by the user
 ===>   openldap-sasl-client-2.4.47 depends on file: /usr/local/sbin/pkg - found
 ===> Fetching all distfiles required by openldap-sasl-client-2.4.47 for building
 
 ===>  openldap-sasl-client-2.4.47 conflicts with installed package(s):
      openldap-client-2.4.47
 
      They will not build together.
      Please remove them first with pkg delete.
 *** Error code 1


 # pkg delete openldap-client-2.4.47
 Updating database digests format: 100%
 Checking integrity... done (0 conflicting)
 Deinstallation has been requested for the following 3 packages (of 0 packages in the universe):
 
 Installed packages to be REMOVED:
        openldap-client-2.4.47
        php71-ldap-7.1.28_2
        php71-extensions-1.0


----
Total access &counter(total);：本日 &counter(today);：昨日 &counter(yesterday);
#counter([total|today|yesterday]);