innodb and myisam tables

First might I just say that I've been waiting *years* for red gate to make mysql versions of red gate sql compare and sql data compare. I've used Sql compare / Sql data compare for years on Sql server and these are amazing tools! Great to see Sql compare for mysql.

Anyway, I am comparing the structure of 2 mysql databases. During the synchronisation, I got an error message from sql compare and the sync did not complete. Unfortunately, I notice that the synchronisation has been partly completed so the structure changes were not wrapped in a transaction. This is not good!

The database in question has a mix of innodb and myisam tables - perhaps this has something to do with it?

collieart October 18, 2012 05:23

Comments

1 comment

Thanks for the kind message. I've forwarded to our development team but believe the problem may actually be whether schema changes can even be wrapped in a transaction in MySQL. Please correct me if I'm wrong, but I've included a couple of similar questions posted online who's answers suggest this:

http://stackoverflow.com/questions/3413 ... ansactions

http://forums.mysql.com/read.php?97,548 ... #msg-54955

Michael Christofides October 19, 2012 10:49

0

Add comment

Please sign in to leave a comment.

How can we help you today?

innodb and myisam tables

Comments

Add comment