NYCPHP Meetup

[forest mars]

Nick,

Just off the top of my head a few questions:

1. what is the output of mysqld -help (same error?)

2. what is the output of show variables like 'open_files_limit'

3. did you reload your apparmor profile?


However my best guess, based on what you wrote, is that you need to add your
db path to usr.sbin.mysql


HTH,

~  Forest Mars









On Mon, Jan 3, 2011 at 10:15 AM, Nicholas Hart <nhart at partsauthority.com>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
>



-- 
-- 
"In theory, theory and practice are exactly the same.
In practice, they're completely different."
------------------------------------------------------------------
This email is:
[   ]  private: do not forward
[ x ]  o.k. to forward
[   ]  o.k. to blog
[   ] ask first
-----BEGIN PGP SIGNATURE-----
Version: PGPsdk version 1.7.1 (C) 1997-1999 Network Associates, Inc. and its
affiliated companies. (Diffie-Helman/DSS-only version)

iQA/AwUBRkjTLDbz7LySoccvEQJDcQCguZZj4M4kOVOlOX4CtbgR0rppsdovAjra
3RRXIlkdzuYI0YJz4WyvKlTn
=MLhk
-----END PGP SIGNATURE-----
------------------------------------------------------------------
The New TLDs are Here!
Switch to Name.Space: http://namespace.org/switch
Support new domains & keep free media free! Register yours today!
https://secure.name-space.com/registry
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20110103/5b8179ee/attachment.html>