CentOS5.4でmysql5.1にyumアップデード

MySQL

MySQL5.1系を使いたくなったので現在の5.0からアップデート。
パッケージから入れると依存性とか大変なので、yumで実行しました。

(16:09追記：アップデート後にmysql_updateコマンドの実施が必要でした)


以下を参考に、追加repoを設定してyum。
http://www.multiburst.net/ElectricBrain/2009/05/centos-53-php-529-mysql-5134

とりあえずmysqlのみアップデート

[root@cake ~]# yum --enablerepo=remi,epel,rpmforge update mysql*

最初、ver.5.077が最新でインストール済みですよ、と言われて終了になりましたが、

　どうやらmysql5.1はremiから引っ張っているらしい、と気付いてピンときました。


remiのpriorityを上げてやると、成功しました。

[root@cake ~]# vi /etc/yum.repos.d/remi.repo

[remi]
name=Les RPM de remi pour Enterprise Linux 5 - $basearch
baseurl=http://rpms.famillecollet.com/el5.$basearch/
http://iut-info.univ-reims.fr/remirpms/el5.$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi
failovermethod=priority
priority=0 ←ここ追加

以下、アップデートログ。

[root@cake ~]# yum --enablerepo=remi,epel,rpmforge update mysql*
Loaded plugins: downloadonly, fastestmirror, priorities
Loading mirror speeds from cached hostfile
* addons: ftp.iij.ad.jp
* base: ftp.iij.ad.jp
* epel: ftp.kddilabs.jp
* extras: ftp.iij.ad.jp
* remi: rpms.famillecollet.com
* rpmforge: fr2.rpmfind.net
* updates: ftp.iij.ad.jp
remi | 2.3 kB 00:00
714 packages excluded due to repository priority protections
Setting up Update Process
Resolving Dependencies

    • > Running transaction check
    • > Processing Dependency: libmysqlclient.so.15 for package: perl-DBD-MySQL
    • > Processing Dependency: libmysqlclient.so.15 for package: mysql-connector-odbc
    • > Processing Dependency: libmysqlclient.so.15 for package: php-mysql
    • > Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: perl-DBD-MySQL
    • > Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: mysql-connector-odbc
    • > Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: php-mysql
    • > Processing Dependency: libmysqlclient_r.so.15 for package: mysql-connector-odbc
    • > Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15) for package: mysql-connector-odbc
      • > Package mysql.i386 0:5.1.41-1.el5.remi set to be updated
    • > Processing Dependency: mysql-libs = 5.1.41-1.el5.remi for package: mysql
    • > Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: mysql
    • > Processing Dependency: libmysqlclient_r.so.16(libmysqlclient_16) for package: mysql
    • > Processing Dependency: libmysqlclient_r.so.16 for package: mysql
    • > Processing Dependency: libmysqlclient.so.16 for package: mysql
      • > Package mysql-bench.i386 0:5.1.41-1.el5.remi set to be updated
      • > Package mysql-devel.i386 0:5.1.41-1.el5.remi set to be updated
      • > Package mysql-server.i386 0:5.1.41-1.el5.remi set to be updated
      • > Package mysql-test.i386 0:5.1.41-1.el5.remi set to be updated
    • > Running transaction check
      • > Package mysql-libs.i386 0:5.1.41-1.el5.remi set to be updated
      • > Package mysqlclient15.i386 0:5.0.67-1.el5.remi set to be updated
      • > Package perl-DBD-mysql.i386 0:4.012-1.el5.rf set to be updated
      • > Package php-mysql.i386 0:5.3.1-1.el5.remi set to be updated
    • > Processing Dependency: php-common = 5.3.1-1.el5.remi for package: php-mysql
    • > Running transaction check
    • > Processing Dependency: php-common = 5.2.11-jason.1 for package: php-cli
    • > Processing Dependency: php-common = 5.2.11-jason.1 for package: php-mcrypt
    • > Processing Dependency: php-common = 5.2.11-jason.1 for package: php-gd
    • > Processing Dependency: php-common = 5.2.11-jason.1 for package: php-pdo
    • > Processing Dependency: php-common = 5.2.11-jason.1 for package: php
    • > Processing Dependency: php-common = 5.2.11-jason.1 for package: php-mbstring
      • > Package php-common.i386 0:5.3.1-1.el5.remi set to be updated
    • > Running transaction check
      • > Package php.i386 0:5.3.1-1.el5.remi set to be updated
      • > Package php-cli.i386 0:5.3.1-1.el5.remi set to be updated
    • > Processing Dependency: libedit.so.0 for package: php-cli
      • > Package php-gd.i386 0:5.3.1-1.el5.remi set to be updated
    • > Processing Dependency: libt1.so.5 for package: php-gd
      • > Package php-mbstring.i386 0:5.3.1-1.el5.remi set to be updated
      • > Package php-mcrypt.i386 0:5.3.1-1.el5.remi set to be updated
      • > Package php-pdo.i386 0:5.3.1-1.el5.remi set to be updated
    • > Processing Dependency: libsqlite.so.0 for package: php-pdo
    • > Running transaction check
      • > Package libedit.i386 0:2.11-2.20080712cvs.el5 set to be updated
      • > Package sqlite2.i386 0:2.8.17-2.el5.remi set to be updated
      • > Package t1lib.i386 0:5.1.1-7.el5 set to be updated
    • > Finished Dependency Resolution

