lnmp1.3怎么重新编译增加InnoDB
lnmp1.3怎么重新编译增加InnoDBmysql的源码目录在哪里? 用1.3里面的升级脚本进行升级操作,选择启用就行
要自己编译的话自己下载源码
回复 2# 的帖子
升级不了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
============================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! 已经解决
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 编辑 ] mysql升级方法
cd /root/lnmp1.3-full
执行 ./upgrade.sh mysql
输入mysql 密码
输入版本
输入 Y
页:
[1]