ID: 50595 User updated by: tallyce at gmail dot com Reported By: tallyce at gmail dot com -Status: Feedback +Status: Open Bug Type: Feature/Change Request Operating System: Windows7 PHP Version: 5.3.1 New Comment:
In my case, the data files are too big to fit on the C: driver, so placing them in the MySQL subdirectory (under program files) is not an option. So, the "datadir" setting in my.ini is set to be elsewhere. (In the end I used a Windows7 symlink as a workaround, but this feels like a rather unsatisfactory hack.) I don't know which settings are still read by the MySQL server process, but this one at least is ignored by PHP. Either way, it seems odd that one should go through the process of setting up and tuning a MySQL server and then have the key program that reads the data simply ignore the settings, following the release of PHP 5.3.x. Previous Comments: ------------------------------------------------------------------------ [2009-12-29 12:12:45] johan...@php.net Which settings would you actually need to set for the client in my.cnf? - The server will read it's settings anyways. ------------------------------------------------------------------------ [2009-12-28 19:53:21] tallyce at gmail dot com Description: ------------ http://au2.php.net/manual/en/migration53.incompatible.php states that the Mysqlnd driver doesn't read the my.ini file but instead that mysqli_options() should be used to tell PHP about settings. Can I plead the developers to have a mysqlnd.inifile option or similar? This latest change is very regressive: it means that, for instance, if your database files are stored in a non-standard location, e.g. a data rather than OS C: disk (as specified in my.ini), or any other performance-related setting, these all have to be manually added to script files, making them completely non-portable, or editing through third-party apps (making it time-consuming to upgrade). If such an ini option were added, might it just be a case of just parsing the specified file and passing the found values into whatever interface mysqli_options is using? Reproduce code: --------------- n/a Expected result: ---------------- n/a Actual result: -------------- n/a ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=50595&edit=1
