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 vote121 views2 answers
Datetrunc hour snowflake
SQL
0 vote130 views1 answer
Mysql min value row
SQL
0 vote124 views1 answer
How get data from database if id not found then search another column
SQL
5 votes118 views3 answers
Mysql check if null or empty string
SQL
0 vote127 views1 answer
How to get nth number in sql
SQL
5 votes113 views5 answers
Find max number in sql
SQL
5 votes136 views2 answers
Mysql create database charset utf8mb4
SQL
3 votes129 views2 answers
Postgresql select all column names
SQL
0 vote114 views2 answers
Update information in a mysql column
SQL
2 votes111 views1 answer
Get first 3 letters name in sql
SQL