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

7 votes181 views3 answers
Python and mysql connectivity
SQL
0 vote162 views1 answer
Mysql get 2nd value in comma separated list
SQL
8 votes139 views1 answer
Similarities between ddl and dml
SQL
0 vote221 views3 answers
Call to undefined function mysql_connect()
SQL
7 votes166 views3 answers
Sql get last inserted row
SQL
2 votes182 views3 answers
Replace null in sql
SQL
2 votes172 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote204 views1 answer
How to find date from date table in sql
SQL
0 vote179 views1 answer
Postgresql copy backup table
SQL
13 votes181 views3 answers
Insert mysql ifile nto database
SQL