Search the MySQL manual:

5.6.1 Using Symbolic Links

You can move tables and databases from the database directory to other locations and replace them with symbolic links to the new locations. You might want to do this, for example, to move a database to a file system with more free space or increase the speed of your system by spreading your tables to different disk.

The recommended way to do this, is to just symlink databases to a different disk and only symlink tables as a last resort.

Subsections

User Comments

Posted by Biju GC on Saturday November 16 2002, @8:31pm[Delete] [Edit]

I feel MySQL should include LINK statment like the
one in ORACLE to do Distributed Database.
Something like MS-Access which can connect to any
ODBC will be fine.

Add your own comment.