[prev in list] [next in list] [prev in thread] [next in thread] 

List:       nyphp-talk
Subject:    Re: [nyphp-talk] set datadir in mysql config
From:       Glenn <glenn310b () mac ! com>
Date:       2011-01-04 1:28:11
Message-ID: 7CA84DBD-273B-493C-8093-1EB43C0C779B () mac ! com
[Download RAW message or body]

I don't have a definitive answer but I got curious and found this.

http://forums.admon.org/databases/8130-error-1018-hy000-cant-read-dir-errno-24-a.html

So maybe there is an issue where files are not closing properly.
...and restarting mysql reset the open files counter?

or something like that?

HTH,

Glenn

On Jan 3, 2011, at 10:15 AM, Nicholas Hart wrote:

> I am trying to configure mysql to use a different datadir than  
> default in order to move this to a larger volume.  I have copied all  
> mysql data from /var/lib/mysql to my new volume and ran both chown - 
> R mysql:mysql * and chmod -R 660 *  in order to setup correct  
> ownership and rights for the data.  It was working for a few days  
> until today upon going into mysql and typing show databases, I  
> receive the following error:  ERROR 1018 (HY000): Can't read dir of  
> '.' (errno: 24).  I quickly double checked my rights and found them  
> to be correct, then I restarted mysqld and this has fixed it for now.
>
> Has anyone else run into this problem?  I am concerned that it will  
> happen again if the actual cause is not corrected.  I am running the  
> latest Fedora on new quad core Dell hardware with 24GB RAM and 1.7TB  
> of disk.   Any help and/or suggestions much appreciated.  Thanks.
>
> Nick
> _______________________________________________
> New York PHP Users Group Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> http://www.nyphp.org/Show-Participation

_______________________________________________
New York PHP Users Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

http://www.nyphp.org/Show-Participation
[prev in list] [next in list] [prev in thread] [next in thread]