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

-1 vote270 views1 answer
How to use update trigger in sql
SQL
1 vote289 views2 answers
Sql now - 1 day
SQL
0 vote250 views1 answer
Grant owner postgresql
SQL
0 vote308 views1 answer
Least spark sql
SQL
0 vote294 views1 answer
Edit shchima table in sql
SQL
0 vote264 views1 answer
Automate mysql cli query
SQL
1 vote299 views1 answer
Hackerrank sql test solutions
SQL
0 vote310 views1 answer
Sql multiple into
SQL
18 votes290 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
7 votes259 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL