XAMPP - Error: MySQL shutdown unexpectedly

First you need to keep copy of following somewhere in your hard disk.

C:\xampp\mysql\backup

C:\xampp\mysql\data

After that

Copy every thing inside "C:\xampp\mysql\backup" and paste and replace it in
"C:\xampp\mysql\data"

Now your mysql will work in phpmyadmin but your tables will show "Table not found in engine"

For this you will have to go to the copy of "backup and data folders" which have created in your hard disk and there in the data folder copy "ibdata1" file and past and replace in the "C:\xampp\mysql\data".

Now your tables data will be available.


Make sure you backup the mentioned folders before taking any action!

This worked for me,

  1. Quit the XAMPP
  2. Cut all files in C:\xampp\mysql\backup
  3. Paste and replace files into C:\xampp\mysql\data
  4. Run the XAMPP as administrator

In my case, I did two things:

  1. moved xampp/mysql/backup files into xampp/mysql/data
  2. RUN XAMPP as Administrator

It worked for me :)


If your skype is open, Quit skype and try,

or

Go to your xampp/wamp installed, search for httpd.conf. Open that file using textpad/notepad, search for Listen or 80 , update listen port to 8081 and save the file. Restart xampp/wamp, start the servers.


or
follow below steps in skype enter image description here

Tags:

Mysql

Xampp