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:[EMAIL PROTECTED] 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 < [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> 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:[EMAIL PROTECTED]<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 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: 9912924044 URL: ed-ventures-online.com<http://ed-ventures-online.com> Email-id: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
