MySQL InnoDB data failed to start solution

Source: Internet
Author: User
Tags mysql tutorial

The following statement appears: The ' InnoDB ' feature is disabled; You are need MySQL built with ' InnoDB ' to have it working;

is the MySQL tutorial configuration file banned this option!
To close the MySQL database tutorial
Locate the My.ini file in the MySQL installation directory
Find Skip-innodb, add the # to the front
Save, open MySQL database! Get!
This is also the way to open MySQL database InnoDB function!!


Start No workaround

090613 10:15:27 [ERROR] Default storage Engine (InnoDB) is not available
090613 10:15:27 [ERROR] Aborting

090613 10:15:27 [note] C:wwwmysqlbinmysqld-nt:shutdown complete

It is estimated that the last time the parameter has been added, has not started up. It's been a long time since MySQL was out of this machine.
Check the next, the original My.ini in a sentence: Default-storage-engine=innodb, the default engine set for INNODB, and I added Skip-innodb, no wonder the Kai is not coming.

Change Default-storage-engine to Myisam,mysql start ok!
Under the SKIP-INNODB, the data directory ibdata1,ib_logfile0,ib_logfile1 the three files are not needed, you can delete.

After testing, the three files were deleted when the Skip-innodb was not added, and the three files were automatically created when the log was started, as follows:
Reference
Innodb:the-specified data file. Ibdata1 did not exist:
INNODB:A new database to is created!
090613 10:19:37 innodb:setting file. Ibdata1 size to MB
Innodb:database physically writes the file full:wait ...
090613 10:19:37 innodb:log file. Ib_logfile0 did not exist:new to be created
innodb:setting log file. Ib_logfile0 size to MB
Innodb:database physically writes the file full:wait ...
090613 10:19:38 innodb:log file. Ib_logfile1 did not exist:new to be created
innodb:setting log file. Ib_logfile1 size to MB
Innodb:database physically writes the file full:wait ...
Innodb:doublewrite Buffer not found:creating new
Innodb:doublewrite Buffer Created
Innodb:creating FOREIGN KEY constraint system tables
Innodb:foreign key constraint system tables created
090613 10:19:39 innodb:started; Log sequence number 0 0
090613 10:19:39 [note] C:wwwmysqlbinmysqld-nt:ready for connections.


Delete these three files again, add Skip-innodb, start log:
Reference

090613 10:30:12 [note] C:wwwmysqlbinmysqld-nt:normal shutdown

090613 10:30:12 [note] C:wwwmysqlbinmysqld-nt:shutdown complete

090613 10:30:17 [note] C:wwwmysqlbinmysqld-nt:ready for connections.
Version: ' 5.0.45 ' socket: ' port:3306 Source distribution

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.