(WORKED) Re: InnoDB how to.

2006-04-05 Thread Truong Tan Son
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_

Re: InnoDB how to.

2006-04-05 Thread Prasanna Raj
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

Re: InnoDB how to.

2006-04-04 Thread Truong Tan Son
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

Re: InnoDB how to.

2006-04-04 Thread Prasanna Raj
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

Re: InnoDB how to.

2006-04-04 Thread Truong Tan Son
[S] Dhandapani wrote: mysql> show global variables like '%innodb%'; +-++ | Variable_name | Value | +-++ | have_innodb | YES O

Re: InnoDB how to.

2006-04-04 Thread sheeri kritzer
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

[solved] Re: InnoDB: How to increase table/DB size "after the fact"?

2001-12-05 Thread JW
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 =