从另一台搬瓦工快照恢复系统导入，mysql启动失败

shenfu

两台vps都是搬瓦工的，系统都是Ubuntu20.04，其中一台正常安装lnmp，启动也是完全正常的（称为A）。
A完全备份后（搬瓦工的自动备份）导出来给B，B恢复后mysql就直接报错了：

root@CN:/home/wwwroot/xuanyuanhuangdi.org# lnmp mysql start

+-------------------------------------------+

|    Manager for LNMP, Written by Licess    |

+-------------------------------------------+

|              https://lnmp.org             |

+-------------------------------------------+

Starting mysql (via systemctl): mysql.serviceJob for mysql.service failed because the control process exited with error code.

See "systemctl status mysql.service" and "journalctl -xe" for details.

failed!

root@CN:/home/wwwroot/xuanyuanhuangdi.org# systemctl status mysql.service

● mysql.service - MySQL Community Server

     Loaded: loaded (/etc/systemd/system/mysql.service; enabled; vendor preset: enabled)

     Active: failed (Result: exit-code) since Mon 2021-07-05 10:53:18 CST; 19s ago

    Process: 4322 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

Jul 05 10:53:16 CN systemd[1]: Starting MySQL Community Server...

Jul 05 10:53:16 CN mysql[4322]: Starting MySQL

Jul 05 10:53:18 CN mysql[4322]: .. * The server quit without updating PID file (/usr/local/mysql/var/CN.pid).

Jul 05 10:53:18 CN systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE

Jul 05 10:53:18 CN systemd[1]: mysql.service: Failed with result 'exit-code'.

Jul 05 10:53:18 CN systemd[1]: Failed to start MySQL Community Server.

/usr/local/mysql/var/CN.err文件内容地址：https://xuanyuanhuangdi.org/err.zip

求大佬指教，谢谢。

licess

mysql运行中直接快照备份整个系统很可能会造成数据损坏

shenfu

licess 发表于 2021-7-5 16:33
mysql运行中直接快照备份整个系统很可能会造成数据损坏

好的，谢谢大佬

water6000

我也遇到这个问题，那怎么解决呢？重装还是？？？？？？