NYCPHP Meetup

NYPHP.org

[nycphp-talk] set datadir in mysql config

Nicholas Hart nhart at partsauthority.com
Mon Jan 3 10:15:50 EST 2011


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20110103/c306117a/attachment.html>


More information about the talk mailing list