Red Gate forums :: View topic - Transactional structure changes?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Compare
MySQL Compare forum

Transactional structure changes?

Search in MySQL Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message
matdodgson



Joined: 21 May 2010
Posts: 1

PostPosted: Fri May 21, 2010 10:37 am    Post subject: Transactional structure changes? Reply with quote

Hi folks.

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?
Back to top
View user's profile Send private message
Lionel



Joined: 16 Dec 2005
Posts: 170

PostPosted: Thu May 27, 2010 10:56 am    Post subject: Reply with quote

Hi

I am really sorry you have had problems. At the moment the DDL changes are not wrapped an a transaction but my understanding and experiments indicate that DDL operations are not transactional. In fact, if you run a DDL statement it seems to commit the current transaction. This is using InnoDB on version 5.1.45 (I haven't tried it on other storage engines/versions). If I am wrong please let me know!

If you know what caused the synchronization to fail please let me know and I will try and fix the bug!

Lionel
_________________
Software Engineer
Red Gate Software
Back to top
View user's profile Send private message
Lionel



Joined: 16 Dec 2005
Posts: 170

PostPosted: Thu May 27, 2010 10:58 am    Post subject: Reply with quote

Btw way I am very sorry it took me so long to reply to your post!

Lionel
_________________
Software Engineer
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group