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 vote343 views1 answer
Sql server manager close connection
SQL
14 votes352 views3 answers
Oracle sql limit results
SQL
0 vote387 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote377 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
1 vote340 views1 answer
Mysql show table character set
SQL
1 vote331 views2 answers
Find a column in all tables mysql
SQL
0 vote332 views1 answer
Except in sql alchemy
SQL
0 vote370 views2 answers
Mysql update two tables at once
SQL
0 vote352 views1 answer
Create table Statement Syntax in SQL Server
SQL
2 votes371 views1 answer
Sql server: select column values as comma separated string
SQL