UBUNTU的LNMP中的MYSQL升级记录

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

通过日志, 看出没有出什么问题, 军哥言.

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

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!

改了一下相应的安装脚本, 让它不再备份, 问题就基本解决了.

总结:

• 不要随便强制关机, 多一些耐心. 我发现安装这个风扇呼呼的在转…
• 折腾的道路还很长, 做好准备哈, (想想zhud, 几近失败, 最后成功. 成功者往往要有一颗强大的内心, 经得起折腾, 起码的)