MYSQL cannot be started. Prompt: Default storage engine (InnoDB) is not available solution

Source: Internet
Author: User

Add skip-innodb TO my. ini (/etc/my. cnf in linux.
After I set it like this, there is no problem in linux. I started MYSQL in winXP on my local machine today, prompting that the MYSQL cannot be started. Check the error log of the mysql directory:
Reference
090613 10:15:27 [ERROR] Default storage engine (InnoDB) is not available
090613 10:15:27 [ERROR] Aborting

090613 10:15:27 [Note] C: \ www \ mysql \ bin \ mysqld-nt: Shutdown complete

It is estimated that after the parameter is added last time, it never starts up... Mysql of the local machine has not been used for a long time.
Check, my. in ini, the default-storage-engine = INNODB engine is set to INNODB, and skip-innodb is added to it.

Change default-storage-engine to MYISAM, and MYSQL starts OK!
You can delete the ibdata1, ib_logfile0, and ib_logfile1 files in the data directory under skip-innodb.

After the test, when skip-innodb is not added, the three files are deleted and the three files are automatically created at startup. The log is as follows:
Reference
InnoDB: The first specified data file. \ ibdata1 did not exist:
InnoDB: a new database to be created!
090613 10:19:37 InnoDB: Setting file. \ ibdata1 size to 10 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 24 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 24 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, add skip-innodb, and then start the log:
Reference

090613 10:30:12 [Note] C: \ www \ mysql \ bin \ mysqld-nt: Normal shutdown

090613 10:30:12 [Note] C: \ www \ mysql \ bin \ mysqld-nt: Shutdown complete

090613 10:30:17 [Note] C: \ www \ mysql \ bin \ mysqld-nt: ready for connections.
Version: '5. 0.45 'socket: ''' port: 3306 Source distribution

The three files will not be generated automatically.

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.