CODEWITHSUNDEEP
mysqlinnodbmyisam
Hari Das
Hari Das

Reputation: 10864

Trying to convert MyISAM to InnoDB, result into error

I am trying to convert a very big table to InnDB. But it throws an error. Here is the screenshot of the issue which came after running for 5 minutes.

enter image description here

UPDATE: This is a live production table where live data are coming. Seems like the auto_increment column is causing the issue. By the time the it applies the InnoDB engine new records are coming and the auto_increment is increased again.

Upvotes: 0

Views: 309

Answers (1)

Ivor Hort
Ivor Hort

Reputation: 23

Did you check official mysql documentation ? There is one useful text, maybe can help.

https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html

Maybe just to try with ALTER TABLE your_table ENGINE=InnoDB; I mean, without auto increment.

Upvotes: 2

Related Questions