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 vote114 views1 answer
Set engine to innodb
SQL
0 vote121 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote105 views1 answer
Sqlalchemy query return only n results
SQL
1 vote98 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
-1 vote114 views1 answer
Pl sql drop trigger
SQL
56 votes289 views5 answers
Psql create user
SQL
1 vote121 views1 answer
Postgres power
SQL
0 vote112 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
6 votes128 views6 answers
Rename column postgres
SQL
14 votes132 views6 answers
Finding duplicate rows mysql
SQL