MySQL 업그레이드 (5.1 → 5.6)

---

---

설치환경

centos 6

---

기존 설치된 mysql 은 디렉터리를 우선 백업하여 옮겨야함

(ex. /usr/local/mysql -> /usr/local/mysql_5.1 으로 백업이전)

1. cmake 설치(3.10부터는 gcc 4.8 필요함 - 3.9.6 설치)

# cd /usr/local/src # wget https://cmake.org/files/v3.9/cmake-3.9.6.tar.gz # tar zxvf cmake-3.9.6.tar.gz # cd cmake-3.9.6 # ./bootstrap # make && make install

2. MySQL 설치

# groupadd -g 400 mysql \\ mysql 그룹 생성 # useradd -u400 -g400 -d /usr/local/mysql -s /bin/false mysql \\ mysql 사용자 생성 # cd /usr/local/src # wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.38.tar.gz # tar zxvf mysql-5.6.38.tar.gz # cd mysql-5.6.38 # cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_DATADIR=/usr/local/mysql/data \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_EXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DSYSCONFDIR=/etc \ -DMYSQL_TCP_PORT=3306 # cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ -DMYSQL_DATADIR=/usr/local/mysql/data \ -DDEFAULT_CHARSET=utf8 \ -DDEFAULT_COLLATION=utf8_general_ci \ -DWITH_EXTRA_CHARSETS=all \ -DENABLED_LOCAL_INFILE=1 \ -DWITH_INNOBASE_STORAGE_ENGINE=1 \ -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \ -DSYSCONFDIR=/etc \ -DMYSQL_TCP_PORT=3306 # make && make install

3. MySQL 기본 설정

# cp -arp support-files/my-default.cnf /etc/my.cnf # cp -arp support-files/mysql.server /etc/init.d/mysqld # rm -rf /usr/local/mysql/data # /usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql # chown -R mysql.mysql /usr/local/mysql # chmod 700 /etc/init.d/mysqld # chmod 711 /usr/local/mysql # chmod 700 /usr/local/mysql/data # chmod 751 /usr/local/mysql/bin # chmod 750 /usr/local/mysql/bin/* # chmod 755 /usr/local/mysql/bin/mysql # chmod 755 /usr/local/mysql/bin/mysqldump # echo "/usr/local/mysql/lib" > /etc/ld.so.conf.d/mysql.conf # cd /usr/local/mysql # ln -s lib lib64 # chkconfig --add mysqld # chkconfig mysqld on