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]> 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.cnfinnodb_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] > 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 Email-id: [EMAIL PROTECTED]
