RE: Innodb gets disabled

[Rolando Edwards]

Login to mysql and execute SHOW VARIABLES LIKE 'innodb%';

And email  the display

Also, show the last 30-50 lines of your error log

And let's see if they reveal anything

________________________________
From: Krishna Chandra Prajapati [mailto:prajapatikc@stripped]
Sent: Thursday, January 17, 2008 3: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 <
redwards@stripped<mailto:redwards@stripped>> wrote:
1) 'mysqldump' all databases to an SQL file
2) Drop all databases
3) Shutdown mysqld
4) Delete the ibdata1, ib_logfile0, ib_logfile1
5) Add innodb_file_per_table to my.cnf (which you already did)
6) Make sure you gave this setting in [mysqld] group of my.cnf
innodb_data_file_path=ibdata1:10M:autoextend
7) Start mysqld
mysqld should recreate ibdata1, ib_logfile0, ib_logfile1
8) Reload all the databases from the SQL file

Give it a try !!!

-----Original Message-----
From: Krishna Chandra Prajapati
[mailto:prajapatikc@stripped<mailto:prajapatikc@stripped>]
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 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 -server
innodb engine gets disabled. What can be the issue.
Please help me, Even if any body know to enable innodb storage engine in
mysql please let me know

Thanks
Krishna Chandra Prajapati



--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road , Secunderabad.
Pin Code: 500003
Office Number: 040-66489771
Mob: [phone]
URL: ed-ventures-online.com<http://ed-ventures-online.com>
Email-id: prajapatikc@stripped <mailto:prajapatikc@stripped>