How to migrate mysql storage location to a new disk

]#fdisk -l # View disk information ]#fdisk /dev/sdb # Partition ]# df -T # You can view the file system type of the root partition ]#mkfs.xfs /dev/sdb1 # Format the new disk partition ]#mkdir /data
]#mount /dev/sdb1 /data #Mount the disk or write to the /etc/fatab file, add a line: /dev/sdb1 /data xfs defaults 0 0 Automatically mount at boot]#df -h //Confirm the mount result

]#systemctl stop mysqld
]#vim /etc/my.cnf

   datadir=/data/mysql
   socket=/data/mysql/mysql.sock
   log-error=/data/log/mysqld.log 
   log_bin=/data/mysql/bin-log
   log-bin-index=/data/mysql/bin-log.index
  [client]
   socket=/data/mysql/mysql.sock #The mysql client sock reads /var/lib/mysql/mysql.sock by default, so you need to add the client sock configuration in the configuration file.
  ]#vim /data/mysql/bin-log.index

]#chown -R mysql:mysql /data
]#mkdir /data/log
]#mv /usr/lib/mysql /data/

]#systemctl start mysqld
Enter the database mysql >show variables like 'datadir';
#You can see the storage location of the database and check whether the data is correct.
mysql>show variables like '%sock%';
#Check the location of the sock file, or check whether the data in the corresponding directory /data/ is correct.