升级mysql由5.5到5.7.29过程失败

matt

我用的是笔记本, ububtu18.04, 升级MYSQL时屏幕黑了, 我以为电脑本身死机出问题了, 就强制关机了. 然后在/root/看到以下日志:

matt

这是日志的内容:

[ 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

licess

这个上面没有错误信息，无法确定原因
你是直接在笔记本上安装的还是笔记本虚拟机里安装的？
什么配置的，ubuntu桌面版还是server版

matt

军哥, 您好.

matt

我用的是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

怎么办?

matt

电脑不久前买的, 8G内存, AMD cpu,

licess

估计可能长时间未动，直接就自动息屏了
这个配置，安装mysql 8.0+php 7.4也不会导致系统死机
也可以自己去 /var/log/messages 看一下日志

matt

昨天因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