XAMPP - MySQL shutdown unexpectedly

Vidya KotturVidya Kottur
in MySQL

Method:1

  1. Go to C:\xampp\mysql\data
  2. You will see a folder named as mysql/data
  3. Rename that folder from mysql/data to something else like mysql/data_not_useful any name that you want to give.
  4. Create a new folder named as mysql/data.
  5. Copy all the files of the mysql/backup and paste in mysql/data.
  6. Now go to mysql/data_not_useful and copy the file ibdata1 from there.
  7. Then paste it in mysql/data (You have to replace the file).
  8. Restart your xampp server.
  9. Now run your mysql server.

Method:2

Port 3306 may running for other application so, check it out if any, kill(stop) them then Mysql will run on same 3306 port.

To check port details

  1. click on task bar
  2. open Task manager
  3. Details
  4. PID(port id) check for the port
  5. if any other application running right click on port id- End task

Method:3

1.Export project data from DATABASE

2. Delete data table file in mysql/data

3.Create database IMPORT all data

Tagged:
Sign In or Register to comment.