CODEWITHSUNDEEP
mysqlinnodbmyisam
user575859
user575859

Reputation: 1

Convert InnoDB to MyISAM with InnoDB disabled

I'm the lucker owner of a webhotel where the host changes settings without telling. When thats said, I have some tables in my database that are running with InnoDB engine. But over the night the host have disabled InnoDB, so I cant convert it to MyISAM with ALTER command.

Anyway I can get the data out of the database, or convert it to MyISAM when InnoDB is disabled?

Only thing I see all the time is,

#1033 - Incorrect information in file: 'file.frm'

Thanks.

Upvotes: 0

Views: 1648

Answers (1)

Quassnoi
Quassnoi

Reputation: 425833

Unfortunately, you need to have InnoDB enabled so that MySQL could read the data for conversion.

To recover the data on another instance, you would need ibdata* files from MySQL root data directory as well as all *.ibd files from your database directory (if your MySQL setup had innodb_file_per_table enabled).

Upvotes: 1

Related Questions