摘要：登錄查看當(dāng)前數(shù)據(jù)存儲(chǔ)目錄關(guān)閉確認(rèn)的確關(guān)閉關(guān)閉無誤，輸出類似轉(zhuǎn)移數(shù)據(jù)目錄備份源數(shù)據(jù)是為了保證中驗(yàn)證目錄正確修改配置權(quán)限修改追加以下內(nèi)容到重啟沒有追加內(nèi)容，可能導(dǎo)致啟動(dòng)原文鏈接歡迎您加入我們的專屬討論群組

mysql -uroot -p

mysql> select @@datadir;

+-----------------+
| @@datadir       |
+-----------------+
| /var/lib/mysql/ |
+-----------------+
1 row in set (0.00 sec)

sudo systemctl stop mysql

sudo systemctl status mysql

關(guān)閉無誤，輸出類似 "Jul 18 11:24:20 ubuntu-512mb-nyc1-01 systemd[1]: Stopped MySQL Community Server."

sudo rsync -av /var/lib/mysql /data/

sudo mv /var/lib/mysql /var/lib/mysql.bak
sudo mkdir /var/lib/mysql/mysql -p

sudo mkdir /var/lib/mysql/mysql -p 是為了保證 /usr/share/mysql/mysql-systemd-start 中驗(yàn)證目錄正確

datadir=/data/mysql

alias /var/lib/mysql/ -> /data/mysql/,

sudo systemctl restart apparmor

沒有追加alias內(nèi)容，可能導(dǎo)致

Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" 
and "journalctl -xe" for details.

sudo systemctl start mysql
sudo systemctl status mysql

原文鏈接
https://www.digitalocean.com/...

歡迎您加入我們的專屬Q(mào)Q討論群組① 233415606 ② 233415756