1

Current config:

[mysqld]
datadir=/data/mysql
log-bin=test

Updated config:

[mysqld]
datadir=/data/mysql
log-bin=/binlogdata/test
log-bin-index=/binlogdata/test.index

What I did was:

  1. Stop mysql service
  2. Update my.cnf
  3. Move the current binlogs to destination path using:
mv /data/dir/test.* /binlogdata/
  1. Update /etc/apparmor.d/usr.sbin.mysqld I added /binlogdata/** rw
  2. Reload apparmor
  3. I excecuted chown on binlogdata
chown -R mysql:mysql /binlogdata
  1. Start mysql service

Error on /var/log/mysql/error.log is

mysqld got signal 11 ;
1
  • show the full log from the startup.
    – danblack
    Feb 9, 2021 at 6:02

1 Answer 1

0

I already got it to work after I added the 3rd line.

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.