Đang Thực Hiện

152865 mysql database as symbolic lin

Hi,

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 thêm: sorted data set, mysql data access, db escrow, get data entry done, symbolic, ln, freebsd, mysql running, chown, mysql data directory, simple project using database, system using access database, 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, using access database, data entry system mysql, simple database system access

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

Mã Dự Án: #1899046

Đã trao cho:

arikaterin

Hello, please check PM. Regards, Sergey.

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