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 vote206 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote194 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote201 views1 answer
Commit transaction sql
SQL
0 vote262 views2 answers
Wordpress change url in database
SQL
0 vote214 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote311 views1 answer
Delet all record statment sql
SQL
0 vote195 views1 answer
Postgresql like
SQL
1 vote215 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote196 views1 answer
Sql server inner join convert collation
SQL
0 vote243 views1 answer
Mysql order by where condition sub query
SQL