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 vote339 views1 answer
Psql generate id in existing database
SQL
0 vote315 views1 answer
Oracle job schedules
SQL
1 vote322 views2 answers
Sql select only row with the max date
SQL
0 vote310 views2 answers
Mysql output csv
SQL
0 vote322 views1 answer
Oracle INTERVAL DAY to second to number
SQL
1 vote341 views3 answers
Rows, INSERT INTO
SQL
0 vote272 views1 answer
Mysql insert with foreign key
SQL
34 votes390 views6 answers
Alter table add foreign key mysql
SQL
1 vote353 views1 answer
Mamp mysql path mac
SQL
2 votes327 views6 answers
In operator in sql
SQL