Re: NFS database

2007-07-06 Thread Douglas Araujo
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

Re: NFS database

2007-07-06 Thread Michael Dykman
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

Re: NFS database

2007-07-06 Thread Douglas Araujo
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-

Re: NFS database

2007-07-06 Thread Michael Dykman
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.

Re: NFS database

2007-07-06 Thread Douglas Araujo
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

Re: NFS database

2007-07-05 Thread Ananda Kumar
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

NFS database

2007-07-05 Thread Douglas Araujo
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