Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual 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.

MySQL Server Instance Configuration Wizard: InnoDB Data Tablespace

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.

Download this Manual
User Comments
  Posted by 庭豐 石 on November 18, 2013
I have no idea why only InnoDB tablespace files are given a chance to be moved to other place if it's about *higher disk capacity or performance*.

Users should be warned that all the other database files are still in the default location, that is at
C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\data
whatever path they should in this screen.

Sign Up Login You must be logged in to post a comment.