mysql/mairadb 저장경로 변경하기

sudo systemctl stop mariadb

​

sudo mkdir /home/DBdata/

sudo rsync -av /var/lib/mysql /home/DBdata/

sudo chown -R mysql:mysql /home/DBdata/mysql

​

sudo vi /etc/my.cnf

[mysqld] datadir=/home/DBdata/mysql

 

sudo semanage fcontext -a -t mysqld_db_t "/home/DBdata/mysql(/.*)?"

sudo restorecon -R /home/DBdata/mysql

sudo systemctl start mairadb

​

 vi /usr/lib/systemd/system/mariadb.service (ProtectHome=false)