从mysql官网下载mysql5.1.34版本,进行编译,编译成功后,mysqld_safe 无法启动,使用下面的命令进行初始化.
./mysql_install_db --user=mysql --datadir=/home/ss/re0/mysql/isomysql/mysql/data/
使用下面的命令开启mysql服务
/home/ss/re0/mysql/isomysql/mysql/bin/mysqld_safe &
另外,
mysql5.1默认编译是不会有innodb引擎,通过网上查询,有两种方法可以实现。
1 编译时指定 --with-plugin-innobase
2 启动完成后,使用命令加载 install plugin innodb soname 'ha_innodb.so'
查看引擎,show engines \G
mysql> show engines \G
*************************** 1. row ***************************
Engine: CSV
Support: YES
Comment: CSV storage engine
Transactions: NO
XA: NO
Savepoints: NO
*************************** 2. row ***************************
Engine: InnoDB
Support: YES
Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
XA: YES
Savepoints: YES
*************************** 3. row ***************************
Engine: MEMORY
Support: YES
Comment: Hash based, stored in memory, useful for temporary tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 4. row ***************************
Engine: MyISAM
Support: DEFAULT
Comment: Default engine as of MySQL 3.23 with great performance
Transactions: NO
XA: NO
Savepoints: NO
*************************** 5. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
Transactions: NO
XA: NO
Savepoints: NO
5 rows in set (0.00 sec)
mysql>