MySQL Forums
Forum List  »  Install & Repo

I can't change the place of binlog.
Posted by: Jurandyr Fonseca Alves Jura
Date: April 25, 2025 08:50AM

Hi,

I can't chenge the place of binlog.

I did this congirugarations.

# Bin Logs
log-bin=/devsqllog/databin
log-bin-index=/devsqllog/databin/binlog.index

I did shutdown in mysql than

cp /var/lib/mysql/binlog.* /devsqllog/databin/

than

start mysql

but I receive the error message

2025-04-25T14:23:15.397369Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.5) starting as process 923474
mysqld: File '/devsqllog/databin/binlog.index' not found (OS errno 13 - Permission denied)
2025-04-25T14:23:15.400597Z 0 [ERROR] [MY-010119] [Server] Aborting

drwxr-xr-x 6 mysql mysql 72 Apr 25 09:51 .
drwxr-xr-x 25 root root 4096 Apr 14 11:15 ..
drwxr-xr-x 2 mysql mysql 4096 Apr 25 11:13 databin
drwxr-xr-x 2 mysql mysql 6 Apr 24 16:36 redolog01
drwxr-xr-x 2 mysql mysql 6 Apr 24 16:36 redolog02
drwxr-xr-x 2 mysql mysql 6 Apr 24 16:36 redolog03mysql@hml-sian-a019:/devsqllog$ cd databin
mysql@hml-sian-a019:/devsqllog/databin$ ls -la
total 92
drwxr-xr-x 2 mysql mysql 4096 Apr 25 11:13 .
drwxr-xr-x 6 mysql mysql 72 Apr 25 09:51 ..
-rwxr-xr-x 1 mysql mysql 505 Apr 25 11:13 binlog.000001
-rwxr-xr-x 1 mysql mysql 181 Apr 25 11:13 binlog.000002
-rwxr-xr-x 1 mysql mysql 644 Apr 25 11:13 binlog.000003
-rwxr-xr-x 1 mysql mysql 158 Apr 25 11:13 binlog.000004
-rwxr-xr-x 1 mysql mysql 158 Apr 25 11:13 binlog.000005
-rwxr-xr-x 1 mysql mysql 158 Apr 25 11:13 binlog.000006
-rwxr-xr-x 1 mysql mysql 158 Apr 25 11:13 binlog.000007
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000008
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000009
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000010
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000011
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000012
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000013
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000014
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000015
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000016
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000017
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000018
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000019
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000020
-rw-r----- 1 mysql mysql 500 Apr 25 11:13 binlog.000021
-rw-r----- 1 mysql mysql 336 Apr 25 11:13 binlog.index
mysql@hml-sian-a019:/devsqllog/databin$

I don't seem permissions problems.

Can you help me please?

Thank's

Options: ReplyQuote


Subject
Written By
Posted
I can't change the place of binlog.
April 25, 2025 08:50AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.