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 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, everything looks just fine from here; you might check permissions/ownership on '/var/lib/mysql' too.. if it looks like the output you showed me above, then it really should work. If the latter, I could see some interesting interactions which might cause an issue... Perhaps the relevant output from $ mount -a would shed some light. On 7/6/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: > 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 mysql 9202 Jun 29 2006 /var/lib/mysql/area2/cadAIH.frm > -rw-rw---- 1 mysql mysql 1057792 Jul 3 2006 /var/lib/mysql/area2/cadAIH.MYI > -rw-rw---- 1 mysql mysql 8714 Mai 22 2006 /var/lib/mysql/area2/cadCid.frm > -rw-rw---- 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/cadCid.MYD > -rw-rw---- 1 mysql mysql 0 Mai 29 2006 /var/lib/mysql/area2/cadCid.MYI > -rw-rw---- 1 mysql mysql 8930 Mai 22 2006 > /var/lib/mysql/area2/cadHospital.frm > -rw-rw---- 1 mysql mysql 0 Mai 22 2006 > /var/lib/mysql/area2/cadHospital.MYD > -rw-rw---- 1 mysql mysql 0 Mai 29 2006 > /var/lib/mysql/area2/cadHospital.MYI > -rw-rw---- 1 mysql mysql 8800 Mai 22 2006 > /var/lib/mysql/area2/cadMunicipio.frm > -rw-rw---- 1 mysql mysql 0 Mai 22 2006 > /var/lib/mysql/area2/cadMunicipio.MYD > -rw-rw---- 1 mysql mysql 0 Mai 29 2006 > /var/lib/mysql/area2/cadMunicipio.MYI > -rw-rw---- 1 mysql mysql 8782 Mai 22 2006 > /var/lib/mysql/area2/tabArquivo.frm > -rw-rw---- 1 mysql mysql 0 Mai 22 2006 > /var/lib/mysql/area2/tabArquivo.MYD > -rw-rw---- 1 mysql mysql 1024 Mai 22 2006 > /var/lib/mysql/area2/tabArquivo.MYI > -rw-rw---- 1 mysql mysql 8970 Mai 22 2006 /var/lib/mysql/area2/tabCampo.frm > -rw-rw---- 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabCampo.MYD > -rw-rw---- 1 mysql mysql 1024 Mai 22 2006 /var/lib/mysql/area2/tabCampo.MYI > -rw-rw---- 1 mysql mysql 8690 Mai 22 2006 /var/lib/mysql/area2/tabLog.frm > -rw-rw---- 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabLog.MYD > -rw-rw---- 1 mysql mysql 1024 Mai 22 2006 /var/lib/mysql/area2/tabLog.MYI > -rw-rw---- 1 mysql mysql 8794 Mai 22 2006 /var/lib/mysql/area2/tabMenu.frm > -rw-rw---- 1 mysql mysql 0 Mai 22 2006 /var/lib/mysql/area2/tabMenu.MYD > -rw-rw---- 1 mysql mysql 1024 Mai 22 2006 /var/lib/mysql/area2/tabMenu.MYI > -rw-rw---- 1 mysql mysql 8638 Mai 22 2006 /var/lib/mysql/area2/tabSenha.frm > -rw-rw---- 1 mysql mysql 8652 Mai 22 2006 > /var/lib/mysql/area2/tabSenhaModulo.frm > -rw-rw---- 1 mysql mysql 200 Jul 24 2006 > /var/lib/mysql/area2/tabSenhaModulo.MYD > -rw-rw---- 1 mysql mysql 0 Ago 3 2006 > /var/lib/mysql/area2/tabSenhaModulo.MYI > -rw-rw---- 1 mysql mysql 216 Jul 24 2006 /var/lib/mysql/area2/tabSenha.MYD > -rw-rw---- 1 mysql mysql 0 Ago 3 2006 /var/lib/mysql/area2/tabSenha.MYI > -rw-rw---- 1 mysql mysql 8656 Mai 22 2006 > /var/lib/mysql/area2/tabUsuario.frm > -rw-rw---- 1 mysql mysql 0 Mai 22 2006 > /var/lib/mysql/area2/tabUsuario.MYD > -rw-rw---- 1 mysql mysql 1024 Mai 22 2006 > /var/lib/mysql/area2/tabUsuario.MYI > > These was the results, I will look up for the informations of the user > mysql on the storage. > > Thanks for the help, > > Douglas > > > 2007/7/6, Michael Dykman <[EMAIL PROTECTED]>: > > 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. That UID may have different meaning on > > the file host as opposed to the SQL host if the users and groups are > > not synchronized between those hosts. > > > > - michael > > > > On 7/6/07, Douglas Araujo <[EMAIL PROTECTED]> wrote: > > > 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 <[EMAIL PROTECTED]>: > > > > 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 /var/lib/mysql/area2, that mounts the > > > > > directory of a storage, when I mount the NFS, the MySQL server don't > > > > > show the database. > > > > > > > > > > Anyone can help me? > > > > > > > > > > Thanks, > > > > > > > > > > Douglas > > > > > > > > > > -- > > > > > MySQL General Mailing List > > > > > For list archives: http://lists.mysql.com/mysql > > > > > To unsubscribe: > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > -- > > - michael dykman > > - [EMAIL PROTECTED] > > > > - All models are wrong. Some models are useful. > > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]