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

1 vote290 views1 answer
Get current date in pyspark sql
SQL
1 vote274 views1 answer
Partition by sql server
SQL
1 vote258 views3 answers
Grant syntax in sql
SQL
0 vote275 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote258 views1 answer
Sql case when exists in another table
SQL
0 vote247 views1 answer
MySQL error code 2068
SQL
0 vote273 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote335 views1 answer
Mysql get longest string in column
SQL
32 votes284 views6 answers
How to change column name in sql
SQL
3 votes303 views2 answers
Synonym oracle
SQL