CODEWITHSUNDEEP
mysqlmigrationinnodbmyisamresource-cleanup
Marko
Marko

Reputation: 31453

Convert MySQL database from MyISAM to InnoDB

I have to convert Mysql database from MyISAM to InnoDB.

The problem is that existing MyISAM database has a lot of inconsistent data that would make problem in InnoDB. There are invalid foreign key references everywhere, so in the process of switching storage engine I will have to clean up the junk from the database.

Is there some tool that will help me to detect those invalid fk references, since manually checking every relation would be a huge job?

Can someone who already did that share the experience, and what would be the best approach.

Upvotes: 4

Views: 584

Answers (1)

Ike Walker
Ike Walker

Reputation: 65577

Roland Bouman posted a tool for this a few years ago. I've used it in the past and found it helpful.

Here's a link to it:

http://forge.mysql.com/tools/tool.php?id=11

Upvotes: 2

Related Questions