Re: Innodb gets disabled

2008-01-21 Thread Krishna Chandra Prajapati
from the SQL file Give it a try !!! -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 7:52 AM To: MySql Subject: Innodb gets disabled Hi all, In order to reclaim the free space from mysql innodb

Re: Innodb gets disabled

2008-01-17 Thread Krishna Chandra Prajapati
the databases from the SQL file Give it a try !!! -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 7:52 AM To: MySql Subject: Innodb gets disabled Hi all, In order to reclaim the free space from mysql innodb storage

Re: Innodb gets disabled

2008-01-17 Thread Baron Schwartz
Subject: Innodb gets disabled Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added innodb_file_per_table component in my.cnf. Restarted

RE: Innodb gets disabled

2008-01-17 Thread Rolando Edwards
:04 AM To: Rolando Edwards Cc: MySql Subject: Re: Innodb gets disabled I did the same as you have written, but innodb storage engine is not available now. Even the skip-innodb is commented in my.cnf On Jan 16, 2008 9:43 PM, Rolando Edwards [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: 1

Innodb gets disabled

2008-01-16 Thread Krishna Chandra Prajapati
Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added innodb_file_per_table component in my.cnf. Restarted mysql server. After restarting mysql

Re: Innodb gets disabled

2008-01-16 Thread Baron Schwartz
Hi, On Jan 16, 2008 7:52 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added

Re: Innodb gets disabled

2008-01-16 Thread Krishna Chandra Prajapati
no errors are there in log file On Jan 16, 2008 6:38 PM, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, On Jan 16, 2008 7:52 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql

RE: Innodb gets disabled

2008-01-16 Thread Rolando Edwards
gets disabled Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added innodb_file_per_table component in my.cnf. Restarted mysql server. After