.::: Move Datadir MariaDB / MySQL using symlink relink symbolic link :::.

 

A. capture before 

1. check mariadb version

2. check datadir 

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

 
3. check before move datadir 
  

B. move datadir 

1. create new datadir 

mkdir -p /data/mysql

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

2. stop mariadb service 

systemctl stop mariadb

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

3. rsync 

rsync -auvr /var/lib/mysql/ /data/mysql/

[root@teguhth ~]#
[root@teguhth ~]# rsync -auvr /var/lib/mysql/ /data/mysql/
sending incremental file list
./
aria_log.00000001
aria_log_control
ib_buffer_pool
ib_logfile0
ibdata1
mysql/innodb_index_stats.ibd
mysql/innodb_table_stats.ibd
teguhth/
teguhth/barang.frm
teguhth/barang.ibd
teguhth/customer.frm
teguhth/customer.ibd
teguhth/pasok.frm
teguhth/pasok.ibd
teguhth/pembelian.frm
teguhth/pembelian.ibd
teguhth/suplier.frm
teguhth/suplier.ibd

sent 114,232,184 bytes  received 362 bytes  76,155,030.67 bytes/sec
total size is 118,277,335  speedup is 1.04
[root@teguhth ~]#
 

4. backup mysql to old 

mv /var/lib/mysql/ /var/lib/mysql_old/
 

5. relink mariadb 

ln -s /data/mysql /var/lib/mysql

[root@teguhth ~]# ln -s /data/mysql /var/lib/mysql
[root@teguhth ~]#
[root@teguhth ~]#
[root@teguhth ~]# ls -l /var/lib/mysql
lrwxrwxrwx 1 root root 11 Feb 13 09:06 /var/lib/mysql -> /data/mysql
[root@teguhth ~]#
 

6. change permit if using key

chmod 775 /var/lib/mysql/keyfile_marina.txt

7. start mariadb 

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

C. capture before 

1. check mariadb version
 

2. check datadir 

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

3. check before move datadir