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 votes195 views3 answers
Postgresql reset auto increment
SQL
1 vote220 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
3 votes200 views3 answers
Start postgresql ubuntu
SQL
1 vote210 views1 answer
Psql import backup file for windows
SQL
2 votes200 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote187 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote201 views1 answer
T-SQL Never ending DELETE
SQL
0 vote195 views1 answer
Sql server insert inner join
SQL
5 votes209 views3 answers
Mysql remove unique constraint
SQL
3 votes189 views3 answers
List columns in table postgres
SQL