Error Solution of MySQL shutdown unexpectedly

Hello everyone, welcome back at porkaone. On this occasion we will discuss the solution to the problem of MySQL suddenly shutdown when turned on. Let's follow in full below.

Have you ever had a MySQL shutdown error problem unexpectedly or suddenly turned off on its own when turned on?, or do you have a problem like the picture below.

MySQL Error

Don't panic!, and don't rush to uninstall your Xampp. Here I give a powerful solution for those of you who are looking for a way to fix it. This can happen due to missing data or dependencies. If there is insufficient data, usually restarting will also not turn on. The solution that we can apply is to make a mysql backup.

How to Fix MySQL Shutdown Error Unexpectedly

1. Go to the xampp/mysql folder then rename the data folder to data_old

2. Copy the backup folder, and rename the folder to data

3. Then open the data_old folder, then copy all the databases in it (except mysql, performance_schema, and phpmyadmin) and paste it into the data folder

4. In addition to the database, also copy the ibdata1 file in the data_old folder, then move it to the data folder

5. Restart your MySQL through the control panel.

Backup

If the steps above are executed correctly, then the database should run properly. Why am I sure, because I often get errors like that.

And to prevent something similar from happening again, I recommend turning off mysql and apache first before turning off your computer or laptop. And don't ever try to delete Xammp, because it's not the right solution and it's a shame that the database contains a lot of content.

Ok, that's the solution for the unexpectedly shutdown MySQL error. Hopefully this is useful, if you have any problems, just ask in the comments column below. Don't forget to share and comment. Bye and see you.