Documentation Home
MySQL 5.5 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 27.1Mb
PDF (A4) - 27.2Mb
PDF (RPM) - 26.0Mb
HTML Download (TGZ) - 6.5Mb
HTML Download (Zip) - 6.5Mb
HTML Download (RPM) - 5.6Mb
Man Pages (TGZ) - 170.8Kb
Man Pages (Zip) - 279.3Kb
Info (Gzip) - 2.6Mb
Info (Zip) - 2.6Mb
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.

Figure 2.27 InnoDB Tablespace

MySQL Server Instance Configuration Wizard: Set the 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.

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.