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 <nh...@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
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
