Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I use SQLyog as a client against MYSQL.

I would like to execute an SQL script an optionally commit or rollback (as with the client SQLDeveloper). How can I do that with SQLyog? I've searched the web and the help, to no avail.

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

If you start a DB Session with START TRANSACTION, everything will be controlled via MVCC and you would have to execute COMMIT. If the DB Connection terminates (voluntarily or involuntarily), everything will rollback.

You could also SET autocommit = 0; to disable it for your session.

Please make sure all involved tables are InnoDB

If any tables involved in UPDATE joins and DELETE joins involve a mixture of InnoDB and MyISAM, changes to the MyISAM table will not rollback since it does not support ACID-compliant transactions.

share|improve this answer
add comment

According to this article every client connect to mysql with enabled autocommit.

You can disabled it and work with rollback like in SQLdeveloper. But in contrast to the SQLdeveloper you need to execute commit statements manually.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.