Wednesday, 18 December 2013

Enable innodb in the mysql +cPanel

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