Shulou(Shulou.com)06/01 Report--

This article will explain in detail for you how to solve the problem of error Error: Unknown storage engine'InnoDB in mysql implementation of sql files. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Resolution process:

I use the MySql5.5 version of the database. When the above error occurs, use the command-"show engines; to check the engine details:"

It is found that there is no innodb entry:

Then we look at the log file:

Those who do not know the location of the windowns log file can be viewed with the command-> show variables like'% error%';.

Then: in the log, we found that:

The error lies in the incorrect contents of the ibdata1 file.

Next, we turn off the data service, delete the ibadata1 file in the installation directory, and two files in the same directory as the error log.

After the deletion is successful, change the my.ini file parameters.

Innodb_buffer_pool_size = 256Minnodb_log_file_size = 256Minnodb_thread_concurrency = 16innodb_flush_log_at_trx_commit = 2innodb_flush_method = normal

Innodb_flush_method = normal is the last to be added, and other parameters are included in the original configuration file.

When the changes are complete, save and restart the mysql service.

Execute again-"show engines

It is found that innoDB is ready to use, which indicates success.

Run the file again and it will run perfectly.

On solving the problem of mysql implementation of sql file error Error: Unknown storage engine'InnoDB is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.