Install the InnoDB Engine in MySQL 5.1

Install the innodb Engine (mysql5.1 is not installed by default)
 
You can add the -- with-plugins = innobase parameter to configrue during compilation and installation.
 
If you have installed innodb before, you can also install the innodb engine.
 
First, make sure that there are ha_innodb_plugin.so and ha_innodb.so files under 'plugin _ dir' of mysql.
 
Mysql> show variables like 'in in _ dir ';
 
+ --------------- + ----------------------------------- +
 
| Variable_name | Value |
 
+ --------------- + ----------------------------------- +
 
| Plugin_dir |/usr/local/mysql/lib/mysql/plugin |
 
+ --------------- + ----------------------------------- +
 
1 row in set (0.01 sec)
 
If not found, the following directory files (built-in innodb and innodb_plugin) are included in your mysql compilation directory)
 
Storage/innobase/. libs/ha_innodb.so
 
Storage/innodb_plugin/. libs/ha_innodb_plugin.so
 
You need to copy them (ha_innodb_plugin.so and ha_innodb.so) to the plugin directory of mysql (/usr/local/mysql/lib/mysql/plugin)
 
 
Next, install mysql Command Line
 
Mysql> install plugin InnoDB SONAME 'Ha _ innodb. so ';
 
Install plugin InnoDB SONAME 'Ha _ innodb. so ';
 
Mysql> show engines;