PostSparrow

MySql Error in Xampp MySQL shutdown unexpectedly

To solve Do this process -

Rename xampp/mysql/data to xampp/mysql/anyname_data (or any name of your choice)

Create a new folder and name it > data in xampp/mysql

Copy all your xampp/mysql/backup files and folder to newly created xampp/mysql/data folder

Now which previous database you want to work with copy that folder 
from xampp/mysql/anyname_data to newly created xampp/mysql/data folder


copy ibdata1 file from xampp/mysql/anyname_data To xampp/mysql/data

Restart Xampp with or without "run as administrator"

Now your database is intact in phpmyadmin.

In short language

1. Rename folder mysql/data to mysql/data_old

2. Make a copy of mysql/backup folder and name it as mysql/data

3. Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema, phpmyadmin,andtest folders)

4. Copy mysql/data_old/ibdata1 file into mysql/data folder

5. Start MySQL from XAMPP control panel