I'm trying to move my binary log files onto a different drive than our main data drive to get a little performance boost. the drives are set up like so: drive 1 (sda): swap /boot /usr drive 2 (sdb): / mysql is installed in /usr/local/mysql and its data directory is /usr/local/mysql/var I want to set the binary logs to go to the 2nd drive, sdb, so I made a new directory, /logging I went into logging and changed its ownership and group to mysql... chown -R mysql . chgrp -R mysql . [EMAIL PROTECTED] logging]# pwd /logging [EMAIL PROTECTED] logging]# ls -al total 8 drwxr-xr-x 2 mysql mysql 4096 Aug 24 04:26 . drwxr-xr-x 23 root root 4096 Aug 24 04:53 .. then went into my.cnf and put: log-bin=/logging but when I try to start mysql this way: [EMAIL PROTECTED] mysql]# bin/mysqld_safe --user=mysql &
no logging, and I get this in the .err file 040824 5:46:53 Could not use /logging for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. error 13 is typically a unix permissions error, right? but I changed the /logging directory to be owned by mysql (and am running mysqld_safe --user=mysql) any ideas? thanks, -L Luke Crouch 918-461-5326 [EMAIL PROTECTED]
