Error: Unknown storage engine 'InnoDB
Error in repair table MySQL Database :
Error in Command line ssh :
MySQL 5.6 Please help step by step to fix this problem.
[whmcsyas_5.tblactivitylog] Error: Unknown storage engine 'InnoDB'
[whmcsyas_5.tblactivitylog] error: Corrupt
[whmcsyas_5.tbladdonmodules] Error: Unknown storage engine 'InnoDB'
[whmcsyas_5.tbladdonmodules] error: Corrupt
Error in Command line ssh :
root@bazdid [~]# mysqladmin variables | grep have_innodb
| have_innodb | DISABLED |
mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MyISAM | DEFAULT | MyISAM storage engine | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
8 rows in set (0.00 sec)
mysql> show engine innodb status;
ERROR 1286 (42000): Unknown storage engine 'innodb'
MySQL 5.6 Please help step by step to fix this problem.
-
Hello, What do you have in your /etc/my.cnf file? cat /etc/my.cnf
Please paste that here.0 -
hello, having same pro, # cat /etc/my.cnf [mysqlhotcopy] interactive-timeout log-slow-queriies="/var/lib/mysql/slow.log" [mysqldump] max_allowed_packet=4M quick [mysql] no-auto-rehash [mysqld] thread_cache_size=8 max_allowed_packet=268435456 query_cache_size=32M innodb_file_per_table=1 innodb_log_file_size = 12M server-id=1 table_cache=512 sort_buffer_size=2M myisam_sort_buffer_size=64M wait_timeout=20 thread_concurrency=8 default-storage-engine=MyISAM key_buffer=384M max_connections=25 max_user_connections=25 skip-external-locking read_rnd_buffer_size=8M connect_timeout=20 read_buffer_size=2M open_files_limit=50000 innodb_buffer_pool_size=134217728 [myisamchk] read_buffer=2M sort_buffer_size=128M key_buffer=128M write_buffer=2M ------------------ 0 -
Hello :) Try copying your /etc/my.cnf file to another location to ensure it's backed up, and then use a standard empty /etc/my.cnf file to see i f that makes a difference. Ensure you restart MySQL after implementing the default /etc/my.cnf file. If the issue persists, the following thread is helpful if you need to repair InnoDB: Repairing InnoDB Thank you 0
Please sign in to leave a comment.
Comments
3 comments