Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Changing table type from MyISAM to InnoDB

I wonder if I convert some tables from MyISAM to InnoDB, will it cause any corruptions of data?

I am in need to convert some tables to InnoDB so I can use transaction, but they are holding very important data so I'm not sure if I should do the conversion or not.

like image 674
Zekeil Avatar asked Jul 28 '11 03:07

Zekeil


1 Answers

While changing the database engine of a table is a simple and common task which should cause no corruption, the only way to guarantee no corruption can occur is to first make your own backup.

like image 88
Dan Grossman Avatar answered Sep 22 '22 02:09

Dan Grossman