Creating MyISAM Table in Azure database for MySQL is enable?

Question

When I create table that engine is MyISAM in Azure database for Mysql, Got Error "ERROR 1030 (HY000): Got error 1 from storage engine"

How do I fix it? or can I use MyISAM table in Azure database for MySQL?

cli screen captuer

score 11 · Accepted Answer · answered May 15 '17 at 15:47

11

Correct - MYISAM is not supported in Azure Database for MySQL, primarily due to the lack of transaction support which can potentially lead to data loss. This is one of the reasons MySQL switched over to InnoDB as the default.

Jason Azure DB for MySQL team

answered May 15 '17 at 15:47

Jason Anderson

176
4

Thank you!! I understand it. – Yuuji Arakaki May 25 '17 at 03:08

Hello · Answer 2 · 2017-05-15T08:54:46.157

2

As far as i know MYISAM is not supported in Azure database for MySQL. I'd suggest you switch to InnoDB instead.

In addition, I've also found a similar feedback in Azure feedback site.I'd suggest you keep track of that to see if anything changes.

Regards,
Lin

edited May 15 '17 at 08:54

answered May 15 '17 at 07:48

Hello

632
7
14

score 0 · Answer 3 · answered Dec 02 '19 at 18:28

So I had the same issue but getting this error on my local mysql database. I would suggest that the first thing you do is check the storage engine.

In my case it turned out that the storage engine was ARCHIVE and changing this to InnoDB solved the issue.

Creating MyISAM Table in Azure database for MySQL is enable?

3 Answers3

Linked