Re: InnoDB problem with windows MySQL 5.0.15?
hi,
I also had this problem and fixed it by deleting BOTH my DATA and LOG files at the same time and restarting the server.
For example,
Step 1. Stop MySQL service
Step 2. Delete files:
C:\Program Files\MySQL\MySQL Server 5.0\data\ib_logfile*
C:\MySQL Datafiles\ibdata*
Step 3: Restart MySQL service
MySQL InnoDB needs to create both DATA and LOGS at the same time -- it says this in the log file output. So if you don't delete both data and log files at the same time when it starts up it will fail to create the InnoDB database files properly and InnoDB will show up as DISABLED rather than DEFAULT (when using "show engines").
Dan.
Subject
Views
Written By
Posted
45149
November 10, 2005 03:35PM
6505
November 10, 2005 04:08PM
4521
November 10, 2005 07:50PM
3878
November 11, 2005 05:18PM
3634
November 11, 2005 08:25PM
3431
November 13, 2005 11:47PM
3225
November 14, 2005 01:24PM
Re: InnoDB problem with windows MySQL 5.0.15?
7168
November 15, 2005 10:59PM
2873
October 30, 2006 01:32AM
2575
November 18, 2005 07:13AM
2392
November 18, 2005 12:02PM
2495
November 19, 2005 02:44AM
3177
November 21, 2005 04:42AM
9656
July 26, 2006 11:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.