[Novalug] Ubuntu upgrade question

[Daniel Chen]

On Tue, Jul 6, 2010 at 9:24 AM, Bonnie Dalzell <bdalzell at qis.net> wrote:
> Is there a way to set mysql up so that it stores the datafiles somewhere
> in the /home/* subdirectory string so it is protected during installation.

You can achieve this *after* installing the relevant mysql* packages,
but you can't do this *at* install-time.  Doing so requires stopping
the mysql-server service, editing the necessary conffiles (namely
passwd(5); see also getent(1)), moving the necessary directories from
/var/lib to /home, checking permissions, and so on.

-Dan