From: Michael Dykman (mdykmangmail.com)
Date: Fri Jul 06 2007 - 11:05:32 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <douglassagmail.com> 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 <mdykmangmail.com>:
> > 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 <douglassagmail.com> 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 <anandklgmail.com>:
> > > > What i the error you seeing the error log file.
> > > > Please let us know
> > > >
> > > >
> > > >
> > > > On 7/5/07, Douglas Araujo <douglassagmail.com> 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/mysql?unsub=anandklgmail.com
> > > > >
> > > > >
> > > >
> > > >
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdykmangmail.com
> > >
> > >
> >
> >
> > --
> > - michael dykman
> > - mdykmangmail.com
> >
> > - All models are wrong. Some models are useful.
> >
>

--
 - michael dykman
 - mdykmangmail.com

 - All models are wrong. Some models are useful.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]