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 vote313 views1 answer
Datetime postgres typeorm
SQL
13 votes288 views2 answers
Sqlite rename column
SQL
7 votes319 views4 answers
Lowest salary in sql
SQL
-1 vote312 views1 answer
Mysql select count if contains
SQL
1 vote314 views1 answer
Declare table variable
SQL
-2 votes304 views1 answer
Mysql see users and passwords
SQL
2 votes326 views1 answer
Ifnull postgres
SQL
0 vote326 views1 answer
How to select only a certain date sql
SQL
2 votes325 views2 answers
Sqlalchemy filter or
SQL
0 vote329 views1 answer
Mysql random number between 1 and 100
SQL