How to change location of database files in MySQL 8.0?

Question

MySQL

My computer has MySQL 8.0 server installed. A separate HDD was allocated for the database files. How can I make sure that the files of this database are on a new separate hard drive, and the MySQL server itself remains on the old drive? It is necessary that ONLY the database files without any garbage lie on the new disk.

Answer 1

- correctly stop the database
- make sure that the database is not running
- copy the entire datadir (see the mysql configuration file) to a new location
- change the datadir in the config to a new location
- start the database
- check the success and demolish the old datadir

Answer 2

File my.cnf
datadir=/data/mysql - write the path where you need

Answer 3

Option --datadir , it is also in the config file. datadir
system variable