Error: Unknown storage engine 'innodb' when mysql executes the SQL file. engineinnodb

Error: Unknown storage engine 'innodb' when mysql executes the SQL file. engineinnodb

Problems Found

Recently, I encountered a problem in my work. I ran an innoDB SQL file and reported the Error: Unknown storage engine 'innodb'. I checked many methods online, however, I can't solve my problem. I solved it later. I will summarize the process here to make it easy for friends who have encountered similar situations to have some reference. I will not talk about it below, let's take a look at the detailed introduction.

Solution Process:

I am using a database of MySQL. Run the "show engines" command first when the preceding error occurs. view the engine details:

No innodb entry found:

Then we can view the log file:

If you do not know the location of the windowns log file, run the following command:->show variables like '%error%';View

Then: in the log, we find that:

The error is that the content of the ibdata1 file is incorrect.

Next, we close the data service, delete the ibadata1 file under the installation directory, and view the following two files in the same directory as the error log:

After the deletion is successful, modify the parameters of the my. ini file.

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

Whereinnodb_flush_method = normalIs final, and other parameters are included in the original configuration file.

Save the changes and start the mysql service again.

Execute again-》show engines;

InnoDB is ready for use.

Run the file again to run it perfectly.

Summary

The above is all the content of this article. I hope the content of this article will help you in your study or work. If you have any questions, please leave a message, thank you for your support.