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 vote366 views1 answer
Sql examples from framework
SQL
3 votes367 views2 answers
Sql select data from last week
SQL
0 vote330 views1 answer
How to see the query of a view in mysql
SQL
0 vote384 views2 answers
Sql day from datetime
SQL
1 vote439 views2 answers
Coderbyte sql solutions
SQL
0 vote353 views1 answer
Sql select rows with different values in one column
SQL
0 vote359 views1 answer
List all functions and procedures in postgres query
SQL
0 vote366 views1 answer
Allow external access to mysql
SQL
0 vote373 views1 answer
Stored function in sql
SQL
0 vote364 views1 answer
Mysql select smaller of two values
SQL