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

16 votes344 views1 answer
Mysql smallint range
SQL
0 vote328 views1 answer
Count characters of string mysql
SQL
-1 vote359 views1 answer
Create view in mysql workbench
SQL
0 vote355 views2 answers
Compound operator in sql
SQL
0 vote399 views1 answer
Oracle convert int to date
SQL
0 vote337 views1 answer
Mysql sql.gz
SQL
1 vote324 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
1 vote333 views1 answer
Too many connections mysql
SQL
2 votes304 views3 answers
Mysql cheat sheet
SQL
-1 vote357 views5 answers
Convert sql to linq query online
SQL