Hi,
Something bad happened the other day, a query hosed all the data in
my table, but luckily I had an original dump of the table from 4
months ago and binlogs from then on. I had to load the original table
into a separate db and then grep through the binlogs for queries to
update it with, stopping
Hi!
I've got the following problem with Version 4.0.9 of Mysql:
The page
http://www.mysql.com/doc/en/COMMIT.html
says:
'If you do a ROLLBACK when you have updated a non-transactional table
you will get an error (ER_WARNING_NOT_COMPLETE_ROLLBACK) as a warning.
All transactional safe t
ROLLBACK
Because you did not set autocommit on?
Noor Dawod wrote:
>Hi all,
>
>I found out today that MySQL is adding a 'ROLLBACK' command to each
>session connecting to it, without explicitly ordering this.
>This is new since we never had this behavior before. Why is this
Because you did not set autocommit on?
Noor Dawod wrote:
>Hi all,
>
>I found out today that MySQL is adding a 'ROLLBACK' command to each
>session connecting to it, without explicitly ordering this.
>This is new since we never had this behavior before. Why is this
Hi all,
I found out today that MySQL is adding a 'ROLLBACK' command to each
session connecting to it, without explicitly ordering this.
This is new since we never had this behavior before. Why is this
happening, and how can I revert to the old beahvior (each command sent
is carri
Hi All,
I am trying to establish a transaction-oriented method of posting
changes on the MySQL database. I'm using MyODBC 3.51 and VB6.
Using the ADO Controls, I use connection.BeginTrans to start the
transaction, followed by a series of ado.updates, and finally a
connection.committrans to close
Hi.
Thanks for the reply...
I curious with what you mean by mysql not supporting commit and
rollback coz I found this in the site :
http://www.mysql.com/documentation/mysql/bychapter/manual_Refere
nce.html#COMMIT
Actually, Ive already tested it in my app under weblogic(and
worked). I was
Hi List!
Hope you can help me with my problem...
I am trying to incorporate commit and rollback in my sql
statements... I have tried it in my web application which runs
on weblogic and it work fine. However, when I migrated my web
app to Tomcat, it failed to rollback when it encountered an
MySQL with MyISAM Tables does not provide the facility of Commit or Rollback.
You need to compile MySQL with InnoDB tables to have above mentioned features.
Check out:
www.innodb.com
regards,
Durga Prasad
Placed At :
"sreedhar&quo
Hi all,
How can i RollBack or Commit using PHP in MYSQL. i have not found any
commands through PHP Doc.
regards,
sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
How can i say commit or rollback using php. i didnot find any commands for
commit or rollback for mysql in php.
regards,
sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
cs: ~/personal >> mail [EMAIL PROTECTED]
Subject: automatic roll-back
I am using BDB tables as offered by MySQL version 3.23.43-max.
My question is related to aborting transactions.
I am implementing a global transaction manager and using
several MySQL engines. Suppose the GTM fails, what happen
George,
the default in MySQL is
set autocommit = 1;
To be able to do rollbacks you have to execute
set autocommit = 0;
Then you can do
insert into ...;
rollback;
I assume you specified in CREATE TABLE ... (...) TYPE=INNODB?
Regards,
Heikki
Copied message:
.
Hello everybody
gt;disconnect(), MySQL (or
>> is it the Perl DBI module) will run rollback() with an error message:
>> Issuing rollback() for database handle being DESTROY'd without explicit
>> disconnect().
>>
>> My question is, is there any bad effect for MySQL to run the rollba
gt; If I run Perl DBI's $dbh->connect() without $dbh->disconnect(), MySQL (or
>> is it the Perl DBI module) will run rollback() with an error message:
>> Issuing rollback() for database handle being DESTROY'd without explicit
>> disconnect().
>>
>> My ques
Batara Kesuma <[EMAIL PROTECTED]> writes:
> Hello,
>
> I think it might not be a right mailing list for this question, but I
> don't know where else should I post it.
>
> If I run Perl DBI's $dbh->connect() without $dbh->disconnect(), MySQL (or
> i
Hello,
I think it might not be a right mailing list for this question, but I
don't know where else should I post it.
If I run Perl DBI's $dbh->connect() without $dbh->disconnect(), MySQL (or
is it the Perl DBI module) will run rollback() with an error message:
Issuing rollbac
Hi!
It was the same rollback bug which caused also crash in the case
you ran out of tablespace. I had overlooked that the same bug causes
problems also if you rollback a transaction which has updated the
same row more than once.
You can download the fixed /mysql/innobase/row/row0undo.c from
my
>Description:
InnoDB crashes when a ROLLBACK of multiple "LOAD DATA INFILE 'file'
REPLACE INTO 'table' commands.
mysqld will not startup again because InnoDB attempts the rollback
and crashes again.
>How-To-Repeat:
#create a data file (100,000 lines
On Tue, 8 May 2001, Rajeev Ramanujan wrote:
> Date: Tue, 8 May 2001 19:49:11 +0530
> From: Rajeev Ramanujan <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Commit and Rollback.
>
> Hi,
>
>Will MySQL support COMMIT and ROLLBACK.
>
Rajeev,
with the transaction-safe table types InnoDB and BDB, MySQL supports
commit and rollback. They are available in the Unix source distribution and
in the MySQL -Max binary distribution. Monty said he already has also
Windows sources ready and will post them once he has time.
Regards
Hi,
Will MySQL support COMMIT and ROLLBACK.
Thank You
Rajeev Ramanujan
gt; It's called from the command line with mysql -u root -p db_name <
> file;
>
> I would like to undo the first operation on table_1 in case the second query (on
> table_2) returns an error.
> I believe this could be done by using commit/rollback if I used BDB tables. But
&
ond query (on
table_2) returns an error.
I believe this could be done by using commit/rollback if I used BDB tables. But
I'm using MyISAM.
Any hints how could I make this?
Thanks,
Jochen
-
Before posting, please check:
ht
Roselli wrote:
> Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ?
>
> mysql> BEGIN;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> UPDATE tabgral set codigo=2 where codigo=1 and nrotab=99;
> Query OK, 1 row affected (0.00 sec)
> Rows match
**READ THE MANUAL BEFORE POSTING TO THE LIST**
http://www.mysql.com/docs
On Tue, 10 Apr 2001, Bruno Roselli wrote:
> Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ?
>
> mysql> BEGIN;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> UPDATE ta
Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ?
mysql> BEGIN;
Query OK, 0 rows affected (0.00 sec)
mysql> UPDATE tabgral set codigo=2 where codigo=1 and nrotab=99;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> ROLLBACK;
E
KB> Doesn't mysql support begin and rollback transactions?
I *believe* it went like this -- syntax supported and returned success
without doing anything in older versions, then functionality was
actually *implemented* more recently -- maybe only most recent stable
release
ql> select * from host_info;
+--+
| hostname |
+--+
| Kris |
+--+
1 row in set (0.00 sec)
mysql> delete from host_info where hostname="Kris";
Query OK, 1 row affected (0.00 sec)
mysql> select * from host_info;
Empty set (0.00 sec)
mysql> roll
The MySQL manual is one of the best I've seen
1)
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html
#Commit-rollback
2)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOI
N
Regards,
Gary "SuperID
On Wed, Apr 04, 2001 at 02:52:39PM -0700, Kristopher Briscoe wrote:
>
> Doesn't mysql support begin and rollback transactions? If so what
> is the correct procedure to make it happen. I logged in and ran my
> query..
Depends on the table type. Check the manual for details
Sorry if this is mundane for some, but I have searched the manual and I
cannot find the answer to itTwo issues here
.
1)
Doesn't mysql support begin and rollback transactions? If so what is the
correct procedure to make it happen. I logged in and ran my query..
>select * from h
* Irmund Thum <[EMAIL PROTECTED]> wrote on 25.02.01 17:20:
> ERROR 1196: Warning: Some non-transactional changed tables couldn't be
> rolled back
> ***
> so I'm not that expert knowing what "non-transactional changed tables"
> exactly means
You're probably using the RPM version or otherwise just
[EMAIL PROTECTED] schrieb:
>
> create table bdbtest (pk int primary key, name varchar(20)) type=bdb;
> begin;
> insert into bdbtest values (1, 'tim');
> rollback;
> select * from bdbtest;
> (I see the row but should not)
on RH7 I get
***
mysql> select * from
Hi all, has anyone also seen problems with ROLLBACK not working when
installing MySQL on Red Hat Linux 7.0? On Red Hat Linux 7.0, ROLLBACK does
nothing (though it doesn't generate an error either, and the table is
listed as a BDB in show table status, and locking works as expected with a
>Description:
Rollback still does not work with MySQL 3.23.32 and BDB 3.2.3h.
This same problem has been encountered with earlier versions of
MySQL as well. However, all hosts on which this has been noticed
have been running Red Hat Linux 7.0, which could be
101 - 136 of 136 matches
Mail list logo