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 vote171 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
5 votes199 views1 answer
Oracle drop index if exists
SQL
0 vote193 views1 answer
Sql select where more than one record exists
SQL
0 vote190 views2 answers
Sql query in dax power bi
SQL
9 votes186 views3 answers
Mysql show table column full description
SQL
1 vote179 views3 answers
How to truncate foreign key constraint table
SQL
0 vote215 views1 answer
Mysql add text to existing field
SQL
3 votes177 views2 answers
Current year sql
SQL
0 vote187 views1 answer
How to select only id where is not in column mysql
SQL
1 vote252 views1 answer
Top 10 rows in mysql
SQL