mysql, centOS, mysql 경로 변경

$ mysql -uroot -p
mysql>show variables like 'datadir';
---
/var/lib/mysql/
---
$ service mysql stop
$ mkdir /home/mysql
$ cp -r /var/lib/mysql/ /home/
$ chown -R mysql:mysql /home/mysql/
$ vi /etc/my.cnf.d/server.cnf
---
"[mysqld]
datadir = /home/mysql"
---
$ service mysql start
$mysql -uroot -p
mysql>show variables like 'datadir';
---
/var/lib/mysql/
---

댓글