Problems relocating MySQL Binlog files errcode :13 when restarting service
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.
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.
|All times are GMT -5. The time now is 02:46 AM.|