When you create a general tablespace in MySQL 8.0, you can choose the directory where the associated datafile is created.
CREATE TABLESPACE tablespace_name ADD DATAFILE ‘/my/table/space/dir’;
However, that directory must be known to InnoDB. Known directories are defined by the following settings: datadir, innodb_data_home_dir, innodb_undo_directory & innodb_directories.…
Facebook Twitter LinkedIn