Move Mysql 8.X Data Directory on Ubuntu 1804
Moving Data Directory
systemctl stop mysql
rsync -av /var/lib/mysql /data
mv /var/lib/mysql /var/lib/mysql.bk
Modify configuration
vim /etc/mysql/mysql.conf.d/mysqld.cnf
# change datadir= to another directory
Configuring AppArmor Access Control Rules
vim /etc/apparmor.d/tunables/alias
# add alias /var/lib/mysql/ -> /data/mysql/,
systemctl restart apparmor
Restarting Mysql
referance: https://www.digitalocean.com/community/tutorials/how-to-move-a-mysql-data-directory-to-a-new-location-on-ubuntu-16-04
