title: MySQL Create tables without committing current transaction
body: <p>I'd like my program to be able to install plugins, and rollback all the changes made if an error occurs. So I create a transaction that keeps all the things that were added while installing the plugin. The problem is that the plugin may want to create tables, and doing so automatically commits the current transaction in MySQL.</p>
  
  <p>See <a href="http://dev.mysql.com/doc/refman/5.1/en/implicit-commit.html" rel="nofollow noreferrer">Statements That Cause an Implicit Commit</a> on MySQL web site.</p>
  
  <p>Any idea on how I could do it?</p>
  
  <p>I thought of using temporary tables as they are not automatically committed, unless they are using too much memory, but it looks like temporary tables cannot be rolled back anyway (and I haven't found a way to convert them to permanent tables).</p>
  
  <p>I just found out about "<a href="http://dev.mysql.com/doc/refman/5.1/en/savepoint.html" rel="nofollow noreferrer">save points</a>", but I don't really understand how/when it should be used nor if it can help me achieve what I want.</p>