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 vote198 views1 answer
Create boolean column in MySQL with false as default value?
SQL
1 vote178 views2 answers
Oracle list partitioned tables
SQL
0 vote191 views1 answer
Select all columns except one sql
SQL
0 vote171 views1 answer
Sql transact create cursor with dynamic tables
SQL
23 votes193 views6 answers
Create table sql server
SQL
1 vote165 views1 answer
Mysql date diff in seconds
SQL
1 vote191 views1 answer
Postgres set sequence value to max id
SQL
3 votes183 views1 answer
Locate sql server
SQL
0 vote187 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote201 views1 answer
Pl sql disable trigger
SQL