CODEWITHSUNDEEP
mysqlinnodbmyisam
Ben McCormack
Ben McCormack

Reputation: 33078

Can't change storage engine to myisam, unknown storage engine 'InnoDB'

I'm trying to use mysqldump to dump a database, but I'm getting an error:

mysqldump: Couldn't execute 'show create table wp_commentmeta': Unknown storage engine 'InnoDB' (1286)

No worries; I'll just go into MySQL and change the storage engine for the table:

mysql> show create table wp_commentmeta;
ERROR 1286 (42000): Unknown storage engine 'InnoDB'
mysql> Alter table wp_commentmeta ENGINE = myisam;
ERROR 1286 (42000): Unknown storage engine 'InnoDB'

What am doing wrong? (and/or) How can I fix it?

Upvotes: 0

Views: 5193

Answers (1)

Andy
Andy

Reputation: 11985

There are many ways to recover InnnoDB tables.

If you meet these goals, give this page a try.

  1. You got backup of your ibdata1, ib_logfile0 and ib_logfile1
  2. You also got backup of your database folder with .frm files
  3. You would like to restore this backup into an MySQL server that’s already in production.

http://egil.biz/how-to-recover-mysql-data-from-innodb/

If that doesn't solve your problem, give this other InnoDB recovery walkthrough a try: http://www.mysqlperformanceblog.com/2008/07/04/recovering-innodb-table-corruption/

Upvotes: 1

Related Questions