Have you checked filesystem permissions where InnoDB needs to create its files? And you're sure you've removed ALL of InnoDB's previous data and log files? And there's nothing in the server's error logs? Are you looking in the right error logs? (cause an error deliberately and look for it to be sure).
On Jan 17, 2008 3:04 AM, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
