I have used the command below to change the file system permissions chown -R mysql:mysql /data/mysql
On Jan 17, 2008 5:01 PM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > 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] > > > -- 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]
