Thanks for the help Michael,
The data directory is really configured to /var/lib/mysql, and the
database name is area2.
I'm mounting the subdirectory of the database.
When I mount the nfs file system I don't get any error.
Thanks,
Douglas
2007/7/6, Michael Dykman <[EMAIL PROTECTED]>:
Let me
Let me see if I follow this:
your configured data directory is
datadir = /var/lib/mysql
and the database you are trying to browse is names 'area2'. Is this correct?
Is the entire datadir mounted on the external host? Or have you just
tried to mount the database/subdirectory?
If the former, ev
The results:
$ ls -ld /var/lib/mysql/area2/
drwxr-xr-x 2 mysql mysql 8192 Jul 6 11:48 /var/lib/mysql/area2/
$ ls -ld /var/lib/mysql/area2/*
-rwxrwxrwx 1 mysql mysql 0 Set 15 2006 /var/lib/mysql/area2/449
-rw-rw 1 mysql mysql9202 Jun 29 2006 /var/lib/mysql/area2/cadAIH.frm
-rw-
Again, I have no light-bulb on this but let's try a few things.
if you do
$ ls -ld /var/lib/mysql/area2
$ ls -ld /var/lib/mysql/area2/*
on your mySQL host, what are the permissions and ownership of the
files? These can get a little tricky under NFS as th on-disk file
will store the owner's UID.
There is no error in log file, the server just don't show me the
database on the directory /var/lib/mysql/area2. If I go in this
directory with the cd command and give a "ls" command, I see the
files, but the mysqld don't recognizes the database files.
Thanks,
Douglas
2007/7/6, Ananda Kumar <[E
What i the error you seeing the error log file.
Please let us know
On 7/5/07, Douglas Araujo <[EMAIL PROTECTED]> wrote:
Hi everybody,
I have a MySQL 4.1 running on a Red Hat Linux Enterprise 4 that the
databases directory is the default point, /var/lib/mysql.
I have a NFS mount point in /va
Hi everybody,
I have a MySQL 4.1 running on a Red Hat Linux Enterprise 4 that the
databases directory is the default point, /var/lib/mysql.
I have a NFS mount point in /var/lib/mysql/area2, that mounts the
directory of a storage, when I mount the NFS, the MySQL server don't
show the database.
A