.::: Move log_bin_basename (mysqlbinlogs) MariaDB / MySQL using symlink relink symbolic link :::.

 

A. capture before 

1.check mariadb version

2. check log_bin_basename 

SHOW VARIABLES WHERE Variable_name IN ('datadir','basedir','log_bin_basename');

 

3. check before move datadir 
 
B. move log_bin_basename 
 
1. create new log_bin_basename 

[root@teguhth ~]# mkdir -p /data/mysqlbinlogs
[root@teguhth ~]#
[root@teguhth ~]# chown mysql:mysql /data/mysqlbinlogs/
[root@teguhth ~]#

2. stop mariadb service 

systemctl stop mariadb

[root@teguhth ~]# systemctl stop mariadb
[root@teguhth ~]#

3. rsync (this optional if not config in mysqlbin )

rsync -auvr /var/lib/mysqlbinlogs/ /data/mysqlbinlogs/

[root@teguhth ~]# rsync -auvr /var/lib/mysqlbinlogs/ /data/mysqlbinlogs/
sending incremental file list
created directory /data/mysqlbinlogs
./
mysql-bin.000001
mysql-bin.000002
mysql-bin.000003
mysql-bin.index

sent 21,086 bytes  received 136 bytes  42,444.00 bytes/sec
total size is 20,770  speedup is 0.98
[root@teguhth ~]#
 

4. backup mysqlbinlogs to old 

mv /var/lib/mysqlbinlogs/ /var/lib/mysqlbinlogs_old/
 

5. relink mysqlbinlogs

ln -s /data/mysqlbinlogs /var/lib/mysqlbinlogs 

[root@teguhth ~]# mv /var/lib/mysqlbinlogs/ /var/lib/mysqlbinlogs_old/
[root@teguhth ~]#
[root@teguhth ~]# ln -s /data/mysqlbinlogs /var/lib/mysqlbinlogs
[root@teguhth ~]#
[root@teguhth ~]# ls -lh /var/lib/mysqlbinlogs
lrwxrwxrwx 1 root root 18 Feb 18 13:55 /var/lib/mysqlbinlogs -> /data/mysqlbinlogs
[root@teguhth ~]#
 

6. start mariadb 

[root@teguhth ]# systemctl start mariadb
[root@teguhth ]#

C. capture before 

1.check mariadb version
 

2. check log_bin_basename 

SHOW VARIABLES WHERE Variable_name IN ('datadir','basedir','log_bin_basename');

3. check before move log_bin_basename