SEO

#1 (**permalink**) 02-28-2008, 09:25 AM

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.

#2 (**permalink**) 02-28-2008, 09:25 AM

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?

--
I wish there was a knob on the TV to turn up the intelligence. There's a
knob called "brightness", but it doesn't work.
-- Gallagher

#3 (**permalink**) 02-28-2008, 09:25 AM

"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.

#4 (**permalink**) 02-28-2008, 09:26 AM

On 19 Mar, 16:13, "Ham Pastrami" <nom...@dot.com> wrote:
> "Peter H. Coffin" <hell...@ninehells.com> wrote in messagenews: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.

MyISAM does not support transactions

#5 (**permalink**) 02-28-2008, 09:26 AM

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

#6 (**permalink**) 02-28-2008, 09:26 AM

"Peter H. Coffin" <hellsop@ninehells.com> wrote in message
news:slrnevtg3c.nmn.hellsop@abyss.ninehells.com...
> Easy answer then: MyISAM doesn't support transactions, nor rollback. You
> want InnoDB instead. Change all the tables and try it again.

Well don't I feel stupid. Thanks for the revelation.

#7 (**permalink**) 02-28-2008, 09:26 AM

On Mon, 19 Mar 2007 21:25:09 GMT, Ham Pastrami wrote:
>
> "Peter H. Coffin" <hellsop@ninehells.com> wrote in message
> news:slrnevtg3c.nmn.hellsop@abyss.ninehells.com...
>> Easy answer then: MyISAM doesn't support transactions, nor rollback. You
>> want InnoDB instead. Change all the tables and try it again.
>
> Well don't I feel stupid. Thanks for the revelation.

*grin* If you make mistakes that have obvious and well-documented
solutions, you end up being able to fix them quickly and easily. Making
a really clever and unique mistake may mean *months* of research and
experimentation to fix. I prefer the easy answers.

--
56. My Legions of Terror will be trained in basic marksmanship. Any who
cannot learn to hit a man-sized target at 10 meters will be used for
target practice.
--Peter Anspach's list of things to do as an Evil Overlord

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Do sourced queries automatically commit?