-SOLVED- SymLinked selected MySQL Databases
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/woodysdb /usr/db/woodysdb
and…
ln -s /usr/db/woodysdb /usr/local/mysql/var/woodysdb
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
1 Reply
> All permissions are sane, but now 'woodys_db' cannot be selected, and does not show up under 'show databases;'
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