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.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
