ERROR 1286 (42000): Unknown table engine ‘InnoDB’

在对mysql库进行导出表结构时，发现报错：
mysqldump:Got Error: 1286: Unknown table engine 'InnoDB? when using LOCK TABLES

1

2

3

4

5

6

7

8

9

10

11

12

13

mysql>showengines;

+------------+---------+-----------------------------------------------------------+--------------+------+------------+

|Engine    |Support|Comment                                    |Transactions|XA|Savepoints|

+------------+---------+-----------------------------------------------------------+--------------+------+------------+

|MRG_MYISAM|YES    |CollectionofidenticalMyISAMtables                      |NO|NO|NO|

|CSV        |YES    |CSVstorageengine                                        |NO|NO|NO|

|FEDERATED  |NO      |FederatedMySQLstorageengine                              |NULL|NULL|NULL|

|MyISAM    |DEFAULT|DefaultengineasofMySQL3.23withgreatperformance|NO|NO|NO|

|MEMORY    |YES    |Hashbased,storedinmemory,usefulfortemporarytables  |NO|NO|NO|

+------------+---------+-----------------------------------------------------------+--------------+------+------------+

5rowsinset(0.00sec)

mysql>showinnodbstatus;

ERROR1286(42000):Unknowntableengine'InnoDB'

检查日志发现：

1

2

3

4

5

6

14040212:32:15InnoDB:Initializingbufferpool,size=1.5G

14040212:32:15InnoDB:Completedinitializationofbufferpool

InnoDB:Error:logfile./ib_logfile0isofdifferentsize05242880bytes

InnoDB:thanspecifiedinthe.cnffile0268435456bytes!

14040212:32:15[ERROR]Plugin'InnoDB'initfunctionreturnederror.

14040212:32:15[ERROR]Plugin'InnoDB'registrationasaSTORAGEENGINEfailed.

重启数据，将ib_logfile删除

1

2

3

4

#/etc/init.d/mysqld stop

#cd /var/lib/mysql

#rm -rf ib_logfile*

#/etc/init.d/mysqld start

 再次检查表引擎状态一切恢复正常。

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

mysql>showengines;

+------------+---------+--------------------------------------------------------------------------------------------+--------------+------+------------+

|Engine       |Support |Comment                                     |Transactions|XA|Savepoints|

+------------+---------+--------------------------------------------------------------------------------------------+--------------+------+------------+

|MRG_MYISAM|YES     |CollectionofidenticalMyISAMtables                  |NO|NO|NO|

|CSV    |YES     |CSVstorageengine                                  |NO|NO|NO|

|FEDERATED |NO     |FederatedMySQLstorageengine                      |NULL|NULL|NULL|

|InnoDB  |YES     |Supportstransactions,row-levellocking,andforeignkeys|YES|YES|YES|

|MEMORY  |YES     |Hashbased,storedinmemory,usefulfortemporarytables|NO|NO|NO|

|MyISAM  |DEFAULT|DefaultengineasofMySQL3.23withgreatperformance|NO|NO|NO|

+------------+---------+------------------------------------------------------------+--------------+------+------------+

6rowsinset(0.00sec)

 

mysql>showinnodbstatus\G;

***************************1.row***************************

Type:InnoDB

Name:

Status:

=====================================

14040213:51:30INNODBMONITOROUTPUT

=====================================

Persecondaveragescalculatedfromthelast3seconds

----------

SEMAPHORES

----------

OSWAITARRAYINFO:reservationcount5,signalcount5

Mutexspinwaits0,rounds40,OSwaits0

RW-sharedspins10,OSwaits5;RW-exclspins0,OSwaits0

......

----------------------------

ENDOFINNODBMONITOROUTPUT

============================

 

至此一切恢复正常