Bug #26365 install ignores alternative data folder

• Submitted: 14 Feb 2007 11:31
• Modified: 15 Feb 2007 10:30
• Reporter: Paul Igoe
• Status: Duplicate
• Category: MySQL Server: Installing
• Severity: S3 (Non-critical)
• Version: 5.0.27
• OS: Windows (Windows 2003 / XP)
• CPU Architecture: Any
• Tags: datadir, install, Tablespace

[14 Feb 2007 11:31] Paul Igoe

Description:

Performed clean install of MySQL Server 5.0.27 on both Windows Server 2003 and XP Pro.
In both cases specified non-default location in the 'InnoDB TableSpace Settings' in the MySQL Server Instance Configuration Wizard. On the 2003 Server I specified a different drive. On XP same drive (C:\) but different folder. In both cases this was ignored and saw data files created in c:\<Installation Path>\data. Also in c:\<Installation Path>\my.ini, datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

How to repeat:

1. Perform clean install
2. Specify non-default tablespace location
3. Check actual tablespace location post-install.

Suggested fix:

Workaround:

1. After install stop the mysql service
2. Edit c:\<Installation Path>\my.ini to set datadir to preferred location
3. Copy c:\<Installation Path>\data\* to preferred location
4. start mysql servive

[15 Feb 2007 10:30] Paul Igoe

Oops, looks like this is a duplicate of Bug #10012 - marking as dup