Anybody done the following... I know I have in the past, but different os's and versions of mysql.

Im running debian-small 2.4.26 with mysql 4.0.20.
I have a separate disk-image /dev/ubdd mounted on /usr/db
I moved an existing mysql database directory onto this separate filesystem and then replaced it with a symbolic link like...
mv /usr/local/mysql/var/woodys_db /usr/db/woodys_db
and...
ln -s /usr/db/woodys_db /usr/local/mysql/var/woodys_db

All permissions are sane, but now 'woodys_db' cannot be selected, and does not show up under 'show databases;'

Restarting mysqld doesnt help, and shouldn't matter as I can play around with this directory by moving it about, and once I get it back into place, everything works again without informing mysql of any changes. Anybody doing the same and have any ideas for me.

Your feedback is appreciated, so thanks in advance.
-woody

duh.........

Actually, that's not entirely true.

Permissions were fine for the symbolic link, and for the directory /usr/db/woodys_db however /usr/db had perms=700 and was owned by root. "chown mysql:mysql /usr/db" and "chmod 770 /usr/db" was the trick.

The symlinked database is now accessed without problems.

-woody