MySQL 9.3 Reference Manual Including MySQL NDB Cluster 9.3
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.