[FIXED] XAMPP Error: MySQL shutdown unexpectedly | Repair Corrupted Database

hello everyone in this video i will show you how to fix this error mysql shutdown unexpectedly so in a previous video that you can find in the description i explained how to fix this error when the poor number is used by another application and in this video i will show you how to fix this error when the mysql database is corrupted so let's click on the start button of the mysql service so we can see that the poor number appears then disappears and then we have this error this means that we need to repair the mysql database so let's go to the folder of example then let's open the mysql folder so here we have the data folder which contains the data of our database so let's make a copy of this folder then i will rename this folder and i will call it data old now let's repair this folder so here we can see that we have different folders each folder corresponds to a database so here we have to keep our databases and we need to delete the mysql databases so the first mysql database is this folder so let's select it also we need to select this folder called performance schema so we have to click on the control button of the keyboard and then we have to click on this folder then we have to delete this folder called phpmyadmin and finally we have to delete this folder so let's delete all of these folders then we need to select all the files but we should not delete this file it is called ib data one so let's unselect it now let's delete all the files and then let's go to the backup folder to repair our data so this is the backup folder so let's copy everything inside this folder but we should not copy this file it is called ib data1 so let's unselect it then let's copy everything then let's go back to our data folder and let's paste what we have copied now we can close this folder and now let's start the mysql service again so now mysql is running correctly and we don't have the error anymore we can also go to phpmyadmin to check our databases and here we can see that we have all our databases

Channel: BoostMyTool

Views: 746,104

Keywords:

Id: 84IOtc05TuA

Length: 3min 2sec (182 seconds)

Published: Thu May 12 2022