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

2 votes158 views2 answers
Checking data type in sql server
SQL
0 vote181 views1 answer
Month mysql
SQL
0 vote157 views1 answer
Compression of dabatase mysqldumo
SQL
2 votes152 views1 answer
Express api ith mysql data
SQL
0 vote151 views2 answers
How to generate a unique random number in mysql
SQL
0 vote147 views1 answer
Disableforiegn key check
SQL
12 votes150 views1 answer
Docker run mysql image
SQL
0 vote157 views1 answer
Search In the Data using ObjectName
SQL
0 vote170 views1 answer
Postgres get running query
SQL
0 vote135 views1 answer
Sql server inner join convert collation
SQL