I've done this before so I don't see what I could doing wrong here. I'm running mysql 5x on freebsd. I'm using the default data directory of "/var/db/mysql"
In there I have several dozen mysql datasbases that are functioning perfectly. I am trying to add a database which will be stored on a different drive, therefore the entry in "/var/db/mysql" should be a symbolic link
With mysql running I go...
chmod 700 /sata2/database/d1
chown mysql:mysql /sata2/database/d1
Now all I have to do is make a symbolic link and I should be set
ln -s /sata2/database/d1 /var/db/mysql
Change the owner of the symbolic link
chown -h mysql:mysql /var/db/mysql/d1
Doing a directory listing, I see:
lrwxr-xr-x 1 mysql mysql 25 Jun 19 11:24 d1 - /sata2/database/s1
So the symbolic is there and looks to have permissions good. I restart mysql. Mysql does not show the database "d1". It's as if the database isn't there.
Just for testing, I tried making a directory "/var/db/mysql/d2" via command line. OF course, since that is and actual directory, when restarting mysql, mysql see its.
There must be something very simple I am missing here
You need to have AIM or MSN IM to bid on this project. We will use that communicate. You won't get access to the server but can instruct me what to do.
I'm sure this is just something really stupid and simple. You will be paid once we get it sorted out, escrow upon selection of winning bidder.