mysql executes sql file and reports error Error: Unknown storage engine'InnoDB' solution

Find the problem

I recently encountered a problem at work. When I ran an innoDB type sql file, I reported the error Error: Unknown storage engine 'InnoDB'. I searched for many methods on the Internet, but none of them could really solve my problem. Later, I solved it. Here I summarize the process for friends who encounter similar situations to refer to. Without further ado, let's take a look at the detailed introduction.

Solution process:

I am using the MySql5.5 database. When the above error occurs, first use the command -> show engines; to view the engine details:

It was found that there was no entry for innodb:

Then we look at the log file:

If you don't know the location of the windowsns log file, you can use the command ->show variables like '%error%'; to view it.

Then: In the log we found:

The error is that the contents of the ibdata1 file are incorrect.

Next, we shut down the data service, delete the ibadata1 file in the installation directory, and the two files in the same directory as the error log: see the following figure

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

innodb_buffer_pool_size = 256M

innodb_log_file_size = 256M

innodb_thread_concurrency = 16

innodb_flush_log_at_trx_commit = 2

innodb_flush_method = normal

Among them, innodb_flush_method = normal was added last, and the other parameters were already in the original configuration file.

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

Execute again -》show engines;

It is found that innoDB is already available, which means success.

Run the file again and it will run perfectly.

Summarize

The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.