How to fix Error: MySQL shutdown unexpectedly

by Anuj Kumar

---

This is a very common issue for developers. You can fix this issue without uninstalling the XAMPP.

Don’t delete ibdata1 file. Otherwise your database will be destroyed.

1. First Take the back of the MySQL backup folder (xampp/mysql/backup).
2. Rename the MySQL data folder to data_old (xampp/mysql/data to xampp/mysql/data_old).
3. Now create a new MySQL data(xampp/mysql/data) folder.
4. After that copy all data from the MySQL folder (xampp/mysql/) and paste in the data(xampp/mysql/backup) folder.
5. Now copy all the database folder from xampp/mysql/data_old and paste in the xampp/mysql/data folder .(except mysql, performance_schema, and phpmyadmin folders).
6. Copy xampp/mysql/data_old/ibdata1 paste into xampp/mysql/data folder.
7. After this restart the MySQL from the XAMPP Control panel.

Share

Tags: MySQL shutdown unexpectedly

---

• Next story Food Waste Management System Using PHP & MySQL
• Previous story Internet Service Provider Management System Using PHP and MySQL

You may also like...

---

• 

  How To Create a MySQL New User and Grant Permissions in Linux

• 

  MySQL Group By

• 

  MySQL NULL Values

• 

  MySQL LIMIT

• 

  MySQL LIKE

• 

  MySQL Between Operator

• 

  MySQL Order By

• 

  MySQL AND, OR, IN, NOT IN

• 

  MySQL Where Clause

• 

  MySQL SELECT DISTINCT

• 

  How to use mysql through cmd

• 

  How to Connect PHP with MySQL Database