MySQL Database plugin ' federated ' is disabled. Error resolution

Source: Internet
Author: User


The exact contents of the error are:

121012 11:35:03 [note] Plugin ' federated ' is disabled.
121012 11:35:03 InnoDB:Error:unable to create temporary file; Errno:2
121012 11:35:03 [ERROR] Plugin ' InnoDB ' init function returned ERROR.
121012 11:35:03 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE.
121012 11:35:03 [ERROR] unknown/unsupported table Type:innodb
121012 11:35:03 [ERROR] Aborting


I find solutions on the Internet:

1, in the My.ini file in [mysqld] add a row tmpdir= "d:/mysql/data/" modified, or can not start or could start but shutdown after the same problem, and then I did a second step, restart normal.

2, delete the data directory in addition to the database folder other files, restart MySQL, problem solving.

I did it the way I did, but no, I figured out a solution that was similar to the above.

First step:

Just delete the Ib_logfile0 and ib_logfile1 two files in the MySQL directory
Step Two:

Found the reason for the failure to start: MySQL does not automatically initialize the Tmpdir (temporary file directory) at the time of installation, so to add the Tmpdir path in the configuration file My.ini.

Finally, add in My.ini:

[Mysqld]
#自己指定的临时文件目录
Tmpdir= "E:/program files/mysql/mysql Server 5.1/temp/"

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.