VPS侦探论坛

 找回密码
 注册
查看: 234|回复: 3

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

[复制链接]
发表于 2021-7-5 10:49:33 | 显示全部楼层 |阅读模式



本帖最后由 shenfu 于 2021-7-5 10:54 编辑

两台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

求大佬指教,谢谢。



美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2021-7-5 16:33:10 | 显示全部楼层


mysql运行中直接快照备份整个系统很可能会造成数据损坏
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2021-7-6 09:50:24 | 显示全部楼层



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

好的,谢谢大佬
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2021-7-9 14:49:17 | 显示全部楼层



我也遇到这个问题,那怎么解决呢?重装还是??????
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2021-8-3 13:20 , Processed in 0.088490 second(s), 26 queries .

Powered by Discuz! X3.4

Copyright © 2001-2021, Tencent Cloud.

快速回复 返回顶部 返回列表