Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to solve the problem that the InnoDB engine is disabled when MySQL starts. It is very detailed and has a certain reference value. Interested friends must finish reading it!

Find a problem

At work today, when replicating table data from the local database to the database on the virtual machine CentOS 6.6, I was prompted:

Unknown table engine 'InnoDB'

So I looked at the engine in the server MySQL:

Mysql > show engines\ G

Get:

* * 1. Row * * Engine: MyISAM Support: DEFAULT Comment: MyISAM storage engineTransactions: NO XA: NO Savepoints: NO** 2.row * * Engine: CSV Support: YES Comment: CSV storage engineTransactions: NO XA: NO Savepoints: NO** 3. Row * * Engine: MEMORY Support: YES Comment: Hash based Stored in memory Useful for temporary tablesTransactions: NO XA: NO Savepoints: NO** 4. Row * * Engine: BLACKHOLE Support: YES Comment: / dev/null storage engine (anything you write to it disappears) Transactions: NO XA: NO Savepoints: NO* * 5. Row * * Engine: MRG_MYISAM Support: YES Comment: Collection of identical MyISAM tablesTransactions: NO XA: NO Savepoints: NO** 6. Row * * Engine: PERFORMANCE_SCHEMA Support: YES Comment: Performance SchemaTransactions: NO XA: NO Savepoints: NO** 7. Row * * Engine: ARCHIVE Support: YES Comment: Archive storage engineTransactions: NO XA: NO Savepoints: NO* * 8. Row * * Engine: FEDERATED Support: NO Comment: Federated MySQL storage engineTransactions: NULL Savepoints: NULL** 9. Row * * Engine: InnoDB Support: NO Comment: Supports transactions Row-level locking, and foreign keysTransactions: NULL XA: NULL Savepoints: NULLrows in set (0.00 sec)

The Supports in InnoDB is NO

Solution method

Edit my.cnf

[root@localhost mysql] # vim / etc/my.cnf

Change innodb = OFF to innodb = ON

You can comment out the skip-innodb at the same time.

The above is all about how to solve the problem that the InnoDB engine is disabled when MySQL starts. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.