Đã hoàn thành

152865 mysql database as symbolic lin


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...

mkdir /sata2/database/d1

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.

Kĩ năng: Bất kì công việc gì, MySQL, Quản trị hệ thống

Xem nhiều hơn: when is escrow paid out, what is database entry, sorted data set, mysql data access, db escrow, when do i get a data entry done, symbolic, ln, freebsd, mysql running, chown, mysql data directory, simple project using database, system using access database, simple system using database access, aim data entry, testing access database, data entry directory listing, simple system database access, link access database, mysql mkdir, simple project database access, mysql database selection, directory database system, database admin mysql

Về Bên Thuê:
( 13 nhận xét )

ID dự án: #1899046

Được trao cho:


Hello, please check PM. Regards, Sergey.

$10 USD trong 1 ngày
(2 Đánh Giá)