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

yeuss 发表于 2011-8-2 19:12:54

我服务器的环境是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

# 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/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 发表于 2011-8-2 20:00:38

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

yuweitaocn 发表于 2011-8-3 15:08:23

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

yuweitaocn 发表于 2011-8-3 15:13:28

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

ptah 发表于 2011-8-4 15:53:23

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

ming5856 发表于 2011-9-6 00:30:57

用了--with-plugins=all 还是不行

./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 发表于 2011-9-6 01:04:36

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 发表于 2011-9-6 01:05:06

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

yeuss 发表于 2011-10-17 17:09:08

回复 2# 的帖子

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

页: [1]

VPS侦探论坛's Archiver