VPS侦探论坛

 找回密码
 注册
查看: 131|回复: 7

升级mysql由5.5到5.7.29过程失败

[复制链接]
发表于 2020-6-2 19:47:32 | 显示全部楼层 |阅读模式



我用的是笔记本, ububtu18.04, 升级MYSQL时屏幕黑了, 我以为电脑本身死机出问题了, 就强制关机了. 然后在/root/看到以下日志:
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2020-6-2 19:50:48 | 显示全部楼层


这是日志的内容:

[ 82%] Building CXX object sql/CMakeFiles/sql.dir/keyring_service.cc.o
[ 82%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_cmpfunc.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/ssl_wrapper_service.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/bootstrap.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/conn_handler/connection_handler_manager.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/datadict.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/debug_sync.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/derror.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/discover.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/field.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/field_conv.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/filesort.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/filesort_utils.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/aggregate_check.cc.o
[ 83%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_create.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/geometry_rtree.cc.o
[ 83%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_func.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/gstream.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/handler.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/hostname.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/init.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/item.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/item_buff.cc.o
[ 83%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_geofunc.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/item_cmpfunc.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/item_create.cc.o
[ 83%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_geofunc_buffer.cc.o
[ 83%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_geofunc_internal.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/item_func.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_buffer.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_internal.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_relchecks.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_relchecks_bgwrap.cc.o
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
发表于 2020-6-2 20:49:24 | 显示全部楼层



这个上面没有错误信息,无法确定原因
你是直接在笔记本上安装的还是笔记本虚拟机里安装的?
什么配置的,ubuntu桌面版还是server版
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2020-6-2 21:04:47 | 显示全部楼层

我用的是ubuntu桌面版的; 不是装在虚拟机里的; 问题是我强制关机了,
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_buffer.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_internal.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_relchecks.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_relchecks_bgwrap.cc.o

程序到这里就没有下文了.

当我再$mysql时:

matt@matt-damai-e-series:~$ mysql

Command 'mysql' not found, but can be installed with:

sudo apt install mysql-client-core-5.7   
sudo apt install mariadb-client-core-10.1

怎么办?

美国VPS、VPN、域名代购:http://shop63846532.taobao.com/

 楼主| 发表于 2020-6-2 21:07:30 | 显示全部楼层

电脑不久前买的, 8G内存, AMD cpu,
发表于 2020-6-3 09:23:21 | 显示全部楼层

估计可能长时间未动,直接就自动息屏了
这个配置,安装mysql 8.0+php 7.4也不会导致系统死机
也可以自己去 /var/log/messages 看一下日志
美国VPS推荐: 遨游主机LinodeLOCVPSKVMLAVPS2EZ搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2020-6-3 09:47:53 | 显示全部楼层



昨天因DJANGO框架的需要想升级一下MYSQL5.6到5.7, 第一次弄的时候, 我看笔记本屏幕黑屏了, 没耐心等太久就强制关机了. 代价很惨重, 开机后安装失败, 并且以前的也不能用了!
根据LNMP文档说明, 看 /root 下的日志. 分别看了一下, 其中有一个有用的:

[ 81%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/init.cc.o
[ 81%] Linking CXX static library ../../archive_output_directory/libmysqlpump_lib.a
[ 81%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item.cc.o
[ 81%] Built target mysqlpump_lib
Scanning dependencies of target mysqlpump
[ 81%] Building CXX object client/dump/CMakeFiles/mysqlpump.dir/program.cc.o
[ 81%] Linking CXX executable mysqlpump
[ 81%] Building CXX object sql/CMakeFiles/sql.dir/auth/sql_user_table.cc.o
[ 82%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_buff.cc.o
[ 82%] Building CXX object sql/CMakeFiles/sql.dir/auth/sql_user.cc.o
[ 82%] Built target mysqlpump
[ 82%] Building C object sql/CMakeFiles/sql.dir/auth/password.c.o
[ 82%] Building CXX object sql/CMakeFiles/sql.dir/auth/password_policy_service.cc.o
[ 82%] Building CXX object sql/CMakeFiles/sql.dir/auth/sql_security_ctx.cc.o
[ 82%] Building CXX object sql/CMakeFiles/sql.dir/auth/service_security_context.cc.o
[ 82%] Building CXX object sql/CMakeFiles/sql.dir/keyring_service.cc.o
[ 82%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_cmpfunc.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/ssl_wrapper_service.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/bootstrap.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/conn_handler/connection_handler_manager.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/datadict.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/debug_sync.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/derror.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/discover.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/field.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/field_conv.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/filesort.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/filesort_utils.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/aggregate_check.cc.o
[ 83%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_create.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/geometry_rtree.cc.o
[ 83%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_func.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/gstream.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/handler.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/hostname.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/init.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/item.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/item_buff.cc.o
[ 83%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_geofunc.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/item_cmpfunc.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/item_create.cc.o
[ 83%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_geofunc_buffer.cc.o
[ 83%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/item_geofunc_internal.cc.o
[ 83%] Building CXX object sql/CMakeFiles/sql.dir/item_func.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_buffer.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_internal.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_relchecks.cc.o
[ 84%] Building CXX object sql/CMakeFiles/sql.dir/item_geofunc_relchecks_bgwrap.cc.o

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
通过日志, 看出没有出什么问题, 军哥言.

然后我再重新安装, 出现以下错误:

Press any key to start...or Press Ctrl+c to cancel

============================check files==================================
mysql-boost-5.7.29.tar.gz [found]
============================check files==================================
Starting backup all databases...
If the database is large, the backup time will be longer.
include/upgrade_mysql.sh: 行 7: /usr/local/mysql/bin/mysqldump: 没有那个文件或目录
MySQL databases backup failed,Please backup databases manually!

1
2
3
4
5
6
7
8
9
10
改了一下相应的安装脚本, 让它不再备份, 问题就基本解决了.

总结:

不要随便强制关机, 多一些耐心. 我发现安装这个风扇呼呼的在转…
折腾的道路还很长, 做好准备哈,
————————————————
版权声明:本文为CSDN博主「Matt618」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/weixin_44867462/article/details/106517162
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
您需要登录后才可以回帖 登录 | 注册

本版积分规则

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

GMT+8, 2020-7-2 15:01 , Processed in 0.050475 second(s), 26 queries .

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

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