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 vote206 views1 answer
Mysql shell set time_zone
SQL
1 vote253 views1 answer
Mysql stop password policy
SQL
0 vote196 views1 answer
Update one column from another column in same table
SQL
0 vote200 views1 answer
Plpgsql raise notice
SQL
0 vote205 views1 answer
Oracle running queries sql
SQL
19 votes209 views6 answers
Sql create table
SQL
0 vote188 views1 answer
Mysql case when null
SQL
0 vote231 views3 answers
Sql select statements
SQL
0 vote212 views2 answers
Import .sql into postgres db command
SQL
0 vote202 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL