List:General Discussion« Previous MessageNext Message »
From:Rolando Edwards Date:January 17 2008 3:36pm
Subject:RE: Innodb gets disabled
View as plain text  
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:prajapatikc@stripped]
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 <
redwards@stripped<mailto:redwards@stripped>> 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:prajapatikc@stripped<mailto:prajapatikc@stripped>]
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: prajapatikc@stripped <mailto:prajapatikc@stripped>

Thread
Innodb gets disabledKrishna Chandra Prajapati16 Jan
  • Re: Innodb gets disabledBaron Schwartz16 Jan
    • OT: Sun to buy MysqlBrett Harvey16 Jan
      • Re: OT: Sun to buy MysqlJohn Meyer16 Jan
        • RE: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subjectjmacaranas16 Jan
          • Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subjectRichard Heyes16 Jan
            • Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subjectSebastian Mendel16 Jan
              • RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subjectjmacaranas16 Jan
                • RE: [SPAM] - Re: [SPAM] - Re: OT: Sun to buy Mysql - Email found in subject - Email found in subjectjmacaranas16 Jan
                  • Re: OT: Sun to buy MysqlMichael DePhillips16 Jan
                • RE: Sun to buy MysqlNicole Garris16 Jan
                  • RE: Sun to buy Mysql - mysql press releaseBrett Harvey16 Jan
    • Re: Innodb gets disabledKrishna Chandra Prajapati16 Jan
  • RE: Innodb gets disabledRolando Edwards16 Jan
    • Re: Innodb gets disabledKrishna Chandra Prajapati17 Jan
      • Re: Innodb gets disabledBaron Schwartz17 Jan
        • creating temp file, modifying data and putting into other tableKerry Frater17 Jan
          • Re: creating temp file, modifying data and putting into other tableJochem van Dieten17 Jan
            • RE: creating temp file, modifying data and putting into other tableKerry Frater17 Jan
              • Re: creating temp file, modifying data and putting into other tableJochem van Dieten18 Jan
          • Re: creating temp file, modifying data and putting into other tableSebastian Mendel18 Jan
            • RE: creating temp file, modifying data and putting into other tableKerry Frater18 Jan
              • RE: creating temp file, modifying data and putting into other tableSaravanan18 Jan
                • RE: creating temp file, modifying data and putting into other tableKerry Frater18 Jan
                  • RE: creating temp file, modifying data and putting into other tableSaravanan18 Jan
                    • RE: creating temp file, modifying data and putting into other tableKerry Frater21 Jan
        • Re: Innodb gets disabledKrishna Chandra Prajapati21 Jan
      • RE: Innodb gets disabledRolando Edwards17 Jan
  • Re: creating temp file, modifying data and putting into other tableMartin Gainty18 Jan
    • RE: creating temp file, modifying data and putting into other tableKerry Frater21 Jan