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 vote258 views1 answer
Sql constarint
SQL
0 vote316 views2 answers
Sqlalchemy default value for column
SQL
0 vote227 views1 answer
Oracle sql procedure return value
SQL
8 votes231 views1 answer
Oracle create datafile
SQL
2 votes241 views1 answer
Cast string to datetime mysql
SQL
0 vote235 views1 answer
How to install sql in anaconda
SQL
0 vote223 views1 answer
How to query all tables mysql at the same time
SQL
0 vote218 views1 answer
Sql server remove enter from string
SQL
0 vote222 views1 answer
Oracle call a function in a insert statement
SQL
5 votes204 views1 answer
Mongodb vs
SQL