MySQL Shutdown Unexpectedly: How to Solve the XAMPP MySQL Error

MySQL Shutdown Unexpectedly How to Solve the XAMPP MySQL Error

As the name of the error implies, this is the message you see if the MySQL software on your environment shuts down or ceases to function unexpectedly:

Just follow these steps and its done.

  1. Rename the folder C:\xampp\mysql\data to C:\xampp\mysql\data_old (you can use any name)
  2. Create a new folder C:\xampp\mysql\data
  3. Copy the content that resides in C:\xampp\mysql\backup to the new C:\xampp\mysql\data folder
  4. Copy all your database folders that are in C:\xampp\mysql\data_old to C:\xampp\mysql\data (skip the mysql, performance_schema, and phpmyadmin folders from C:\xampp\mysql\data_old)
  5. Finally copy the ibdata1 file from C:\xampp\mysql\data_old and replace it inside C:\xampp\mysql\data folder
  6. Now Start MySQL from XAMPP control panel

And its all done, Enjoy..

Previous Article

Email Address Validation in HTML5, PHP, and JavaScript

Next Article

How to Embed Google Maps in WordPress Contact Form

Write a Comment

Leave a Comment

Your email address will not be published. Required fields are marked *

Subscribe to our Newsletter

Subscribe to our email newsletter to get the latest posts delivered right to your email.
Pure inspiration, zero spam ✨