Mysql failed to start prompt: Default storage engine (InnoDB) is not available solution _mysql
Source: Internet
Author: User
In My.ini (under Linux/etc/my.cnf) plus skip-innodb, it's OK.
I set this up, under Linux are no problem, today in my native WinXP start MySQL, prompted not to start up. Look at the error log in the MySQL directory:
Reference
090613 10:15:27 [ERROR] Default storage Engine (InnoDB) is not available
090613 10:15:27 [ERROR] Aborting
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:\www\mysql\bin\mysqld-nt:ready for connections.
Delete these three files again, add Skip-innodb, start log:
Reference
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.
