Reload MySQL failed to start service issue

Source: Internet
Author: User

Linux cannot restart solution after MySQL reload

Before the installation of the mysql5.1, but after the System Restore service did not, simply upgraded to 5.5, but the installation is good, the last step of configuration is not start!

View log: Programdata/data/pc.err found:

111121 22:16:50 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 ...
111121 22:16:50 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 ...
111121 22:16:50 Innodb:cannot Initialize created log files because
111121 22:16:50 innodb:data files are corrupt, or new data files were
111121 22:16:50 innodb:created The database was started previous
111121 22:16:50 Innodb:time But the database is not shut down
111121 22:16:50 innodb:normally after that.
111121 22:16:50 [ERROR] Plugin ' InnoDB ' init function returned ERROR.
111121 22:16:50 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE.
111121 22:16:50 [ERROR] unknown/unsupported storage Engine:innodb
111121 22:16:50 [ERROR] Aborting

Check on the Internet, the original will be ib_logfile0,ib_logfile1, and ibdata1 these three files deleted only line, they are in the data and Programdata directory (in the configuration of the designated by you).


Unable to restart solution after MySQL reload under Windows

Workaround:

1: Uninstall MySQL First, manually remove all clean files from its installation directory.

2: Delete all the documents about Mqsql in C:/programdata/mysql.

3: Reinstall the MySQL program.

The MySQL service will start properly

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.