Stop worrying about your server.
cPanel Server Management for just $59/mo with Unlimited tickets, Unlimited admin hours, Security audits, 24×7 monitoring and lot more
cPanel Server Management $59/mo Click here
InnoDB engine enabled or not cPanel:
You can check whether the innoDB engine is enabled or not in your linux server by the following method,
First you need to login to the mysql server from the command line using the following command,
mysql
root@iserversupportl2 [~]# mysql
Now you will enter into the mysql prompt and you will get a welcome message as below,
[root@iserversupportl2 [~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 257012 Server version: 5.1.69 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
Now enter the following query on the mysql prompt,
SHOW VARIABLES LIKE 'have_innodb';
Now you will get result as follows,
mysql> SHOW VARIABLES LIKE 'have_innodb'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | have_innodb | YES | +---------------+-------+ 1 row in set (0.00 sec)
You can now simply make sense from the result that innodb is enabled or not.
Need our help to fix the issue ? Submit Support Ticket Now
[sep][/sep]
[button size=”large” color=”green” title=”Server Administration Services from Stack Supports” link=”http://iserversupport.com/server-support-products/server-security/”]View Server Administration Packages[/button]
Leave A Comment