Unknown storage engine 'InnoDB'

chatsaz

Verified User
Joined
Oct 10, 2013
Messages
23
hi
my server error
Code:
Unknown storage engine 'InnoDB'

How I solved???
 
Do you have skip-innodb specified in your my.cnf file?
 
Please post the output of:
Code:
cat /etc/my.cnf

Code:
[mysqld]
 innodb_use_native_aio = 0
 innodb_file_per_table=1
 innodb_log_file_size = 12M
 default-storage-engine = myisam
 key_buffer = 8M
 query_cache_size = 8M
 query_cache_limit = 4M
 max_connections=25
 thread_cache=1
 skip-innodb
 query_cache_min_res_unit=0
 tmp_table_size = 4M
 max_heap_table_size = 4M
 table_cache=256
 concurrent_insert=2
bind-address=46.105.248.90
 
You have skip-innodb in /etc/my.cnf

remove that line and try again.
 
You have skip-innodb in /etc/my.cnf

remove that line and try again.

im remove

Code:
 innodb_use_native_aio = 0
 innodb_file_per_table=1
 innodb_log_file_size = 12M
 default-storage-engine = myisam
 key_buffer = 8M
 query_cache_size = 8M
 query_cache_limit = 4M
 max_connections=25
 thread_cache=1
 query_cache_min_res_unit=0
 tmp_table_size = 4M
 max_heap_table_size = 4M
 table_cache=256
 concurrent_insert=2
bind-address=46.105.248.90
but Yet the problem remains

Code:
Unknown storage engine 'InnoDB'
 
What OS are you running? How did you install MySQL?
If you want I could check your server via SSH.
 
Your InnoDB tables are most likely corrupted and that's why InnoDB fails to register as a storage engine:

Code:
150707  2:56:58 [ERROR] Plugin 'InnoDB' init function returned error.
150707  2:56:58 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

The simplest way will be to rebuild MySQL tables from a backup.
 
Your InnoDB tables are most likely corrupted and that's why InnoDB fails to register as a storage engine:

Code:
150707  2:56:58 [ERROR] Plugin 'InnoDB' init function returned error.
150707  2:56:58 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

The simplest way will be to rebuild MySQL tables from a backup.

I do not have a backup

There is no possible way to be solved????
 
You might have backups in /home/admin/admin_backups/
Do they contain MySQL tables?
 
Back
Top