More info : http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
--Praj
On Wed, 5 Apr 2006 14:02:06 +0700
"Truong Tan Son" <[EMAIL PROTECTED]> wrote:
Prasanna Raj <[EMAIL PROTECTED]> wrote:
> Can you through us more lights on error ? where does this occur ?
*
eout
[EMAIL PROTECTED] var]#
-bash-2.05b$ perror 10 30
OS error code 10: No child processes
OS error code 30: Read-only file system
-bash-2.05b$
-Praj
On Wed, 5 Apr 2006 08:48:08 +0700
"Truong Tan Son" <[EMAIL PROTECTED]> wrote:
[S] Dhandapani wrote:
> mysql> show g
R;|*
+--++
| A| B |
+--++
|| |
+--++
the inset stattement has been rollbacked.
Reference
http://dev.mysql.com/doc/refman/5.0/en/innodb-transactions-with-different-apis.html
Regards,
Dhandapani
Dba Sify Limited.
Truong Tan Son wrote:
Dear Sir,
I install MySQL 5.
Dear Sir,
I install MySQL 5.0.18 on RH EL4, but do not know how to use InnoDB for
"ROLLBACK".
./configure --prefix=/usr/local/mysql \
--exec-prefix=/usr/local/mysql \
--with-innodb
make && make install
**/etc/my.cnf:
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir
Dear Sir,
How to know MySQL enable for ROLLBACK ?
Thanks you and best regards,
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ED]'
Or
update TABLE1 a, TABLE2 b set a.FIELD1=b.FIELD2
where b.column2=a.column1
And column1 = '[EMAIL PROTECTED]'
Thanks you very much.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Ing. Edwin Cruz" <[EMAIL PROTECTED]>
Cc: ; "'Truo
Dear Sir,
MySQL-4.1.12 on RedHat Linux EL4:
mysql> update TABLE1 set FIELD1=(select FIELD2 from TABLE2 where COLUMN2=
'[EMAIL PROTECTED]') where COLUMN1='[EMAIL PROTECTED]';
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp
onds to your MySQL server version for t
t take effect on MySQL 5.0.18
2006/3/14, Truong Tan Son <[EMAIL PROTECTED]>:
Dear Sir,
I could not find table of innoDB in mysql.
Tables in the mysql are MyISAM and should stay that way.
Odds are that there is a skip-innodb in your my.cnf on your RHE, and not you XP.
what produces a &
: Monday, March 13, 2006 5:13 PM
Subject: Re: Rollback is not take effect on MySQL 5.0.18
2006/3/11, Truong Tan Son <[EMAIL PROTECTED]>:
Dear Sir,
On RedHat Enterprise 4, and MySQL 5.0.18, I did :
mysql> set autocommit=0;
mysql> savepoint abc;
mysql> insert something
Dear Sir,
On RedHat Enterprise 4, and MySQL 5.0.18, I did :
mysql> set autocommit=0;
mysql> savepoint abc;
mysql> insert something
mysql> rollback to save point abc;
Query OK, 0 rows affected, 1 warning (0.00 sec)
^^
RollBack is N
10 matches
Mail list logo
