MySQL 8.3 Release Notes
On Unix, symlink a database using this procedure:
-
Create the database using
CREATE DATABASE
:mysql> CREATE DATABASE mydb1;
Using
CREATE DATABASE
creates the database in the MySQL data directory and permits the server to update the data dictionary with information about the database directory. -
Stop the server to ensure that no activity occurs in the new database while it is being moved.
-
Move the database directory to some disk where you have free space. For example, use tar or mv. If you use a method that copies rather than moves the database directory, remove the original database directory after copying it.
-
Create a soft link in the data directory to the moved database directory:
$> ln -s /path/to/mydb1 /path/to/datadir
The command creates a symlink named
mydb1
in the data directory. -
Restart the server.