In this post we will solve how to fix error:MySQL shutdown unexpectedly without loosing any data. This problem happens when MySQL files are damaged or corrupted.  However we can easily solve the probelm using the following steps with the help of backup directory located at mysql directory.

 

Step:1 -

Go to C:\xampp\mysql ( your xampp installation drive) and rename data folder into data_old also create a new folder data

 

Step:2 -

Go to C:\xampp\mysql\backup , copy everything and paste inside newly created data directory. 

 

Step:3 -

Go to C:\xampp\mysql\data_old , copy everything and paste inside newly created data directory. You will get a warning just click on Skip these file like bellow image.

 

Step:4 -

Again go to C:\xampp\mysql\data_old , copy ibdata1 .

 

Step:5 -

Now go to C:\xampp\mysql\data paste the copied ibdata1 inside newly created data directory. You will get a warning just click on Replace the fies in the destination like bellow image.

 

Step:6 -

That's all. Open xampp and start MySQL  and see the problem is solved.

 

Hope this will help you a lot. Thanks