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 votes132 views1 answer
Drop table purge
SQL
1 vote130 views1 answer
Copy postgres table from one schema into another
SQL
-1 vote143 views3 answers
Update mongodb version ubuntu
SQL
1 vote136 views1 answer
Mysql random limit 1
SQL
1 vote148 views1 answer
Select not matching data from two tables
SQL
2 votes138 views1 answer
Oracle find unusable indexes
SQL
2 votes128 views1 answer
Oracle sql drop table purge
SQL
1 vote144 views1 answer
Hackerrank sql test solutions
SQL
0 vote142 views2 answers
Sql auto update dupdated_at
SQL
5 votes145 views2 answers
Sql server check port number
SQL