Prasanna Raj <[EMAIL PROTECTED]> wrote:
Gotit Thnx ;)
You have set innodb_force_recovery to 3 which means , do not run transaction
rollbacks after recovery.
http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
1 (SRV_FORCE_IGNORE_CORRUPT)
2 (SRV_FORCE_NO_BACKGROUND)
3 (SRV_FORCE_NO_
Gotit Thnx ;)
You have set innodb_force_recovery to 3 which means , do not run transaction
rollbacks after recovery.
Just try removing the innodb_force_recovery from my.cnf file or change the
value
More info : http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html
--Praj
On Wed, 5 Apr 20
Prasanna Raj <[EMAIL PROTECTED]> wrote:
Can you through us more lights on error ? where does this occur ?
**ERROR:
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and
Hi
Can you through us more lights on error ? where does this occur ?
-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 wrot
[S] Dhandapani wrote:
mysql> show global variables like '%innodb%';
+-++
| Variable_name | Value |
+-++
| have_innodb | YES
O
Try going to:
"http://www.mysql.com/innodb rollback"
You can search the manual by typing "http://www.mysql.com/search term"
into the address bar of your browser. The first hit looked like a
winner to me.
-Sheeri
On 4/4/06, Truong Tan Son <[EMAIL PROTECTED]> wrote:
> Dear Sir,
>
> I install MyS
Ah, I finally found mention of this in the manual.
Sorry to bother everyone.
Thanks.
---
Hello,
To use InnoDB you have to put how large of a file MySQL is allowed to make by putting
an entry in /etc/my.cnf such as the one I used:
innodb_data_home_dir =