How to Modification a MariaDB/MySQL Data Directory Site to a New Area on Linux

Action 1– Moving the MariaDB Data Directory Site

 mysql -u root -p.

 choose @@ datadir;.

 Output:.
+ -----------------+.
| @@ datadir |
+ -----------------+.
|/ var/lib/mysql/ |
+ -----------------+.
1 row in set (0.00 sec).

 exit.

 sudo systemctl stop mariadb.
sudo systemctl status mariadb.

 Output:.
mysql systemd[1]: Stopped MariaDB database server.

 sudo rsync -av/ var/lib/mysql/ mnt/my-volume -01.

 sudo mv/ var/lib/mysql/ var/lib/mysql. bak.

Action 2– Indicating the New Data Area

 sudo vi/ etc/my. cnf.

[mysqld]
...
datadir=/ mnt/my-volume -01/ mysql.
socket=/ mnt/my-volume -01/ mysql/mysql. sock.
...

[client]
port= 3306.
socket=/ mnt/my-volume -01/ mysql/mysql. sock.

! includedir/ etc/my. cnf.d.

Action 3– Rebooting MariaDB

 sudo systemctl start mariadb.
sudo systemctl status mariadb.

 mysql -u root -p.

 choose @@ datadir;.

 Output.
+ ----------------------------+.
| @@ datadir |
+ ----------------------------+.
|/ mnt/my-volume -01/ mysql/ |
+ ----------------------------+.
1 row in set (0.01 sec).