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] 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]