Dependencies Resolved

===================================================================================================
Package Arch Version Repository Size
===================================================================================================
Installing:
perl-DBD-mysql i386 4.012-1.el5.rf rpmforge 224 k
replacing perl-DBD-MySQL.i386 3.0007-2.el5

Updating:
mysql i386 5.1.41-1.el5.remi remi 3.9 M
mysql-bench i386 5.1.41-1.el5.remi remi 497 k
mysql-devel i386 5.1.41-1.el5.remi remi 3.2 M
mysql-server i386 5.1.41-1.el5.remi remi 11 M
mysql-test i386 5.1.41-1.el5.remi remi 5.9 M
Installing for dependencies:
libedit i386 2.11-2.20080712cvs.el5 epel 79 k
mysql-libs i386 5.1.41-1.el5.remi remi 2.1 M
mysqlclient15 i386 5.0.67-1.el5.remi remi 1.3 M
sqlite2 i386 2.8.17-2.el5.remi remi 170 k
t1lib i386 5.1.1-7.el5 epel 194 k
Updating for dependencies:
php i386 5.3.1-1.el5.remi remi 1.3 M
php-cli i386 5.3.1-1.el5.remi remi 2.5 M
php-common i386 5.3.1-1.el5.remi remi 945 k
php-gd i386 5.3.1-1.el5.remi remi 202 k
php-mbstring i386 5.3.1-1.el5.remi remi 2.1 M
php-mcrypt i386 5.3.1-1.el5.remi remi 36 k
php-mysql i386 5.3.1-1.el5.remi remi 140 k
php-pdo i386 5.3.1-1.el5.remi remi 162 k

Transaction Summary
===================================================================================================
Install 6 Package(s)
Update 13 Package(s)
Remove 0 Package(s)

Total download size: 36 M
Is this ok [y/N]: y
Downloading Packages:
(1/19): php-mcrypt-5.3.1-1.el5.remi.i386.rpm | 36 kB 00:00
(2/19): libedit-2.11-2.20080712cvs.el5.i386.rpm | 79 kB 00:00
(3/19): php-mysql-5.3.1-1.el5.remi.i386.rpm | 140 kB 00:01
(4/19): php-pdo-5.3.1-1.el5.remi.i386.rpm | 162 kB 00:01
(5/19): sqlite2-2.8.17-2.el5.remi.i386.rpm | 170 kB 00:01
(6/19): t1lib-5.1.1-7.el5.i386.rpm | 194 kB 00:00
(7/19): php-gd-5.3.1-1.el5.remi.i386.rpm | 202 kB 00:02
(8/19): perl-DBD-mysql-4.012-1.el5.rf.i386.rpm | 224 kB 00:02
(9/19): mysql-bench-5.1.41-1.el5.remi.i386.rpm | 497 kB 00:02
(10/19): php-common-5.3.1-1.el5.remi.i386.rpm | 945 kB 00:04
(11/19): php-5.3.1-1.el5.remi.i386.rpm | 1.3 MB 00:06
(12/19): mysqlclient15-5.0.67-1.el5.remi.i386.rpm | 1.3 MB 00:06
(13/19): php-mbstring-5.3.1-1.el5.remi.i386.rpm | 2.1 MB 00:09
(14/19): mysql-libs-5.1.41-1.el5.remi.i386.rpm | 2.1 MB 00:09
(15/19): php-cli-5.3.1-1.el5.remi.i386.rpm | 2.5 MB 00:10
(16/19): mysql-devel-5.1.41-1.el5.remi.i386.rpm | 3.2 MB 00:13
(17/19): mysql-5.1.41-1.el5.remi.i386.rpm | 3.9 MB 00:16
(18/19): mysql-test-5.1.41-1.el5.remi.i386.rpm | 5.9 MB 00:23
(19/19): mysql-server-5.1.41-1.el5.remi.i386.rpm | 11 MB 00:57

                                                                                                                                                                                                    • -

Total 202 kB/s | 36 MB 03:03
警告: rpmts_HdrFromFdno: ヘッダ V3 DSA signature: NOKEY, key ID 00f97f56
remi/gpgkey | 1.3 kB 00:00
Importing GPG key 0x00F97F56 "Remi Collet " from /etc/pki/rpm-gpg/RPM-GPG-KEY-remi
Is this ok [y/N]: y
warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID 217521f6
epel/gpgkey | 1.7 kB 00:00
Importing GPG key 0x217521F6 "Fedora EPEL " from /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction

WARNING : This php-* RPM are not official Fedora build and
overrides the official ones. Don't file bugs on Fedora Project.

