04.05.2024

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