How to fix mysql stop unexpectedly

How to fix MySQL shutdown unexpectedly
Note: If you don’t do following very carefully there are chances you can lose your databases. So be very careful to follow point 1.

1. Rename the folder xampp/mysql/data to xamppmysql/data_bk
2. Create a new folder xampp/mysql/data
3. Copy the content that resides in xampp/mysql/backup to the new mysql/data folder
4. Copy all your database folders that are in xamppmysql/data_bk to xampp/mysql/data
   Important: Do not copy the mysql, performance_schema, and phpmyadmin folders from xampp/mysql/data_bk
5. Finally copy the ibdata1 file from xampp/mysql/data_bk and replace it inside xampp/mysql/data folder
Start MySQL from XAMPP control panel

Similar codes

0 vote256 views1 answer
Enable full text search mysql
SQL
2 votes258 views1 answer
How to show the whole table in sql
SQL
2 votes258 views1 answer
Add default sql server
SQL
0 vote255 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
3 votes263 views2 answers
Sql end of month
SQL
19 votes271 views6 answers
Create table sqlite
SQL
0 vote247 views1 answer
Get foreign table names mysql
SQL
1 vote254 views1 answer
Create table variable in sql stored procedure
SQL
8 votes248 views1 answer
Insert a select statement into a table
SQL
0 vote249 views1 answer
Sql query to select records entered in last 24 hours
SQL