database:mysql:move_data_folder

no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


—database:mysql:move_data_folder [2020/02/21 10:34] (current) – created - external edit 127.0.0.1
Line 1: Line 1:
 +====== Relocate MySql data folder ======
  
 +<code bash>
 +rsync -avzh /var/lib/mysql /data
 +mv /var/lib/mysql /var/lib/mysql.bak
 +mkdir /var/lib/mysql
 +mount -B /data/mysql /var/lib/mysql
 +</code>
 +
 +Additionally
 +<code bash /etc/fstab>
 +/data/mysql     /var/lib/mysql  auto    defaults,nofail,nobootwait,bind 0       2
 +</code>