Problems relocating MySQL Binlog files errcode :13 when restarting service
 

Hi guys,

What I am trying to do is relocate my binary logs to get written to a new drive as my default drive is becoming full, I have mounted to the /home folder. I am using RHEL6.

When I try restart the server the error log comes up with:

'/home/mysql-bin.~rec~' not found (Errcode: 13)
I have heard errorcode 13 is permissions but, I have moved my bin-log.index here and all my binlogs and I have issued chmod -R 777 on the files and chown -R mysql:mysql. When I issue ls -l you can see that the files all have the read,write,excute permissions and are owned by mysql but still no luck starting the service.

The steps to move the binlogs I have taken so far also include changing the bin-log.index file so changing ./bin-log.000001 to /new/location/bin-log.000001. Is this the correct thing to do ?

Also my replication is configured as a single master to many slaves, are there any changes I need to make to the slaves when I move the binary log files?

Thanks in advance.

Alex

You don't mention editing the mysql.cnf file to match, so the prog knows where to find them...

Sorry, Yeah I have changed the my.cnf file entry from log-bin=mysql-bin to log-bin=/home/mysql-bin.