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 vote317 views1 answer
Sql server delete top 1000
SQL
20 votes281 views2 answers
Mysql bigint max value
SQL
16 votes304 views4 answers
Ascending order mysql
SQL
0 vote273 views1 answer
Postgres float to int
SQL
1 vote319 views1 answer
Psql filed name alter
SQL
1 vote283 views1 answer
Mysql Case sum
SQL
0 vote314 views1 answer
SQL Server date literal
SQL
0 vote289 views1 answer
Output table plsql
SQL
0 vote301 views1 answer
Oracle archivelog usage
SQL
1 vote275 views2 answers
How to drop a unique constraint in sql
SQL