FS#9650 - mysqld upgrade break existing configuration

Attached to Project: Arch Linux
Opened by Nicolas Doualot (slubman) - Friday, 22 February 2008, 09:08 GMT
Last edited by Aaron Griffin (phrakture) - Friday, 17 October 2008, 18:57 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Alexander Baldeck (kth5)
Architecture All
Severity High
Priority Normal
Reported Version 2007.08-2
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 1
Private No

Details

Description: Upgrading mysqlq can break an existing mysql configuration and make database connections unavailables

I have configured mysql in /etc/my.cnf with a datadir different from the default one.


Additional info:
* package version(s) : mysql 5.0.51-3


Steps to reproduce:
* Change datadir directory
* Upgrade mysql
* Restart the daemon

Proposed solution:
* Display a message on upgrade about this change.
* Change the way /etc/conf.d/mysqld set options more like other daemon (lighttpd, openttpd ...), so that you can pass COMPLETE option (something like "-d /var/lib/mysql" instead of overwriting the one found in /etc/my.cnf has it does actually.
This task depends upon

Closed by  Aaron Griffin (phrakture)
Friday, 17 October 2008, 18:57 GMT
Reason for closing:  Not a bug
Additional comments about closing:  You can configure MYSQLD_ROOT for the rc.d script in /etc/conf.d/mysqld
Comment by Fabio Varesano (fax8) - Thursday, 03 April 2008, 15:31 GMT
same problem here. with the current startup scripts is impossible to configure a different datadir on the /etc/my.cnf file.

Workaround: you have to add this line at the end of your /etc/rc.conf file:

MYSQLD_ROOT="/path/to/data/dir"
Comment by Glenn Matthys (RedShift) - Friday, 18 July 2008, 15:40 GMT
You can configure MYSQLD_ROOT for the rc.d script in /etc/conf.d/mysqld

Loading...