Mysql data 디렉토리 변경 방법

[root@]# /opt/mysql/share/mysql/mysql.server stop

[root@]# mkdir /home/mysql

[root@]# chown mysql.mysql /home/mysql/

[root@]# rsync -av /opt/mysql/var /home/mysql

 

[root@]# vim /etc/my.cnf 수정

[mysqld]

datadir=/home/mysql/var

socket=/tmp/mysql.sock

[mysql]

socket=/tmp/mysql.sock

 

 

mysql.server 수정

vim /opt/mysql/support-files/mysql.server

basedir=/opt/mysql

datadir=/home/mysql/var

[root@]# /opt/mysql/support-files/mysql.server start   

                                                                                                                                                                                                       

[root@]# ps -ef | grep mysqld

root     20146     1  0 16:00 pts/0    00:00:00 /bin/sh /opt/mysql/bin/mysqld_safe --datadir=/home/mysql/var --pid-file=/home/mysql/var/q361-2383.cafe24.com.pid

mysql    20285 20146  0 16:00 pts/0    00:00:00 /opt/mysql/bin/mysqld --basedir=/opt/mysql --datadir=/home/mysql/var --plugin-dir=/opt/mysql/lib/plugin --user=mysql --log-error=/home/mysql/var/q361-2383.cafe24.com.err --pid-file=/home/mysql/var/q361-2383.cafe24.com.pid --socket=/tmp/mysql.sock