Topic: prblm mysql 5, centos 5.8
Hello,
Je suis dans le tracas...
J'ai voulu faire un upgrade de mysql et impossible de le redémarrer....
je suis sur CentOs 5.8
j'ai fait :
yum --enablerepo=remi update mysql
et pas de soucis tout c'est bien installé :
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
Updating : mysql-server 5/7
Cleanup : mysql-server 6/7
Cleanup : mysql 7/7
Dependency Installed:
libaio.x86_64 0:0.3.106-5 mysql-libs.x86_64 0:5.5.28-1.el5.remi mysqlclient15.x86_64 0:5.0.67-1.el5.remi
Updated:
mysql.x86_64 0:5.5.28-1.el5.remi
Dependency Updated:
mysql-server.x86_64 0:5.5.28-1.el5.remi
Complete!
d'ailleurs en relisant ces logs je m'apperçois de [cite] warning: /etc/my.cnf created as /etc/my.cnf.rpmnew [/cite]
Avant d'aller plus loin...
est-ce qu'il faut que je remplace le "vieux" par le nouveau ?
Le vieux : /etc/my.cnf
[mysqld]
query_cache_type=1
query_cache_size=32M
query_cache_limit=1M
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-networking
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
skip-bdb
innodb_buffer_pool_size=2M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb
innodb_buffer_pool_size=2M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
Le "nouveau" /etc/my.cnf.rpmnew :
[mysqld]
# Settings user and group are ignored when systemd is used (fedora >= 15).
# If you need to run mysqld under different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in
user=mysql
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Semisynchronous Replication
# uncomment next line on MASTER
;plugin-load=rpl_semi_sync_master=semisync_master.so
# uncomment next line on SLAVE
;plugin-load=rpl_semi_sync_slave=semisync_slave.so
# Others options for Semisynchronous Replication
;rpl_semi_sync_master_enabled=1
;rpl_semi_sync_master_timeout=10
;rpl_semi_sync_slave_enabled=1
;performance_schema
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
pour info :
rpm -qa mysql\* | sort
mysql-5.5.28-1.el5.remi
mysqlclient15-5.0.67-1.el5.remi
mysql-connector-odbc-3.51.26r1127-2.el5
mysql-libs-5.5.28-1.el5.remi
mysql-server-5.5.28-1.el5.remi