How to Change MySQL Data Directory in Linux Centos
By default Linux CentOS or other Linux Distro installation, MySQL data directory is stored in /var/db/mysql, how can I change it to other directory in example /db/mysql?
It is always better to have MySQL Data Directory store in a specific partition/drive. It will help on performance and better management and scalability. You change change the data store directory in Linux by editing /etc/my.cnf file.
Edit /etc/my.cnf file
# vi /etc/my.cnf
Change the data directory structure
After the file has been updated, restart MySQL service.