lnmp1.3怎么重新编译增加InnoDB

2966980

lnmp1.3怎么重新编译增加InnoDB
mysql的源码目录在哪里？

licess

用1.3里面的升级脚本进行升级操作，选择启用就行
要自己编译的话自己下载源码

2966980

升级不了mysql，帮我看下什么原因哦

OK, MySQL root password correct.
Current MYSQL Version:5.6.29
You can get version number from http://dev.mysql.com/downloads/mysql/
Please input MySQL Version you want.
(example: 5.5.45 ): 5.7.11
===========================
Do you want to install the InnoDB Storage Engine?
(Default yes,if you want please enter: y , if not please enter: n): y
You will install the InnoDB Storage Engine
==================================================
You want to upgrade MySQL Version to 5.7.11
==================================================

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

============================check files==================================
mysql-5.7.11.tar.gz [found]
============================check files==================================
Starting backup all databases...
If the database is large, the backup time will be longer.
mysqldump: Got error: 1286: Unknown storage engine 'InnoDB' when using LOCK TABL            ES
MySQL databases backup failed,Please backup databases manually!

2966980

已经解决

1. 停止mysql
2. 先把 /usr/local/mysql/var/ 目录里面含有 InnoDB 格式数据库的目录先移到其他地方
3. 启动 mysql
4. 升级 mysql，升级时输入Y，也就是安装 InnoDB 引擎
5. 升级后再次停止mysql
6. 把之前移出来的数据重新移到原来的目录
7. 再次启动mysql就好了

[ 本帖最后由 2966980 于 2016-3-17 20:24 编辑 ]

2966980

mysql升级方法

cd /root/lnmp1.3-full
执行 ./upgrade.sh mysql
输入mysql 密码
输入版本
输入 Y