LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   Problems relocating MySQL Binlog files errcode :13 when restarting service (http://www.linuxquestions.org/questions/linux-software-2/problems-relocating-mysql-binlog-files-errcode-13-when-restarting-service-4175417599/)

Alexrkkl 07-19-2012 08:51 AM

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

chrism01 07-19-2012 07:18 PM

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

Alexrkkl 07-20-2012 03:02 AM

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

Quote:

Originally Posted by chrism01 (Post 4733222)
You don't mention editing the mysql.cnf file to match, so the prog knows where to find them...



All times are GMT -5. The time now is 04:04 AM.