[PLUG] Symlinking mysql database

[Walt Mankowski <waltman@pobox.com>]

I'm trying to put a mysql database on a separate partition from the
default /var/lib/mysql.  I created a directory /data/mysql/mcod owned
by mysql.mysql with permissions 755, and symlinked it to
/var/lib/mysql/mcod.

When I've done this before it Just Worked, and "show databases" listed
mcod.  Now I'm not seeing it, and I can't for the life of me figure out
what I'm doing wrong.

Here's what the directories look like:

/data/mysql:
total 12
drwxr-xr-x    3 mysql    mysql        4096 Sep  3 12:48 .
drwxrwx---    5 root     other        4096 Sep  3 12:48 ..
drwxr-xr-x    2 mysql    mysql        4096 Sep  3 12:48 mcod

/data/mysql/mcod:
total 8
drwxr-xr-x    2 mysql    mysql        4096 Sep  3 12:48 .
drwxr-xr-x    3 mysql    mysql        4096 Sep  3 12:48 ..

/var/lib/mysql:
total 16
drwxr-xr-x    4 mysql    mysql        4096 Sep  3 15:48 .
drwxr-xr-x   21 root     root         4096 Aug 26 11:17 ..
lrwxrwxrwx    1 mysql    mysql          17 Sep  3 13:23 mcod -> /data/mysql/mcod/
drwx------    2 mysql    mysql        4096 Sep  2 14:42 mysql
srwxrwxrwx    1 mysql    mysql           0 Sep  2 14:56 mysql.sock
drwx------    2 mysql    mysql        4096 Sep  2 14:42 test

Anyone have any ideas?

Walt

Attachment: pgptZtajhPoVV.pgp
Description: PGP signature