How to install Webhosting Guide

Apache PHP Mysql Bind DNS Yum

[SOLVED] #1286 - Unknown table engine ‘InnoDB©?’

[SOLVED] #1286 - Unknown table engine ‘InnoDB©?’

mysql -u root -p yourhiddenpasswd
mysql> SHOW VARIABLES LIKE 'have_innodb';

+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | NO   |
+---------------+-------+
1 row in set (0.00 sec)

mysql>

Please find your my.cnf file. Usually it’s in /etc/my.cnf.

[root@myserver ~]# nano /etc/my.cnf

add below lines to your my.cnf file
default-storage-engine = innodb

innodb_buffer_pool_size = 2560M
innodb_log_file_size    = 256M
innodb_log_buffer_size  = 8M
innodb_flush_log_at_trx_commit  = 2
innodb_thread_concurrency   = 16
innodb_flush_method = O_DIRECT

[root@myserver ~]# /etc/init.d/mysqld restart

Then it will be work correctly.

No comments

Solved * [ERROR] Plugin ‘InnoDB’ init function returned error.

No comments

Tried to fetch SOA record for domain, but DNS server ns1.somens.org [7x.xx.xx.xxx] returned error code Refused

No comments

Cpanel mysql5 and php5 how to

No comments

Fix Apache - No space left on device: Couldn’t create accept lock or Cannot create SSLMutex

No comments

Next Page »