lnmp0.7 mysql 重新编译 InnoDB 不成功

yeuss

我服务器的环境是CentOS5.5 64位
由于要安装magento系统，需要开启Mysql的InnoDB，
按照论坛上的提示重新编译 Mysql
cd mysql-5.1.44/
./configure --prefix=/usr/local/mysql --with-extra-charsets=all --enable-thread-safe-client --enable-assembler --with-charset=utf8 --enable-thread-safe-client --with-extra-charsets=all --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=innobase
make && make install

编译完成后，查询了一下，还是没有 InnoDB


[root@238480 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.54-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show engines;
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| Engine     | Support | Comment                                                   | Transactions | XA   | Savepoints |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
| CSV        | YES     | CSV storage engine                                        | NO           | NO   | NO         |
| MRG_MYISAM | YES     | Collection of identical MyISAM tables                     | NO           | NO   | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables | NO           | NO   | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance    | NO           | NO   | NO         |
+------------+---------+-----------------------------------------------------------+--------------+------+------------+
4 rows in set (0.03 sec)

mysql> alter table tb_name engine=innodb;
ERROR 1046 (3D000): No database selected
mysql> alter table tb_name type=innodb;
ERROR 1046 (3D000): No database selected
mysql> alter table tb_name type=innodb
    -> alter table tb_name engine=innodb
    -> Aborted
[root@238480 ~]# /root/lnmp restart
=========================================================================
Manager for LNMP V0.7  ,  Written by Licess
=========================================================================
LNMP is a tool to auto-compile & install Nginx+MySQL+PHP on Linux
This script is a tool to Manage status of lnmp
For more information please visit http://www.lnmp.org

试了很多篇都不行

望高手指教下，谢谢

licess

编译参数里多了一个--with-extra-charsets=all
把/usr/local/mysql/ 除数据库的目录删除。再重新编译安装试试
编译时有错误信息吗？

yuweitaocn

这一个这一个这一个这一个。同志，装一个新的版本不是就完事情了么，，何必呢。。

yuweitaocn

5.5版本的不是都可以支持INNODB。

ptah

试下--with-plugins=all，我用这个可以的

ming5856

./configure --prefix=/usr/local/mysql --without-debug --enable-thread-safe-client --with-pthread --enable-assembler --enable-profiling --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-charset=utf8 --with-extra-charsets=all --with-plugins=all --with-mysqld-user=mysql --without-embedded-server --with-server-suffix=-community --with-unix-socket-path=/tmp/mysql.sock

ming5856

ndbcluster         Clustered, fault-tolerant tables
MRG_MYISAM         Collection of identical MyISAM tables
BLACKHOLE         /dev/null storage engine (anything you write to it disappears)
CSV         CSV storage engine
MEMORY         Hash based, stored in memory, useful for temporary tables
FEDERATED         Federated MySQL storage engine
ARCHIVE         Archive storage engine
InnoDB         Supports transactions, row-level locking, and foreign keys
MyISAM         Default engine as of MySQL 3.23 with great performance
Open new phpMyAdmin window

ming5856

可以了，make clean 后再make ;make install一次就好了

yeuss

cd /root/lnmp0.7-full/mysql-5.1.54/
运行make ;make install  就可以了