On Mon, 19 Mar 2007 16:13:04 GMT, Ham Pastrami wrote:
>
> "Peter H. Coffin" <hellsop@ninehells.com> wrote in message
> news:slrnevt157.nmn.hellsop@abyss.ninehells.com...
>> On Sun, 18 Mar 2007 17:31:10 -0700, Ham Pastrami wrote:
>> > Greetings all, I am trying to track down the cause of some issues I'm
>> > having. I am doing this from the mysql prompt:
>> >
>> > start transaction;
>> > source c:/queries.sql;
>> > rollback;
>> >
>> > When I examine the db though, it appears that the changes from the
> sourced
>> > queries have been committed.
>>
>> What type/engine are the affected tables?
>
> MyISAM.

Easy answer then: MyISAM doesn't support transactions, nor rollback. You
want InnoDB instead. Change all the tables and try it again.

--
Christian Biblical literalists are trusting themselves to an archaic English
translation of a Latin translation of (help me here) Greek? Aramaic? source.
I wouldn't even trust a VCR manual to make it through that intact. - Dr. Dee