I am using the Fileserver, TurnKey Linux 12.0 / Debian 6.0.5 Squeeze version.
I have installed mysql-server on this appliance which runs happily.
Due to space constraints on the server, I would like to change the default location of mysql databases (currently under /var/lib/mysql) to another directory, for example, to /srv/storage/mysqldb.
I have followed a number of tutorials to make this change, but every single time mysql fails to start with the changed configuration. If I go back to the default config, mysql fires up easily.
Is there a trick I should know about to do this? For example, Ubuntu has apparmor installed which prevents changes to mysql data location. Wondering if there is an equivalent of apparmor in Fileserver, such as SELinux (I could not find anything installed though)?
On the Fileserver appliance, try as I might I cannot make mysql start if I change the default location of its database.
Any help gratefully accepted!