innodb and myisam tables

Compares and synchronizes MySQL database schemas.

Moderators: Chris Auckland, eddie davis, Michael Christofides

innodb and myisam tables

Postby collieart » Thu Oct 18, 2012 10:23 am

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
 
Posts: 1
Joined: Thu Oct 18, 2012 10:19 am

Postby Michael Christofides » Fri Oct 19, 2012 3:49 pm

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
 
Posts: 94
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software


Return to MySQL Compare

Who is online

Users browsing this forum: No registered users and 1 guest

cron