|
[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
|
Re: [PLUG] Symlinking mysql database
|
I ran into a the same issue some time ago. I worked around it by first
creating the database in the SQL interface. I then removed the directory
from /var/lib/mysql and created the soft link. I don't know why your
method doesn't work.
On the 3rd day of September in the year 2003 you wrote:
> Date: Wed, 3 Sep 2003 15:53:15 -0400
> From: Walt Mankowski <waltman@pobox.com>
> To: plug@lists.phillylinux.org
> Subject: [PLUG] Symlinking mysql database
>
> I'm trying to put a mysql database on a separate partition from the
> default /var/lib/mysql. I created a directory /data/mysql/mcod owned
> by mysql.mysql with permissions 755, and symlinked it to
> /var/lib/mysql/mcod.
>
> When I've done this before it Just Worked, and "show databases" listed
> mcod. Now I'm not seeing it, and I can't for the life of me figure out
> what I'm doing wrong.
>
> Here's what the directories look like:
>
> /data/mysql:
> total 12
> drwxr-xr-x 3 mysql mysql 4096 Sep 3 12:48 .
> drwxrwx--- 5 root other 4096 Sep 3 12:48 ..
> drwxr-xr-x 2 mysql mysql 4096 Sep 3 12:48 mcod
>
> /data/mysql/mcod:
> total 8
> drwxr-xr-x 2 mysql mysql 4096 Sep 3 12:48 .
> drwxr-xr-x 3 mysql mysql 4096 Sep 3 12:48 ..
>
> /var/lib/mysql:
> total 16
> drwxr-xr-x 4 mysql mysql 4096 Sep 3 15:48 .
> drwxr-xr-x 21 root root 4096 Aug 26 11:17 ..
> lrwxrwxrwx 1 mysql mysql 17 Sep 3 13:23 mcod -> /data/mysql/mcod/
> drwx------ 2 mysql mysql 4096 Sep 2 14:42 mysql
> srwxrwxrwx 1 mysql mysql 0 Sep 2 14:56 mysql.sock
> drwx------ 2 mysql mysql 4096 Sep 2 14:42 test
>
> Anyone have any ideas?
>
> Walt
>
_________________________________________________________________________
Philadelphia Linux Users Group -- http://www.phillylinux.org
Announcements - http://lists.netisland.net/mailman/listinfo/plug-announce
General Discussion -- http://lists.netisland.net/mailman/listinfo/plug
|
|