mysql轉儲恢復過程後Mysql無法啟動

mysql轉儲恢復過程後Mysql無法啟動

我嘗試將資料庫備份還原到新建立的資料庫,突然它開始顯示錯誤。無法透過套接字連接到本機 MySQL 伺服器/var/run/mysqld/mysqld.sock ,所以我檢查了/var/log/syslog它顯示的錯誤,例如:

kernel: [50646755.461546] init: mysql main process (31830) terminated with status 1
kernel: [50646755.461590] init: mysql main process ended, respawning
kernel: [50646756.363273] init: mysql post-start process (31831) terminated with status 1
kernel: [50646756.380883] type=1400 audit(1404213477.915:91): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=31854 comm="apparmor_parser"

然後我嘗試了

cd /etc/apparmor.d/
sudo ln -s /etc/apparmor.d/usr.sbin.mysqld /etc/apparmor.d/disable/
sudo apparmor_parser -R /etc/apparmor.d/usr.sbin.mysqld

從 apparmor 停用 mysqld。

cat /sys/kernel/security/apparmor/profiles

/usr/sbin/tcpdump (enforce)
/usr/lib/connman/scripts/dhclient-script (enforce)
/usr/lib/NetworkManager/nm-dhcp-client.action (enforce)
/sbin/dhclient (enforce)

mysql 從 apparmor 中刪除

然後我再次嘗試啟動mysql,顯示錯誤。 tailf /var/log/syslog

kernel: [50647375.532797] init: mysql main process (32120) terminated with status 1
kernel: [50647375.532843] init: mysql main process ended, respawning
kernel: [50647376.405541] init: mysql post-start process (32121) terminated with status 1
init: mysql main process (32148) terminated with status 1
kernel: [50647376.611944] init: mysql main process ended, respawning
kernel: [50647377.490963] init: mysql post-start process (32149) terminated with status 1
kernel: [50647377.671609] init: mysql main process (32176) terminated with status 1
kernel: [50647377.671654] init: mysql respawning too fast, stopped

請幫幫我,我需要使用同樣令人興奮的資料庫。我不想失去它。

相關內容