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:nh...@partsauthority.com] Sent: Monday, January 03, 2011 10:16 AM To: talk@lists.nyphp.org Subject: [nyphp-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
_______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
