开发者

Convert InnoDB to MyISAM with InnoDB disabled

I'm the lucker owner of a webhotel where the host changes set开发者_如何学JAVAtings 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.


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).

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