How to move mysql data folder to removable hhd drive?

Question

linux

There is Linux Mint 17.3
data is now stored in /var/lib/mysql how
to transfer it to /media/user/HDD/mysql for example ssd on 120gb number for the system and mysql with data takes 30gb and all this will grow

Answer 1

And who's stopping you from mounting an external drive in /var/lib/mysql ?

Answer 2

Mount the disk, copy files from /var/lib/mysql. Then in the file /etc/mysql/mysql.conf.d/mysqld.cnf change the path /var/lib/mysql to a new path to the folder, then in the file /etc/apparmor.d/usr.sbin.mysqld lines

# Allow data dir access
/var/lib/mysql/ r,
/var/lib/mysql/** rwk,
change to a new path, restart apparmor and start the database