----- Original Message ----- > From: "thufir" <hawat.thu...@gmail.com> > Subject: is a .sql file transactional
> when you run a .sql file, which modifies a schema, is it transactional? > Specifically, is it an all-or-nothing proposition? Or, can some commands > get executed, some fail? A file is nothing more than just another input method, it has no impact on transactionality or any other parameters. DDL (schema modification) cannot be done inside a transaction - mysql will automatically commit your open transaction before proceeding, if you have one. Every DDL statement individually is, however, all-or-nothing - the server (mostly) makes a copy of the table you're operating on, and only switches them out if the change was successful. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
