New Consistency for Datafile Locations in MySQL 8.0.21
New Consistency for Datafile Locations in MySQL 8.0.21 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 Source: New Consistency for Datafile Locations in MySQL 8.0.21