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 vote247 views1 answer
Code to move ietms from one table to another myswl
SQL
8 votes247 views1 answer
See all users mysql
SQL
12 votes252 views5 answers
Rename table in mysql
SQL
0 vote243 views1 answer
Oracle sql log to console
SQL
0 vote252 views1 answer
Select milliseconds mysql
SQL
1 vote212 views1 answer
Sql auto timestamp
SQL
1 vote220 views1 answer
How to see all table partition in oracle
SQL
0 vote287 views1 answer
How to subquey to do not load in live database in
SQL
0 vote279 views3 answers
How to find all role in mysql
SQL
13 votes246 views1 answer
Views in sql
SQL