Use dedicated forums http://forums.famillecollet.com/

Updating : php-common 1/33
warning: /etc/php.ini created as /etc/php.ini.rpmnew
Installing : mysqlclient15 2/33

WARNING : This MySQL RPM is not an official Fedora build and it
overrides the official one. Don't file bugs on Fedora Project.
Use dedicated forums http://forums.famillecollet.com/

Installing : mysql-libs 3/33
Updating : mysql 4/33
Installing : perl-DBD-mysql 5/33
Updating : mysql-server 6/33
Installing : libedit 7/33
Updating : php-cli 8/33
Installing : sqlite2 9/33
Updating : php-pdo 10/33
Installing : t1lib 11/33
Updating : mysql-test 12/33
Updating : php-mcrypt 13/33
Updating : mysql-bench 14/33
Updating : php 15/33
Updating : php-mbstring 16/33
Updating : php-gd 17/33
Updating : mysql-devel 18/33
Updating : php-mysql 19/33
Cleanup : mysql-test 20/33
Cleanup : php-mcrypt 21/33
Cleanup : mysql-bench 22/33
Cleanup : php 23/33
Cleanup : mysql-server 24/33
Cleanup : php-mbstring 25/33
Cleanup : php-gd 26/33
Erasing : perl-DBD-MySQL 27/33
Cleanup : mysql-devel 28/33
Cleanup : mysql 29/33
Cleanup : php-pdo 30/33
Cleanup : php-common 31/33
Cleanup : php-cli 32/33
Cleanup : php-mysql 33/33

Installed:
perl-DBD-mysql.i386 0:4.012-1.el5.rf

Dependency Installed:
libedit.i386 0:2.11-2.20080712cvs.el5 mysql-libs.i386 0:5.1.41-1.el5.remi
mysqlclient15.i386 0:5.0.67-1.el5.remi sqlite2.i386 0:2.8.17-2.el5.remi
t1lib.i386 0:5.1.1-7.el5

Updated:
mysql.i386 0:5.1.41-1.el5.remi mysql-bench.i386 0:5.1.41-1.el5.remi
mysql-devel.i386 0:5.1.41-1.el5.remi mysql-server.i386 0:5.1.41-1.el5.remi
mysql-test.i386 0:5.1.41-1.el5.remi

Dependency Updated:
php.i386 0:5.3.1-1.el5.remi php-cli.i386 0:5.3.1-1.el5.remi
php-common.i386 0:5.3.1-1.el5.remi php-gd.i386 0:5.3.1-1.el5.remi
php-mbstring.i386 0:5.3.1-1.el5.remi php-mcrypt.i386 0:5.3.1-1.el5.remi
php-mysql.i386 0:5.3.1-1.el5.remi php-pdo.i386 0:5.3.1-1.el5.remi

Replaced:
perl-DBD-MySQL.i386 0:3.0007-2.el5

Complete!

MySQL起動して確認。

[root@cake ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.41 MySQL Community Server (GPL) by Remi

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

phpとの連携も、問題ありませんでした。

以下、追記

/var/log/mysqld.logに実はワーニングが出力されていました。

091218 13:25:14 mysqld started
091218 13:25:14 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091218 13:25:14 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295

本来はこの後、

[root@cake ~]# mysql_upgrade

の実行が必要だったようです
MySQL :: MySQL 5.6 リファレンスマニュアル :: 4.4.7 mysql_upgrade — MySQL テーブルのチェックとアップグレード


実行すると、既存のDBのテーブルチェックを行い、必要なものをアップグレードされました。

[root@cake ~]# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
cake_frame.acos
error : Table upgrade required. Please do "REPAIR TABLE `acos`" or dump/reload to fix it!
cake_frame.aros
error : Table upgrade required. Please do "REPAIR TABLE `aros`" or dump/reload to fix it!
cake_frame.aros_acos OK
cake_frame.cake_sessions
error : Table upgrade required. Please do "REPAIR TABLE `cake_sessions`" or dump/reload to fix it!
cake_frame.groups OK
cake_frame.users
error : Table upgrade required. Please do "REPAIR TABLE `users`" or dump/reload to fix it!
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.help_category
error : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it!
mysql.help_keyword
error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" or dump/reload to fix it!
mysql.help_relation OK
mysql.help_topic
error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" or dump/reload to fix it!
mysql.host OK
mysql.proc
error : Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it!
mysql.procs_priv OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" or dump/reload to fix it!
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
(以下中略）

Repairing tables
cake_auth.members OK
cake_auth.users OK
cake_frame.acos
note : The storage engine for the table doesn't support repair
cake_frame.aros
note : The storage engine for the table doesn't support repair
cake_frame.cake_sessions
note : The storage engine for the table doesn't support repair
cake_frame.users
note : The storage engine for the table doesn't support repair
(中略）
Running 'mysql_fix_privilege_tables'...
OK

Repairingで、note以上の警告は出なかったのでOK。