I can't change the place of binlog.
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
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.