Unknown storage engine 'InnoDB'

[chatsaz]

hi
my server error

Unknown storage engine 'InnoDB'

How I solved???

 

[chatsaz]

pls help................

 

[smtalk]

Do you have skip-innodb specified in your my.cnf file?

 

[chatsaz]

Do you have skip-innodb specified in your my.cnf file?

no
skip-innodb not in my.cnf file

 

[chatsaz]

help help help

 

[smtalk]

Please post the output of:

cat /etc/my.cnf

 

[chatsaz]

Please post the output of:

cat /etc/my.cnf

[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

 

[Fred.]

You have skip-innodb in /etc/my.cnf

remove that line and try again.

 

[chatsaz]

You have skip-innodb in /etc/my.cnf

remove that line and try again.

im remove

 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

Unknown storage engine 'InnoDB'

 

[zEitEr]

Hello,

Show what you get with:

grep innodb -i /etc/my.cnf

 

[chatsaz]

Hello,

Show what you get with:

grep innodb -i /etc/my.cnf

hi

grep innodb -i /etc/my.cnf
 innodb_use_native_aio = 0
 innodb_file_per_table=1
 innodb_log_file_size = 12M

 

[zEitEr]

What OS are you running? How did you install MySQL?
If you want I could check your server via SSH.

 

[chatsaz]

What OS are you running? How did you install MySQL?
If you want I could check your server via SSH.

tanx
im send ssh to your Private

 

[zEitEr]

Your InnoDB tables are most likely corrupted and that's why InnoDB fails to register as a storage engine:

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.

 

[chatsaz]

Your InnoDB tables are most likely corrupted and that's why InnoDB fails to register as a storage engine:

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????

 

[zEitEr]

You might have backups in /home/admin/admin_backups/
Do they contain MySQL tables?

 

[chatsaz]

You might have backups in /home/admin/admin_backups/
Do they contain MySQL tables?

It is incomplete backup
contain MySQL tables that is corrupted !

 

[zEitEr]

Are you sure you don't have another backups?

 

[chatsaz]

Are you sure you don't have another backups?

Unfortunately no

 

[after20]

ok let me share my experience when I face the similar issue.
1. Old log files /var/lib/mysql/ib_logfile0 and /var/lib/mysql/ib_logfile1 still exist on the server.

Refer here for solution

2. Memory is too small to afford innodb_buffer_pool

Refer here for solution