2.3.4.7. The InnoDB Tablespace Dialog
Some users may want to locate the InnoDB
tablespace files in a different location than the MySQL server
data directory. Placing the tablespace files in a separate
location can be desirable if your system has a higher capacity
or higher performance storage device available, such as a RAID
storage system.
To change the default location for the
InnoDB
tablespace files, choose a new drive
from the drop-down list of drive letters and choose a new path
from the drop-down list of paths. To create a custom path,
click the ... button.
If you are modifying the configuration of an existing server,
you must click the Modify button before
you change the path. In this situation you must move the
existing tablespace files to the new location manually before
starting the server.