fix::
http://forums.cpanel.net/f354/how-install-innodb-step-step-155297.html
Once you are logged in, check if Innodb is already there. Execute the command:
mysqladmin variables | grep have_innodb
this will tell you if Innodb is present on the server and whether it is ON or OFF.
root@server1 [~]# mysqladmin variables | grep have_innodb
| have_innodb | DISABLED
|
If you see have_innodb is set to OFF. It indicate thet innodb is disabled on your server.
To enable it, ssh to your server as root and open file /etc/my.cnf with your favorite editor.
Search for line skip-innodb and comment the line by placing # in the starting of the line.
Save and quit the file and restart mysql service for changes to take effect.
/etc/init.d/mysql restart
Now check status of InnoDb engine
mysqladmin variables | grep have_innodb
Above command should show output as YES now.
root@server1 [~]# vi /etc/my.cnf
root@server1 [~]# /etc/init.d/mysql restart
Shutting down MySQL... SUCCESS!
Starting MySQL... SUCCESS!
root@server1 [~]# mysqladmin variables | grep have_innodb
| have_innodb | YES
|
No comments:
Post a Comment