MySQL Bugs: #30086: Installation program should ask about datadir value on i5OS

Bug #30086	Installation program should ask about datadir value on i5OS
Submitted:	26 Jul 2007 19:34	Modified:	18 Jul 2008 3:30
Reporter:	Valeriy Kravchuk	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S4 (Feature request)
Version:		OS:	Other (IBM i5OS)
Assigned to:		CPU Architecture:	Any

Description:
Installation program for i5OS (part of *SAVF binaries) should:

1. Ask user about datadir to use

and/or

2. Provide/use some subdirectory in /QOpenSys as a default value for datadir.

Now we use data subdirectory of a basedir (/usr/local/mysql, by default). It is OK to use /usr/local as a basedir but all parts of i5OS filesystem outside of /QOpenSys are case-insensitive. So, putting data directory outside /QOpenSys may lead to problems as we use i5OS in PASE (UNIX-like) environment and assume case-sensitive filesystem. That is why we should NOT do it by default.

How to repeat:
Execute show variables like 'lower%' on i5OS. You'll get OFF and 0 for lower_case_file_system and lower_case_table_names respectively, that's why we assume case-sensitive filesystem.

verified on version 5.0 that it is capable of placing the datadir in the QOpenSys directory during install.