NYCPHP Meetup

[William Klein]

If it's just the data path it's very easy to just make a symbolic link to
the new volume in the default directory.  That way you can even have
different databases on different volumes.

 

From: Nicholas Hart [mailto:nhart at partsauthority.com] 
Sent: Monday, January 03, 2011 10:16 AM
To: talk at lists.nyphp.org
Subject: [nycphp-talk] set datadir in mysql config

 

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/8f485fbb/attachment.html>